![]() ![]() At the prompt, type "help" to display a list of tables.TargetDSN = my_servicenow_odbc_data_source Point the data source at the ServiceNow ODBC driver data source. Create an ODBC-ODBC Bridge Client data source in /etc/odbc.ini.On the Linux or UNIX machine, install the ODBC-ODBC Bridge Client.If you configured a 64-bit ServiceNow ODBC data source, in Windows Services, stop the ODBC-ODBC Bridge Service (which is 32-bit) and start the ODBC-ODBC Bridge 圆4 service.Install the ODBC-ODBC Bridge Server on the machine where the ServiceNow ODBC driver is installed.If you want to query ServiceNow from Linux and UNIX applications, you can use the Easysoft ODBC-ODBC Bridge to do this: Connecting to ServiceNow via ODBC from Linux and UNIX The ODBC driver enables you to query your instance database from a variety of Windows client applications. Use the ServiceNow Interactive SQL utility to issue some test queries. Use the Test button in the ODBC driver configuration dialog box to test the connection. Complete the driver configuration dialog box.Īfter configuring the ODBC driver, check that you can use the driver to connect to your ServiceNow instance as the ODBC user and can query data from a ServiceNow table. To do this, in the Windows Run dialog box, enter: odbcad32.exeĬhoose the System Tab, and then choose Add. If your client application is 64-bit, run the 64-bit ODBC Data Source Administrator. To do this, in the Windows Run dialog box, enter: %windir%\syswow64\odbcad32.exe If your client application is 32-bit, run the 32-bit ODBC Data Source Administrator. You configure ODBC data sources in ODBC Data Source Administrator. You now need to create an ODBC data source, which will enable your client application to connect to ServiceNow. Use the ServiceNow ODBC Management Console to do this. The ServiceNow ODBC driver distribution includes both a 32-bit and 64-bit driver, and so you can use it with both 32-bit and 64-bit applications.Īfter installing the ODBC driver, configure it to connect to your ServiceNow instance and to communicate through a proxy server. Define an ACL rule for the ODBC role to provide access to the ServiceNow tables that you want to query.ĭownload and install the ServiceNow ODBC driver on your Windows client machine.The ODBC role contains various additional roles, including the soap_query role required to make ODBC requests. In ServiceNow, create an ODBC user account. ![]() The Service ODBC driver is available for Windows platforms, and requires a Java Runtime Environment (JRE) to be installed on the same machine.īecause the ODBC driver uses the web services interface, platform-wide access control (ACL) is maintained and data security is in place.īefore installing the ServiceNow ODBC driver: You cannot use it to modify your ServiceNow instance data. The ODBC driver supports SQL SELECT statements and read-only SQL functions. The ServiceNow ODBC driver gives you read-only access to the database associated with your ServiceNow instance. Connecting to ServiceNow via ODBC from Windows This ODBC driver can be used with the Easysoft ODBC-ODBC Bridge to enable ServiceNow to be accessed from Linux and UNIX applications. ServiceNow provide an ODBC driver which enables Windows applications such as SQL Server to query a ServiceNow instance. Analytics, Business Intelligence and Reporting.ServiceNow solutions fall into categories such as: ServiceNow is a cloud-based platform that provides enterprise solutions. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |