Fetch Data From Configured Salesforce / BigQuery / Snowflake / JDBC / ODBC Database Connector

Abacus.AI allows you to connect your database connector and train models using data read directly from them. Once the connection is configured, following steps can be used to get data:

  1. After creating a new project and selecting the use case, proceed to the "Datasets" tab and click on the "Create Dataset" button.
    DataFromDBConnectors

  2. Then, click on the "Create New" button.
    DataFromDBConnectors

  3. Write a name for the dataset, select the appropriate type of data, and click on "Continue".
    DataFromDBConnectors

  4. Select "Import from External Service" option and choose your database connector from the options available under "Database Connectors" as shown in the picture below:
    DataFromDBConnectors

  5. Finally, select the "Object Name" of the dataset you want to upload and enter all the column names you want to import in the "Columns" section. You can also perform dataset transformations using the "Query Arguments" section. Finally, click on "Add Dataset" button.
    DataFromDBConnectors


  1. The dataset will be uploaded successfully as shown in the picture below. Configure the schema mapping and train models using the uploaded data.
    DataFromDBConnectors