+5I'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.
Best answer by mbalslow
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.