![]() ![]() □ Click on the Add button on the ODBC Data Source Administrator dialog box. Open Control Panel □ Administrative tools □ ODBC Data Source Administrator (64-bit) □ Select System DSN The ODBC Data Source administrator MMC (Microsoft management console) is in the Administrative tools directory of the control panel. We can create a DSN by using the ODBC Data Source Administrator. We will create a DSN to access the oracle database using ODBC Driver. The DSN is used in any application that uses the ODBC driver to connect to the database. To view the data populated from the oracle database, I have installed the PowerBI for Desktop on my workstation. Once the schema is enabled, I have changed the password of the HR user. The HR schema is associated with the HR user, so we will enable the HR user by running the following query. I have enabled the HR schema of the ELTECH database. It is a sample database, and it contains the oracle sample schemas. When we install the oracle database on the workstation and the oracle database, the setup installs the client connectivity tools and drivers. I have installed oracle 19c on my workstation. How to configure the ODBC driver using ODBC Data Source AdministratorĬreate a sample PowerBI report to populate and view the data from the oracle database This article explains the process to configure the ODBC driver for oracle 19c. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |