Use a SQL Server database for synthetic data
To use a Microsoft SQL Server database as a source for original data as well as a destination to deliver synthetic data, you need to create SQL Server connectors.
For each SQL Server data source or destination, you need a separate connector.
Prerequisites
- Obtain the SQL Server connection details:
- Host
- Port
- Credentials
- Database name
- To use the Synthetic Data SDK in Local mode, install the ODBC driver:
- For Linux, see Installing ODBC driver on Linux.
- For macOS, see Installing ODBC driver on macOS.
Create a new SQL Server connector from the Connectors page.
- From the Connectors page, select Microsoft SQL Server under the Connect your data header.
- On the New connector modal, configure the connector.
| Field | Description |
|---|---|
| Name | Enter a name that you can distinguish from other connectors. |
| Access type | Select whether you want to use the connector as a source or destination. |
| Host | The SQL Server database hostname. |
| Port | The database port. The default port for SQL Server databases is 1433. |
| Username | The SQL Server database username. |
| Password | The SQL Server database password. |
| Database | The name of the database. |
- Click Save to save your new SQL Server connector.
- MOSTLY AI tests the connection. If you see an error, check the connection details, update them, and click Save again.
- You can click Save anyway to save the connector and disregard any errors.
- MOSTLY AI tests the connection. If you see an error, check the connection details, update them, and click Save again.
What’s next
Depending on whether you created a source or a destination connector, you can use the connector as:
- Data source for a new generator
- Data destination for a new synthetic dataset