SQL format
From Piki
The SQL format is an input format that imports data from an MSSQL compatible database.
| SQL file format | |
 | |
| Deployable | Yes |
| Type | Database |
Contents |
Usage
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.
Date parsing
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 |
|---|
|
Modes:
- 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.
General advice
- The SQL format only works with Microsoft SQL compatible databases.
- A free version of the Microsoft SQL 2005 database engine can be downloaded here.
See also
- Input format - Article covering input formats in general.
- Data unit - Article covering the data unit fundamentals.
- List of Input format components - List of all available input format components.