Loading External Data into Power Pivot - Microsoft Business Intelligence Tools for Excel Analysts - page 75

Open the Power Pivot window and click the From Other Sources button on the Home tab to open the
Table Import Wizard dialog box shown in Figure 4-11. Then select the appropriate relational database
system that you're using. For example, if you need to import data from Oracle, select Oracle. If you
need to import data from Sybase, select Sybase.
Figure 4-11: Activate the Table Import Wizard and select your target relational database system.
Connecting to any of these relational systems takes you through roughly the same steps you take
when importing SQL Server data. You may see some alternate dialog boxes based on the needs of
the database system you select.
Understandably, Microsoft cannot possibly create a named connection option for every database
system out there, so you may not find your database system listed. In that case, select the Others
(OLEDB/ODBC) option. Selecting this option opens the Table Import Wizard, starting with a screen
asking you to enter or paste the connection string for your database system (see Figure 4-12). Ask
your IT department for this connection string if you don't have it.