Ocient

Connect and register your Ocient DB databases and tables

The Ocient connector allows you to virtually connect and register your Ocient databases, and then query on them, manage them and federate them, without having to physically move them into a central location.

Connect Ocient via NDP Fabric Builder

Connect Ocient via SQL Editor

Connect Ocient via NDP Fabric Builder

Step 1: Click the Data Fabric Builder icon.

Step 2: Under Database Sources click the '+' next to Virtual Database Source to launch the wizard.

Step 3: When the GUI wizard launches accept the defaults and click Next.

Step 4: Specify the following values for the connection:

• Datasource: Other JDBC
• Data Source Name: any_datasource_name
• JDBC Driver Class: com.ocient.jdbc.JDBCDriver
• JDBC Url: Expressed in the following form

jdbc:ocient://{host}:{port}/{database}

• Parameters:
  schema: {schema name}

Example Ocient DB Connection

Click Next.

Step 6: On the summary dialogue click Register.

Step 7: The Ocient Database source should now apppear under the Virtual Database Sources on the left hand panel

Connect Ocient via SQL Editor

The syntax to connect to Ocient via SQL Editor is shown below

CREATE DATASOURCE OCIENT DESCRIBE BY "OCIENT Database" OPTIONS (
  jdbcdriver "com.ocient.jdbc.JDBCDriver",
  jdbcurl "jdbc:ocient://{host}:{port}/{database}",
  username "{username}" ,
  password "{password}",
  schema "{schema name}"
);

REGISTER DATASOURCE TABLES FROM OCIENT;