clinicgaq.blogg.se

Port: The port used to connect to the server hosting the Oracle database.Once you've done this, set the following to connect:

The native DLLs can be found in the lib folder inside the installation directory. To connect to Oracle, you'll first need to update your PATH variable and ensure it contains a folder location that includes the native DLLs. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.

This is the last step of the driver installation. If you have not already, first specify connection properties in an ODBC DSN (data source name). This article details how to use the ODBC driver to import Oracle data into Microsoft Power Query. The CData ODBC Driver for Oracle enables you to link to Oracle data in Microsoft Power Query, ensuring that you see any updates.