Page tree
Skip to end of metadata
Go to start of metadata

You must create a new external DB connection to connect to any of the external databases. You can use this connection while configuring the ETL.

The communication channel between the TrueSight Capacity Optimization components and the external databases can be in TCP or TLS 1.2 mode.

  1. Click Administration > ETL & SYSTEM TASKS > External DB connections
  2. Click Add connection. The External DB connections page is displayed.
  3. Type the following details:

      Note

      Basic properties  are displayed by default in the  External DB connections page. These are the most common properties that you can set.
      Property Value
      Datasource parameters
      Name Specify the name for the external datasource connection. 
      Description (Optional) Enter a brief description for this connection.
      Datasource type

      Select a database type from the drop down list.

      Database user 

      Enter the database user name.

      Database password

      Enter the database password. 

      Host name Enter the hostname where the DB is running.
      Port Enter the port number that will be used to access the DB on the specified Host name.
      (For Oracle) SID / Service name Select SID or Service name. Based on the selection, specify the SID or Service name.
      (For PostgreSQL) Database name Enter the name of the PostgreSQL datasource.
      (For Microsoft SQL Server and Sybase) Port Enter the port number that will be used to access the DB on the specified Host name.
      (For Microsoft SQL Server and Sybase) Database name Enter the name of the datasource.
      (For Microsoft SQL Server and Sybase) TDS version Enter the TDS protocol version number.
      (For Oracle, PostgreSQL, Microsoft SQL Server) Use SSL/TLS Select Yes if you want to use a secured TLS compliant connection. Else, select No.
      (For PostgreSQL) Server certificate name Enter the name of the external database certificate that you imported into the truststore. For example, extdatabase.crt.
      (For Microsoft SQL Server) Instance Enter the instance information of the Microsoft SQL Server datasource.
      (For other databases) JDBC URL Enter the JDBC URL.
      (For other databases) DBI URL Enter the database interface module URL.
      (For other databases) JDBC driver

      Specify the JDBC driver information.

      Note

      To connect to another database type, verify that the correct driver is installed on the Capacity Optimization server running this ETL. For an ETL in Perl code, install an appropriate DBD driver. For an ETL in Java code, install an appropriate JDBC driver.

      Task groups selection
      Task group

      Assign the external DB connection to a task group. Select tasks from Available and click to add them to Selected. You can reorder the tasks.

      Note

      To view or configure Advanced properties, click Advanced. You do not need to set or modify these properties unless you want to change the way the connection works. These properties are for advanced users and scenarios only.

      Property Value
      Datasource parameters
      Database prefix This is applicable for all databases. Enter the database prefix.
      JDBC prefix This is applicable for Oracle, PostgreSQL, Microsoft SQL Server, and Sybase databases. Enter the JDBC prefix.
      (For Microsoft SQL Server and Sybase) Driver type Select the driver type; Default or JDTS.
    • Click Save.

      Additional info

      You can edit the connection using . You can delete a connection using .