The SQL format is an input format that imports data from an MSSQL compatible database.
|SQL file format|
The SQL Database format allows you to connect to a database and collect the data you wish to use in Synapse
Wizard: Step 1
|First step in the wizard|
In the server textbox, enter the address of the SQL server and provide the authentication details below it. Connect to the database by pressing "Connect".
In the "Selected Database" dropdown, choose the database you wish to read from. When finished press "Next". If you wish Synapse to remember your login details check the "Remember settings" checkbox (login details are encrypted with 512-bit strong encryption and saved in the config file).
Wizard: Step 2
|Second step in the wizard|
In the "SQL Command" textbox enter your SQL query and press "Execute". You will see the results of your query in the data grid. In the list box you can see the list of available tables. If you double click on a table name, it will be added to the command box. Once you have gotten the data you want, press "Next".
Wizard: Step 3
|Third step in the wizard|
In the final window of the wizard you can select how string data is handled and what percentage of data you wish to put aside for validation. Pressing the "Apply" button will execute the string translation.
If there are features containing date/time information you can configure how they are to be parsed by clicking on the "Configure dates.." button.
|Date/Time parsing option|
- Absolute - Number of time units since 0001-01-01 00:00:00
- Time units elapsed between date time and <date> - Time units between the chosen date and the parsed date.
- Direct - Date string as a double.
- Periodic - Periodic representation using two variables, Cos(a), Sin(a) where a 0->2 pi and the period is 2pi.
- The SQL format only works with Microsoft SQL compatible databases.
- A free version of the Microsoft SQL 2005 database engine can be downloaded here.