Push the data from the Form to external database

[Bartosz Nowak2]

Hello Community,

I'm looking for the solution for one of my requirements that all of the data what are filled on the form need to be pushed to the external database, can someone help me with that? Is it possible using the workflow ? Any examples? (SQL Server database)

[Shivani Singh1]

Hello Bartosz,

You will require a small integration for this requirement, it can be SOAP/REST/Export Set

This should be fulfilled through an export set if you have required information and approach.

Please go through this link to finalize what fits most to your instance/requirement.

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/export-sets/concept...

Let me know in case of any concerns

[Pranesh072]

this will help you 

Copying Service-Now data on-site for reporting purposes

[Giles Lewis]

Hi Bartosz.

ServiceNow does not have the ability to write directly to an external database (e.g. SQL Server) using ODBC or JDBC. If the database has an exposed Web Service that allows records to be inserted, then you can call that Web Service. However, most database management systems do not provide such a service out-of-box.

Export Sets allow you to write an external file on a schedule (e.g. once/day). You then need to write a separate import process to load the file into your database.

There are various third-party products that will replicate your ServiceNow data to an external database on a schedule (e.g. daily or hourly). Please refer to this recent post for a discussion on some options:

https://community.servicenow.com/community?id=community_question&sys_id=76af370adba968506621d9d9689619e3