To create a connection to your system, follow these steps:
- Navigate to Settings
> Data Ingestion > Connections.
- In the top-right corner, click New connection, find your system, and click Connect.
General configuration
In the general connection configuration step:
- 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. - Provide a description of the connection’s purpose.
- 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.
- Click Next.
Server configuration
In the server configuration step, provide the following information:
- Name: Host address of your MySQL server, e.g.,
mysql.mycompany.com. - Port: The network port used by the MySQL server for connections. The default port is
3306. - Authentication credentials:
- User Name: Username of the user created in Prepare for MySQL integration.
- 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.
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.