Connect Telmai to a MySQL database hosted on-prem or in the cloud.
Creating a connection
To connect to MySQL, provide the following details:
Name: A display name for this connection
Description: Optional description
Database: The database name to connect to
Server: The hostname or IP address of the MySQL server
Port: The port MySQL is listening on (default: 3306)
Use SSL: Whether to require an SSL connection (true / false)
User: The username
Password: The password
MySQL connection form
In order to connect to a privately hosted instance, the customer will need to whitelist the IPs from Telmai. Please reach out to Telmai support for the updated list of IPs for whitelisting.
Connecting an asset
Once a connection is defined, you can start using it to create assets. Select an existing connection (or create a new one), then choose whether to create assets from an Existing Table or a Custom Query.
MySQL asset configuration step
Please ensure that your environment has whitelisted Telmai IP list.
