How to configure Microsoft Excel to connect to an Oracle Database

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
4,303
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Dec 2, 2010

Mike van der Velden, Product Manager at Simba Technologies, provides a step-by-step guide for configuring Microsoft Excel to connect with Oracle Database OLAP Option. Mike walks through the one-time set-up of Oracle's Transparent Networking Substrate (TNS), followed by the Data Source Name (DSN) and Office Data Connection (.odc). Once configured, Microsoft Excel connects easily to Oracle Database OLAP Option for ad hoc data query, data analysis and BI reporting.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (1)

Sign In or Sign Up now to post a comment!
  • This is very helpful. However, we are using Oracel R12, it seems that we could not locate the TNS on "Environment Variable" which you explained at the beginning. Any idea?

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more