Export data from ServiceNow to external DB

erantal2000
Giga Contributor

Hello guys,

I am trying to create a periodic process that exports some data from ServiceNow to a database in my organization.

As I understand - the "data source" object is used to do the opposite - to import data from external sources to serviceNow.

We have a mid-server installed here but we can't figure out what is the best practice in order to make that kind of integration.

I will appreciate any tips.

Thanks

Eran

1 ACCEPTED SOLUTION

bernyalvarado
Mega Sage

Hi Eran, the following should be helpful and really insightful for what you're trying to accomplish:


Copying Service-Now data on-site for reporting purposes



Kudos to Paul Hicks Paul Hicks for such a great sharing!



Thanks,


Berny


View solution in original post

7 REPLIES 7

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Eran,



Please go through the below link for more info.


http://wiki.servicenow.com/index.php?title=Web_Services


Hi Pradeep,



Thank you very much for your help, however... this is not what I was looking for. What I need is a kind of ETL solution. The problem is that I may have a lot of records to export every day - something like 15K records. A web service approach here may take hours to run. I need to find a different approach 😞



Thanks again


Eran


akzm
ServiceNow Employee
ServiceNow Employee

Hi Eran,



This feature (to have a scheduled/periodic data export to mid server) will be available in upcoming release "Geneva".



Thanks.



Azfar


erantal2000
Giga Contributor

Thank you very much Azfar. So right now my only way to solve this is one record at a time by using a web service?