![]() If a SID is required, specify it by using the format ServerName/SID, where SID is the unique name of the database. In the Oracle database dialog that appears, specify the Oracle Server to connect to in Server. Select the Oracle database option in the data sources selection. In Navigator, select the data you require, then either select Load to load the data or Transform Data to transform the data.Ĭonnect to an Oracle database from Power Query Online For more information about authentication, go to Authentication with a data source. ![]() If this is the first time you're connecting to this Oracle database, select the authentication type you want to use, and then enter your credentials. To learn more about DirectQuery, go to Use DirectQuery in Power BI Desktop. The rest of these example steps use the Import data connectivity mode. If you're connecting from Power BI Desktop, select either the Import or DirectQuery data connectivity mode. If you are using a local database, or autonomous database connections, you may need to place the server name in quotation marks to avoid connection errors. If the ServerName/SID format doesn't work, use ServerName/ServiceName, where ServiceName is the alias you use to connect. Specify the Oracle Server to connect to in Server. Select the Oracle database option in the connector selection. ![]() ![]() To make the connection, take the following steps: Capabilities SupportedĬonnect to an Oracle database from Power Query Desktop For more information, go to Manage your data source - Oracle. The Oracle client software you use depends on the Oracle server version, but will always match the 64-bit gateway. ![]() To connect to an Oracle database with the on-premises data gateway, the correct Oracle client software must be installed on the computer running the gateway. Make sure that checkbox is selected so that Power Query can connect to your Oracle database. Some versions of the Oracle client wizard selects the checkbox by default, others do'nt. During the setup of the Oracle client, make sure you enable Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level by selecting the corresponding checkbox during the setup wizard. Choose the Windows installer of the Oracle Client. For instance, ODAC 12.x doesn't always support Oracle Server version 9. Choose a version of Oracle Data Access Client (ODAC) that's compatible with your Oracle Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |