3/21/2024 0 Comments Oracle database version querySpecify 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. ArchivesCategories |