Use a SQL Server database for synthetic data

If you use the web application, create a new SQL Server connector from the Connectors page.

Steps

1. From the Connectors tab, click Create connector.
2. From the Create a new connector window, select Microsoft SQL Server.
3. From the New connector window, configure the connector.
   1. For Name, enter a name that you can distinguish from other connectors.
   2. For Access type, select whether you want to use the connector as a source or destination.
   3. For Host, enter the SQL Server database hostname.
   4. For Port, enter the database port.
      The default port for SQL Server databases is 1433.

   5. For Username and Password, enter your SQL Server database credentials.
   6. For Database, enter the name of the database.
4. 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 disregarding any errors.

Available in both Local and Client modes.

Use mostly.connect() to create a SQL Server connector. Define a connector configuration dictionary as shown below.

from mostlyai.sdk import MostlyAI
 
mostly = MostlyAI(local=True)
 
c = mostly.connect({
    "name": "MS SQL Server Connector",
    "type": "MSSQL",
    "access_type": "SOURCE",
    "config": {
        "host": "mssql.hostname.com",
        "port": "1433",
        "username": "admin",
    },
    "secrets": {
        "password": "******"
    },
    "test_connection": True
})

The SDK tests the connection to the MS SQL database, and if successful, the connector is created.

If you see an error, check the connection details and try again.