The option to connect to an ODBC data source can be one of most convenient ways to connect to your Data Sources. This document will attempt to quickly guide you thought the process of connecting to a Microsoft ODBC data source.
Adding the Data Source to ODBC
On the system where iDashboards is installed you will need to navigate to the 32-bit instance of the ODBC Data Source Administrator if the system is 64-bit. The way to tell if you’re not sure is to look at the files names.
If your system is 64-bit, you will have the option for SysWOW64 under the C:\Windows directory. C:\Windows\SysWOW64\odbcad32.exe.
If you do not see a SysWOW64 directory then the system is using a 32-bit operating system. C:\Windows\System32\odbcad32.exe.
Regardless if you’re using 32-bit or 64-bit windows the exe that you’re going to want to run is odbcad32.exe. Once you have run the exe you will want to select ‘System DSN’ tab.
Adding DSN Connections
Click on the ‘Add’ button. You will see a list of ODBC drivers installed on the system. If you do not see the driver you need you might need, go back and install the 32-bit driver version you will need for your connection. You will need to contact your software provider for their ODBC 32-bit drivers.
Click the ‘Finish’ button to continue the next screen. Depending on the data source you’re adding the next screen will differ in format.
Two different data source types
The format is different but they all will need the same basic fields filled in.
- Name (Required) – This will be the name we use to call the connection from iDashboards.
- Description (Not required) – Shows up on the ODBC screen to help identify the connection.
- Data Source (Required) – Some allow you to just select the source other you will have to navigate to file. If the file is not located on the iDashboards system, you will need to change the Tomcat service or iDashboards service to run under a network admin with the rights to the share location.
Creating the Connection to iDashboards
Navigate to the iDashboards Admin Console. After you login, you will have the option to click on the ‘Data Sources’ tab. On the Data Source screen, use the dropdown box to select Generic ODBC driver form the “(new)” dropdown.
Click the Add Data Source button. The next screen you will see is for the connection information.
For most connection all you need to enter is:
- Data Source Name: (How you want the data source to show up in iDashboards.)
- DSN (This was the name that we gave the data source.)
- User ID and Password are not required unless the data source requires login.
- Private Cloud
- X Platform
- Enterprise Suite