BulkCopy from ServiceNow

shikhar1sharma
Giga Contributor

Hi,

 

We have a current .net application where we do SQLBulkCopy by adding an ODBC driver on ServiceNow server.

Now I wanted to migrate the code to Java and have to bulk copy the data from ServiceNow as well. I found out that even Java support BulkCopy . I have two options how to fetch data from Service Now:

1. Use ServiceNow provide REST APIs or 

2. Use the ODBC drive approach which I have explained above.

 

By reading online, people prefer to use APIs over ODBC option. Can I use Java SQLServerBulkCopy with the ServiceNow API? 
Can anyone help me with the best option for my usecase?

 

Thanks

0 REPLIES 0