Solved

Foxtrot Support for Azure SQL

  • 18 November 2019
  • 1 reply
  • 0 views

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.



 



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