Access Data outside of ServiceNow Tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 12:54 PM
Hello,
I've been asked if it's possible to access Data from external tables in our instance.
Example: We have our Club Location Data stored in a SQL database on one of our on prem Servers.
Is it possible to access that data without pulling it all in to ServiceNow? In SharePoint we build data connection and query fields.
How would this be done in ServiceNow?
- Labels:
-
Integrations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 12:56 PM
I don't think that's possible especially if your data lives behind a firewall. ServiceNow is in the cloud (for the majority of customers) and would not have access to read or query the data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 12:59 PM
Since you don't have a storage limit in ServiceNow, I would recommend pulling the data into ServiceNow with a MID server integration and then you can use it freely in ServiceNow. Are there reasons this method would not work?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 01:00 PM
Couldn't the MID Server help with that firewall issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2016 01:02 PM
The issue is the effort it takes to set up the process of updating the servicenow tables from the source data. We have 3 pretty long jobs currently. We're working to enhance them. If ServiceNow can act similar to "PowerApps" where you can access almost any table directly, it would help us make decisions more easily.
