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:

  1. Click on Settings in the left-hand main menu, and then on Data connectors > Create new data connector. You can find this button on the top right corner of the screen.

    Data catalog workflow overview


  2. 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. For Databases, you can choose from MySQL, PostgreSQL, Oracle, or DB2, and for Cloud storage, you can choose from Azure, AWS, or GCP. Click Proceed to confirm your selection.

    Data catalog workflow overview


  3. 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 either SID, SERVICE_NAME or TNS_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.

    Data catalog workflow overview
    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.

    Data catalog workflow overview
    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.

    Data catalog workflow overview
    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.

    Data catalog workflow overview

    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.

    Data catalog workflow overview
    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.

    Data catalog workflow overview
    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.

    Data catalog workflow overview

  4. 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.

    Data catalog workflow overview


  5. Click Save after you verified the connection. MOSTLY AI will let you know that the data connector has been saved. You can now click on Go to Data Catalogs to create a data catalog for this newly created connector, or click on Back to Data Connectors to view the list of available data connectors.

    Data catalog workflow overview


  6. 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 click Delete Data Connector to do so.

    Data catalog workflow overview