Solved

Foxtrot Support for Azure SQL

  • 18 November 2019
  • 1 reply
  • 3 views

Badge +5

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.

 

5587i1AC0D8A087F4C622.png5588i1F152ECCC05FD074.png

icon

Best answer by mbalslow 19 November 2019, 15:20

View original

1 reply

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.


 


Reply