How to setup an Azure SQL database as a data source

tmparks01
Tera Contributor

‎08-02-2022 05:55 AM

I cannot find any documentation on how to setup a data source for importing data from an Azure SQL database. We have several on premise JDBC connections, but I am not having any luck setting up a connection to Azure. The account I am using is able to connect to the DB via SQL Management Studio from our mid server just fine.

Labels:
0 Helpfuls
  • 907 Views
3 REPLIES 3

Kristy Merriam
Administrator
Administrator

‎08-02-2022 03:09 PM

Are you getting any specific error messages when you try to connect to the Azure SQL database from the platform?

Have you looked at potentially using a Data Stream action to import the data? https://docs.servicenow.com/bundle/sandiego-application-development/page/administer/integrationhub/concept/data-stream-actions.html

0 Helpfuls

tmparks01
Tera Contributor
In response to Kristy Merriam

‎09-16-2022 11:39 AM

I was able to setup a data stream action. The JDBC test works just fine and I see the SQL columns, however I get "Failed to iterate on data stream: null" when I test the action itself.

0 Helpfuls

Kristy Merriam
Administrator
Administrator
In response to tmparks01

‎09-19-2022 05:52 AM

Make sure your Parsing step is correct. Are you using a JSON/XML Splitter or a Script step? Can you share the script if that is what you're using?