ServiceNow and Oracle Integration

Blazi Kanku
Kilo Contributor

Hi, I am looking for the best way to load ServiceNow data to Oracle. I am using Table API to extract few ITSM tables to Oracle(incident table is one of them). I am using Python for this. My main concern is the API performance when I have to load 200k+ data into Oracle via paginated API call. It takes about 45 mins to load a single table. Is there a better way to to perform this integration? Once I am done with full load, is there a way to perform delta loads? Any advice/recommendations would be really appreciated. Please let me know if you need any more details. 

Thank you for your time. 

 

 

4 REPLIES 4

Community Alums
Not applicable

Hi @Blazi Kanku ,

It is possible to integrate a ServiceNow instance with Oracle database. You can use webservices, ServiceNow support both SOAP and REST web services. As far as MID server is concerned, you can use it when you have no direct access to the database server let's say due to firewall/security access.

You can also use JDBC :

Refer to this thread :https://community.servicenow.com/community?id=community_question&sys_id=90f0f382db3d0910e515c2230596...

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

Community Alums
Not applicable

Hi @Blazi Kanku ,

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

hedgekhaja33
Tera Contributor

Hi,

 

We are looking to send a table from ServiceNow to oracle database, what would be the best way to do this? Any help would be appreciated.

 

Thanks,

 

MichaelTomar
Tera Contributor

I used Skyvia (a 3rd party ETL tool) to integrate ServiceNow and Oracle data. As I remember, it took some time to perform the initial data load, but the subsequent data loads were rather fast. This service supports incremental updates and significantly boosts the overall performance.