Use IDEA ODBC Driver to create User or System DSNs (32-bit or 64-bit) that can be used to connect other applications to your IDEA databases so that you can create visualizations and reports outside of IDEA in tools such as PowerBI, Tableau, and Excel, etc.
1. Install ODBC Drivers
From the IDEA installation package, navigate to and double-click ODBCDriver_Setup.exe. The IDEA ODBC Driver installation wizard appears or downloads from Passport.
If you are prompted to install prerequisite software, click Install
In the Welcome screen, click Next.
In the License Agreement screen, select the option to accept the terms and click Next.
In the Destination Folder screen, accept or change the destination folder and then click Next.
In the Ready to Install the Program screen, click Install.
In the Completed screen, click Finish
2. Create a user or system DSN
In Windows, access the ODBC Data Source Administrator.
The ODBC Data Source Administrator is available in 32-bit or 64-bit. Select the one that matches the bitness of the application into which you want to import the IDEA database.
Click either the User DSN tab or the System DSN tab.
In the Create New Data Source screen, select IDEA ODBC Driver and click Finish.
In the Data source name field, enter the name you want to use for the data source.
In the Description field, enter a description for the data source.
Click the Browse button adjacent to the Data directory field.
Navigate to and select the directory that contains the database to be connected to the data source.
You are returned to the IDEA ODBC Driver Setup dialog box. The directory and path information is displayed in the Data directory field.
The following instructions are an example of how to connect an IDEA data source in PowerBI.
You will see data loaded in PoweBI.