Export Angle with ODBC Driver
This datastore allows you to export Angles to all major database management systems, including:
- Microsoft SQL Server
- MySQL
- PostgreSQL
- Oracle
- Microsoft Excel
- Microsoft Access
The database management system needs to be installed on your system. Make sure to install the 64 bit version of the database system. When you export to Microsoft Access, the exported record length cannot exceed 4K. Otherwise the task will fail, but no details and report tabs will be created in the Action failed message.
To export an Angle with an ODBC Driver
In ITMC, go to Angle Exports > Datastores.
Click Add new datastore.
Select Export Angle with ODBC Driver.
Click OK. The Create datastore window appears.
Enter the Datastore name.
ODBC Connection String - Every database system provides a string that can be used to connect it to ODBC. Note that it is also possible to create a system data source name (System DSN) which you can enter instead of the ODBC connection string.
Click Test connection to test if the location is available.
Note: Note that you can choose to leave the following settings empty and instead enter their specifications in Automation tasks when you schedule the execution.
Insert model timestamp - Specify in which column the model timestamp should be inserted. Use '1' to select the first column, '2' to select the second column, and so forth. Select 'None' if no model timestamp column is required.
Header format - Select a format for the column headers:
No header - When No header is selected, no column header is shown, only raw data.
Id - When Id is selected, the IDs of the fields will be used as column headers. This option is most useful when the output file is used for further automatic processing, like in databases or CSV.
Short name - When the Short name is selected, it is shown in the column header.
Long name - When the Long name is selected, it is shown in the column header.
Set format - Select a format for the set elements:
Id - When Id is selected, the IDs of the set elements will be exported. This option is most useful when the output is used for further automatic processing, like in databases or CSV.
Display - When Display is selected, the set elements in the export will be formatted as defined in the AngleDisplay. This means, 'short', 'short (long)' or 'long' column names will be used. This option is most useful when the output is used for direct interpretation, like in Excel or HTML format.
Max rows to export - When exporting data only the specified number of rows will be exported. If the result contains more rows, remaining rows will be skipped. Use value -1 to export all rows.
Table name - Name of the target table. This table will be created if it does not exist already.
Deletion timeout [seconds] - Number of seconds before a timeout occurs when the database is deleting and recreating a table.
Append result - Append result to output table. When checked, the data will be appended to the existing table or file. If the file/table does not yet exist, it will be created. When unchecked, a new file or table will be created on every run. When the file/table already exists, it will be overwritten. Note that when append is disabled, the table will be recreated for every run. Macros can be used to include the Angle name, Display name and/or timestamp.