Unsolved
This post is more than 5 years old
35 Posts
0
1647
June 8th, 2016 06:00
How to make ODBC connection from Vipr SRM to CMDB
Hello - I'm trying to look for procedures to perform a ODBC connection from Vipr SRM to our Company CMDB and query details about Servers/Storage details, we have the JDBC connector setup today but since we are moving to ServiceNow Platform which does not support JDBC we are forced to use ODBC.
Below is the current JDBC syntax we use and i'm looking for a similar one to use for ODBC connection:
jdbc:jtds:sqlserver://SERVERNAME:1433/INFRA_Enterprise
net.sourceforge.jtds.jdbc.Driver
USERNAME
PASSWORD
SELECT DISTINCT
Query Statement continues....
No Events found!
dnorton1
74 Posts
0
June 9th, 2016 13:00
This isn't the right way to connect the systems. We don't support direct SQL access to the SRM DB. We have a SOAP XML interface that you can use to retrieve metrics (doc'd in APG-Web-Service-Tutorial.pdf in the “/opt/APG/doc/” directory). There's also an open-source CLI you can use to further automate this, available at https://github.com/emcvipr/mnrcli.
Starting with version 4.0 (available later this month) we're also adding a REST API.
Dan
Mahesh1111111
35 Posts
0
June 9th, 2016 20:00
Hi Norton - thanks for the information. Just so we both are on same page, im looking for an ODBC connection from SRM to our ServiceNow ODBC tool so we want to pull data from ServiceNow into SRM and not from SRM.
Sent from my Samsung device
Mahesh1111111
35 Posts
0
June 10th, 2016 06:00
Hi Norton – yes, the first option will not meet our requirement because we are pulling data for all the Servers/Storage/Switches in our environment and would like the query to be run once a day.
For the second option – I was able to install the ServiceNow ODBC driver and test the connectivity which is good, what is missing is how/what syntax and where do I run the SQL Query from SRM to create the CSV file that will eventually be used by SRM.
dnorton1
74 Posts
0
June 10th, 2016 06:00
Ah, so you want to go the other way around. In that case you have a few options:
- Pull the data from ServiceNow out into a .CSV and bring it in via Data Enrichment. This is probably the easiest way if it's a one-time or infrequent pull.
- Create a collector using the SQL collector and pull the data in programmatically (essentially treating ServiceNow like another device that you're collecting from). This is a bit more involved.
Dan