Can we connect servicenow to external database?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2018 10:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2018 10:09 AM
You can send data from and to ServiceNow using the integration apis. REST is most common.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-23-2018 10:43 AM
https://docs.servicenow.com/bundle/kingston-application-development/page/integrate/odbc-driver/concept/c_ODBCDriver.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2018 02:02 AM
Hi guptashalini0412,
Take a look at the web serviced docs. You have soap, rest web services.
Also ServiceNow can import data from external sources through JDBC/LDAP/File. These can be configured to retrieve data from a database and load that data into an import set table for transformation into your desired target table in ServiceNow. You'll most likely need a MID server to facilitate the connection to the database as well.
SOAP Web Service - ServiceNow Wiki
Best Regards,
Ashvini Kadus.
Hope this helps. Kindly mark helpful/correct.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2021 08:41 AM
We recently published a 30-page guide for building this integration:
http://www.perspectium.com/diy
Building it with web services is viable for fairly small, one-off integrations.
Scalability can be a challenge, though. As the company grows, you'll need to transfer more data. Inevitably, these transfers will impact ServiceNow performance. The integration can time out, queries can be too large, and queries can be too frequent.
You'll also want to build the integration with data accuracy, security, and configurability in mind.
We deal with all these issues, among others, in the guide.
