cancel
Showing results for 
Search instead for 
Did you mean: 
cholslin
Nintex Newbie

Foxtrot Support for Azure SQL

Jump to solution

I'm using the Open SQL function of Foxtrot RPA and I'm noticing it cannot detect Tables in SQL Azure. It doesn't let me either select a table, nor does a SELECT [Field] FROM [Table] command work as it reports that [Table] is an invalid object. Will support for SQL Azure be coming in the near future? I checked the roadmap, but did not see anything relevant.

 

Version number is 15.0.1.  Screen shots below.

 

Capture.PNGCapture2.PNG

Labels: (1)
0 Kudos
Reply
1 Reply
mbalslow
Nintex Newbie

Re: Foxtrot Support for Azure SQL

Jump to solution

Hi!

I have supported another client with this same issue and we were able to solve it.

 

It seems that your connection was successful since you got access to the database. I would suggest creating an SQL connection (not Data - SQL) and then use Execute SQL action to query the table you need.

We have made some material on how to use SQL in Foxtrot:

https://support.foxtrotalliance.com/hc/en-us/articles/360020502872-How-To-Work-With-SQL-in-Foxtrot 
https://support.foxtrotalliance.com/hc/en-us/articles/115004158085-How-To-Use-SQL-Queries

How to write queries in Foxtrot, then the syntax can vary a little depending on the DBMS you are using, but it is fully supported by Foxtrot. See attached/below a screenshot of INSERT command in both Foxtrot and Microsoft SQL Server Management Studio.

 

SQL Example.PNG

View solution in original post

Reply