Model data can be imported from an SQL database into Enterprise Studio using an SQL connection.
To be able to import data from an SQL database the following requirements apply:
- A primary key must have been defined for the database tables. The tables need a column for identification.
- You have read access to at least the following database tables, depending on the database type you are working with:
- IBM DB2: syscat_tables and syscat.columns (only tested for Windows, Linux is unknown)
- SQL Server or MySQL: information_schema.tables and information_schema.columns
- You have read access to the database tables you want to import from, including referenced tables.
To import model data from one or more SQL tables into Enterprise Studio using an SQL connection, click the
Before data is exported, the connection is validated first, unless validation has been deactivated in the settings of the connection. In case errors are found you are notified. You can ignore these, but you are advised to resolve the errors first. If you want to continue the import without resolving the errors, it may result in an incomplete data import or no import at all.
The mappings are executed in the specified order.
After the import has finished, the Import from SQL window appears showing a summary of the import in a table. It is similar to the summary of a ServiceNow import.