ODBC

ODBC

Creating ODBC Dataset

To create any RDBMS or Non-RDBMS Dataset using ODBC, follow the steps 1 and 2 given in Creating SQL Dataset .

The following figure shows the Product Selection page.


The Data Connect page for choosing your dataset type is displayed.

From the RDBMS options, select ODBC.

The following figure shows RDBMS options.


Create ODBC Dataset page is displayed.


Notes:

  • As seen in the figure, you can create the PostgreSQL, SQL, MySQL, and Oracle datasets independently.
  • Using the ODBC option, you can create above four RDBMS datasets
  • Following two Non-RDBMS datasets: SAP HANA and MongoDB
  • You must select the required Dataset from the Type dropdown on the Create ODBC Dataset page.
  • If you select PostgreSQL, SQL, MySQL, and Oracle types, the fields on the ODBC dataset creation page change.
  • The fields are identical to those in the individual dataset creation pages, as explained in the respective sections.
  • For details, refer to the following sections.


  1. Enter a suitable Name for the Dataset.
  2. In the Connection Parameter section, enter the following details.
    1. Type (Select the dataset type from available options) 
      The Available options are: -
      1. PostgreSQL
      2. SQL
      3. MySQL
      4. Oracle
      5. SAP HANA
      6. MongoDB
      7. Snowflake
      8. Vertica
    2. Host (IP address of the server where your database resides)
    3. Port (for the localhost on which the ODBC database service is available)
    4. Username (of the account authorized to access the database)
    5. Password (of the account)
    6. Database (name to access schema(s) and the table(s))
  3. Click Test Connection. The message "Database Connection Successful" is displayed in green if the parameters are accurate. After a successful connection, the Schema dropdown is populated with a list of available schemas. 
  4. From the Schema dropdown, select the schema(s) that contains your table(s) and click Done. After selecting the schema(s), the Select Tables dropdown is populated with a list of all available tables in the schema(s). 
  5. From the Select Tables dropdown, select the required tables and click Done. 
  6. To add a custom query to select data from the tables, click Add Custom Query. Refer to Adding A Custom Query for details. 

  7. Click Create. The ODBC dataset is created in Rubiscape and is available for use in your workbooks and workflows. 

    Notes
    • For more information on MongoDB custom query, refer Query Your Data
    • The default port is displayed in the Port field and auto-selected while creating the Dataset. You can change the port before making a connection. 
    • You can select multiple schemas from the available options in the Schema dropdown. 
    • You can select multiple tables from the available options in the Select Tables dropdown. 
    • The selection of schema is optional. If you do not select any schema, all tables in all the schemas are populated in the Select Table dropdown. 
    • After you enter the Database name, the Select Schema dropdown and Select Tables dropdown are populated with a list of all available schemas and tables respectively.
    • Enabling the "Disable Cache" option allows you to create a dataset without generating a dataset cache.
      • When you select to "Disable Cache", the dashboard will not offer the "Enable Direct Query" option. For more information, please refer to the "Enable Direct Query" document.

    • Related Articles

    • Error Message in RDBMS

      The error messages are displayed in the following scenarios: Scenario 1: When you click Create button without entering any fields, you see the following errors: The error message for mandatory fields like Dataset name, Host name, and table name. ...

    • Sequence Generator

      Sequence Generator is located under Model Studio ( ) in Data Preparation, in the task pane on the left. Use the drag-and-drop method (or double-click on the node) to use the algorithm in the canvas. Click the algorithm to view and select different ...

    • RubiSQL

      RubiSQL is a feature within Code Fusion that helps write code in SQL to modify the values in your database. It also allows you to delete values in your database. You can use the RubiSQL node as a stand-alone node or connect it to the Reader node ...

    • Writing into Template Table

      You can store the result of algorithm flow or the Reader to a dataset table. Note: You can write to an RDBMS or ODBC (SQL, MySQL, PostgreSQL, or Oracle) datasets only. To write the output data to a template table, follow the steps given below. Build ...

    • RubiSQL

      RubiSQL is a feature within Code Fusion that helps write code in SQL to modify the values in your database. It also allows you to delete values in your database. You can use the RubiSQL node as a stand-alone node or connect it to the Reader node ...