Data connectors enable you to connect to your company’s data sources. MOSTLY AI supports read and write operations to Azure, GCP, and AWS cloud storage buckets, and MySQL, PostgreSQL, Oracle, and DB2 databases.
To synthesize databases, you’ll need to create two data connectors—one for the source and another for the destination. The destination database also needs to have the appropriate write permissions configured. |
To configure a data connector, just follow these few simple steps below:
-
Click on
Settings
in the left-hand main menu, and then onData connectors
>Create new data connector
. You can find this button on the top right corner of the screen. -
A modal appears where you can configure the new data connector.
First, you need to select the type of data source you want to connect to. ForDatabases
, you can choose from MySQL, PostgreSQL, Oracle, or DB2, and forCloud storage
, you can choose from Azure, AWS, or GCP. ClickProceed
to confirm your selection. -
A form will then appear where you can fill out the authentication details for the selected data source. Please select the appropriate instructions for filling out these fields from the list below.
Database
Oracle
-
Data connector name
You can optionally enter a name for this data connector. This will help with finding the right connector when creating a data catalog.
-
Hostname
Enter the hostname of the database server.
-
Port
Enter the port of the database server.
-
Connection type
Specify eitherSID
,SERVICE_NAME
orTNS_SERVICE_NAME
.
-
Username
Enter the username for the database you want to connect to.
-
Password
Enter the password for this username.
-
Name of the database
Enter the name of the database you want to connect to.
MS SQL Server
-
Data connector name
You can optionally enter a name for this data connector. This will help with finding the right connector when creating a data catalog.
-
Hostname
Enter the hostname of the database server.
-
Username
Enter the username for the database you want to connect to.
-
Password
Enter the password for this username.
-
Name of the database
Enter the name of the database you want to connect to.
PostgreSQL
-
Data connector name
You can optionally enter a name for this data connector. This will help with finding the right connector when creating a data catalog.
-
Hostname
Enter the hostname of the database server.
-
Username
Enter the username for the database you want to connect to.
-
Password
Enter the password for this username.
-
Name of the database
Enter the name of the database you want to connect to.
DB2
-
Data connector name
You can optionally enter a name for this data connector. This will help with finding the right connector when creating a data catalog.
-
Hostname
Enter the hostname of the database server.
-
Username
Enter the username for the database you want to connect to.
-
Password
Enter the password for this username.
-
Name of the database
Enter the name of the database you want to connect to.
Cloud storage
Azure
-
Data connector name
You can optionally enter a name for this data connector. This will help with finding the right connector when creating a data catalog.
-
Account name
Enter the storage account name.
-
Account key
Enter the storage account key.
-
Container
Enter the address of the container you want to connect to.
AWS
-
Data connector name
You can optionally enter a name for this data connector. This will help with finding the right connector when creating a data catalog.
-
Access key
Enter the Access Key ID for the user created for use with MOSTLY AI.
-
Secret key
Enter the Secret Access Key for the user created for use with MOSTLY AI.
-
Region
Enter the region where the bucket is located.
-
Bucket name
Enter the name of your Amazon S3 bucket.
GCP
-
Data connector name
You can optionally enter a name for this data connector. This will help with finding the right connector when creating a data catalog.
-
User/Service-Account Credentials JSON
Paste the JSON with your user or service account credentials in this field.
-
Bucket name
Enter the name of the bucket.
-
-
Once you filled out all the fields, you can click
Test connection
to verify the authentication details. MOSTLY AI will indicate whether it can connect to the database. -
Click
Save
after you verified the connection. MOSTLY AI will let you know that the data connector has been saved. You can now click onGo to Data Catalogs
to create a data catalog for this newly created connector, or click onBack to Data Connectors
to view the list of available data connectors. -
You can see your newly created data connector if you choose to go back to the
Data connectors
settings page. Here, you can click on it to review the authentication details, edit them or delete the connector. Use the pen icon or open the kebab menu and clickDelete Data Connector
to do so.