To create a connection to your system, follow these steps:

  1. Navigate to Settings inline-svg-1 > Data Ingestion > Connections.
  2. In the top-right corner, click New connection, find your system, and click Connect.

General configuration

In the general connection configuration step:

  1. Name your connection for easier identification in Dawiso. Use a unique, descriptive name, for example a combination of the server name and environment, such as server1_prod.
  2. Provide a description of the connection’s purpose.
  3. Select a Connection type.
    • Shared: The source is accessible from the public internet, and you can share your credentials with Dawiso.
    • Private: The source isn’t accessible from the public internet, and you can’t share your credentials with Dawiso. For more information, see Create a private connection.
  4. Click Next.

Server configuration

In the server configuration step, provide the following information:

  1. Name: Host address of your MySQL server, e.g., mysql.mycompany.com.
  2. Port: The network port used by the MySQL server for connections. The default port is 3306.
  3. Authentication credentials:
    1. User Name: Username of the user created in Prepare for MySQL integration.
    2. Password: Password to your user.

Optional and additional settings

Both Optional Settings and Additional Settings for your connection are optional:

  • Optional Settings: Specify options supported by the provider in JSON format.
  • Additional Settings: A JSON formatted list of additional settings for troubleshooting or advanced connection configuration. Leave this field empty unless Dawiso support asks you to change it.

Enter optional settings as valid JSON.

Test and save connection

If your connection is shared, click Test connection and wait a few seconds.

  • If successful, a green checkmark appears next to the button.
  • If it fails, a red error icon appears. Hover over it for a detailed error message. See the troubleshooting section for more information. You can still save the connection.
Tip

If your connection is private and you used dummy credentials, the connection test fails.

Finally, click Save and continue to the next step: creating a data source, where you specify what metadata to ingest.