Below are the steps to create a workschema:

  1. On the side menu, click DATA SOURCES.
  2. Click Workschema + at the top-right corner.
  3. In the New Workschema screen, complete the following details:
    • Name. Enter a name for the workschema connection.
    • Data Source Type. The type of DB connection –either Oracle or PostgreSQL.
    • UserName. Enter a username that you will use to connect to the database.
    • Password. Enter the password of the database user.
    • Host Name. Enter the hostname of the database (Oracle or PostgreSQL)
    • Port. Enter the port number of the database. The default port of PostgreqSQL database is 6070 and Oracle database is 1521.
    • SID/Service Name (Oracle only). Enter the unique system Id of the Oracle database or the service name by which client connects to the Oracle database.
    • Driver Type (Oracle only). Select the type of driver to use for establishing the connection to Oracle database. Select any one of the following options:
      • Direct. This is a type 4 driver that converts JDBC calls into a network protocol that sends the converted packets to be used directly by the Oracle database. Thus, allowing a direct call from the client machine to the DBMS server. 
      • OCI. The OCI driver is a type 2 JDBC driver and uses native code to connect to the Oracle database. Thus, it is only an option on platforms that have native Oracle drivers available.  
    • Connection Timeout. Allows you to set timeout in seconds for the ETL Server to make an attempt to establish connection. 
  4. Click Test to verify whether the connection is successful.
  5. Click Save to create the workschema.

© Datagaps. All rights reserved.
Send feedback on this topic to Datagaps Support