This article explains how to import data from SQL servers and how to execute queries from Foxtrot. Make sure to read this article to get some tips on how to write SQL Queries.
There are two ways of working with data from an SQL server:
- Set an SQL connection and use the SQL actions (Recommended)
To set an SQL connection go to the Project pane and select SQL. Foxtrot will require you to know:
- The Server name
- The Connection Port
- Type of authentication (SQL or Windows) and your credentials (username and password) for SQL authentication
You can set up as many SQL connections as you wish
Once you set up a connection, it will appear in the project pane under SQL
Next, you can execute an SQL query by using the "Execute SQL" action.
The output can be saved in different ways:
- to a list in Foxtrot
- to a file on your computer (.accdb, .csv, .xls, .xlsx)
- to a database file (.accdb), that you can process using the "Open Data" action