Export Angle to Microsoft SQL Server

To export an Angle to a Microsoft SQL server

1. In ITMC, go to Angle Exports > Datastores.

2. Click Add new datastore.

3. Select Export Angle to Microsoft SQL server.

4. Click OK.

   The Create datastore window appears.

5. Enter the Datastore name.

6. Server name - Name of the database server. Use localhost when the database is running on the Application Server. Add instance name when not using the default instance, for example, localhost\SQLEXPRESS. Use a comma to specify a custom port, for example, localhost\SQLEXPRESS,1435. If you do not specify a port, the default SQL port 1433 will be used.

7. User name - Account name of the database user.

   This user requires the following roles in the target Microsoft SQL database:

   • db_datareader
   • db_datawriter
   • db_ddladmin (the authorization to delete (DROP) and create tables)
   • public

8. Password - Password for the database user.

9. Database name - Name of the database.

10. Use Integrated Security - Check this field in order to use the Application Server's service user credentials to connect to the database server.

11. 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.

12. 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.

13. 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.

14. 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.

15. 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.

16. Table name - Name of the target table. This table will be created if it does not exist already.

17. Deletion timeout [seconds] - Number of seconds before a timeout occurs when the database is deleting and recreating a table.

18. Export type - Select export type:

    • Overwrite - Result rows will replace all previous exported results.

    • Append - Result rows will be appended to previous exported results.

    • Update - Result rows will update the changed values in previous exported rows, and insert new rows.

Caution: Switching export type between runs is currently not supported

19. Click Save.