cannot find ODBC Administrator after installing ODBC Driver

[AirSquire]

In order to replicate ODBC installation for my client I installed ODBC in my personal laptop, I cannot find "ODBC Administrator" in ServiceNow ODBC folder created in start menu. I am using MS Win 10 64-bit

[gauravchoudhury]

Hi Dhruv,

For starters, you can refer to the tutorial video on "Getting started with ODBC".

• Getting started with ODBCThe ServiceNow Open Database Connectivity (ODBC) driver provides read-only access to the database associated with your ServiceNow instance.
• Installing the ODBC driverReview setup requirements, download the ODBC driver installer, and install the driver to a computer.
• Configure the ODBC driverAfter installing the ODBC driver, configure it to connect to your ServiceNow instance and to communicate through a proxy server if applicable, and set properties to control ODBC behavior.
• Test the ODBC driverAfter configuring the ODBC driver, test that the driver can connect to the ServiceNow ITSA Suite instance as the ODBC user and can query data from a target table.
• ODBC behaviorAfter testing the ODBC driver you can use it to query your instance database from a variety of client applications.
• ODBC and client applicationsSee the following pages for examples of how to use the ODBC driver to create data sources from other applications.

[Rajesh Mushke]

Hi Dhruv,

Here is the procedure for installation and Testing of ODBC Driver :

Test the ODBC driver

After configuring the ODBC driver, test that the driver can connect to the ServiceNow ITSA Suite instance as the ODBC user and can query data from a target table.

About this task

To test the connection, run the ODBC Administrator program.

Procedure

1. In Windows, navigate to Start > Programs > ServiceNow ODBC > ODBC Administrator.The ServiceNow ODBC data source is installed as a system data source.
2. Select the System DSN tab, and then select the ServiceNow data source.
3. Click Configure.
   
   
4. Click Test Connect in the ODBC driver Setup dialog box.
   
   
5. Enter the login credentials.These are the usual ServiceNow ITSA Suitelogin credentials for the ODBC user you created.
   
   
6. Click OK to log in to the data source.
7. Click OK again when the success message appears.

• Enable debug loggingIf you experience unexpected behavior when using the ODBC driver, you can enable debug logging and generate debug logs to help identify the issue.
• Test a queryTo verify that the user has the appropriate permissions to send requests to the instance using ODBC, run a query using Interactive SQL.
• ODBC troubleshootingReview these troubleshooting resources to resolve issues with the ODBC driver.

Installing the ODBC driver

Install the ODBC driver for the first time.

1. Right-click the executable and select Run as Administrator to launch the installer.
   You are presented with the following InstallShield dialog box.
   
2. Click Next.
3. Read and accept the End User License Agreement.
4. Select the target directory for installing the ServiceNow ODBC driver.The default directory is C:\Program Files\Service-now\ODBC.
5. Specify the following parameters, which are required to create an ODBC data source that can be used to create a DSN.Data Source Name: a short name to identify this data source.Description: a short description of the driver. The driver's version number is appended at the end of this value.Service Name: the name that can be selected in the Service Name field of the ODBC Administrator.Service Data Source: the name that can be selected in the Service Data Source field of the ODBC Administrator.

   Usually the default values are appropriate.

   
   
   
6. Select the Program Folder to create links for the driver. This is the program folder that appears under the Start menu.The installation creates the following links in the menu.The driver code is copied to the target folder.A progress bar appears.
   • Interactive SQL (ODBC): an interactive SQL command window for directly testing SQL statements.
   • Management Console: a Microsoft MMC snap-in for configuring default properties for the ODBC driver.
   • ODBC Administrator: a Microsoft ODBC Administrator program.
7. When prompted, click Finish to complete the installation.

• Upgrading the ODBC driverIf you have previously installed an older version of the ODBC driver, run the installer to uninstall the previous version, and then run the installer again to upgrade.

Upgrading the ODBC driver

If you have previously installed an older version of the ODBC driver, run the installer to uninstall the previous version, and then run the installer again to upgrade.

About this task

To check the build date and time of the ODBC driver, use CheckVersion located in the Service-Now\ODBC\ip\tools folder. This is an executableWindows host script that reports the build date and time of the current ODBC driver. Use it to assist ServiceNow Technical Support to determine which build of the ODBC driver is running. If the CheckVersion tool is absent, the ODBC driver is out of date; upgrade to the current version. To check the version of an older ODBC driver, see the previous version information.

Note: The ODBC installation also has a Service-Now\ODBC\tools folder, which is not the correct path for the CheckVersion tool.

Procedure

1. Right-click the executable and select Run as Administrator.
   
   
2. Click OK when prompted to uninstall the current driver, which is required for the upgrade.A list appears, displaying the existing ODBC DSN names that you have previously created. You have the option to delete them.
3. Select Yes to remove all previous DSNs or No to keep them for use with the upgraded driver.An ODBC DSN is a connection handle to use the ODBC driver in an application. For more information from Microsoft, see:
   • http://office.microsoft.com/en-us/access-help/administer-odbc-data-sources-HA010275550.aspx
   • http://windows.microsoft.com/en-US/windows7/Using-the-ODBC-Data-Source-Administrator
4. After removing the previous ODBC driver, double-click the executable again to run the installer. Then, follow the steps in Installing the ODBC driver.If you encounter errors when uninstalling the ODBC driver, refer to the troubleshooting uninstalling ODBC knowledge article.

What to do next

After installing the ODBC driver, configure it to connect to your ServiceNow instance.

Please Refer :

Upgrading the ODBC driver

Upgrading the ODBC driver

https://docs.servicenow.com/bundle/helsinki-servicenow-platform/page/integrate/odbc-driver/task/t_Te...

[Rajesh Mushke]

Hello dhruvchoudhary

Any update on thread?

Hope your query is been answered , so please close this thread.

Would you mind please close this thread.

Let me know if that answered your question. If so, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list. Visit How To Mark Answers Correct From Community Inbox

Thanks in Advance............

[AirSquire]

Hi Rajesh,

All the above steps mentioned by you and Gaurav was known to me. The issue was I wasnt able to find the ODBC Administrator in the start menu, for which no one answered.

Thanks

Dhruv