Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 1,098 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?