Creating the Oracle data source

About this task

When you have verified that the JDBC Provider is configured properly, the data source for BigFix® Remote Control must be created using that JDBC Provider.

To create the data source complete the following steps:

Procedure

  1. Select Resources > JDBC > Data Sources.
  2. Select the scope with Node and Server.
  3. Click New.
  4. Specify the data source information
    1. Specify the data source information.
      Data source name
      Specify a name for the data source. This can be any required name.
      JNDI Name
      This should be set to jdbc/trcdb
      Note: If this name is changed, further changes to the common.properties file are also required.
      Click Next.
    2. Select JDBC provider

      Click Select Existing JDBC provider and select Oracle JDBC Driver. Click Next.

    3. Enter database specific properties for the data source.
      URL
      url=jdbc:oracle:thin@dbserver:1521:SID

      where dbserver is the IP address of the server.

      SID is the Oracle database SID.

      Data store helper class name
      Accept the default Data store helper class name, Oracle 11g.data store helper.
      Accept remaining default selected values and click Next.
    4. Set up security aliases
      1. Select Component-managed authentication alias and select the alias you previously created for Oracle.
      2. Accept the default of none in the remaining lists.
      3. Click Next.
    5. On the summary screen, click Finish to create the data source.
  5. Click Save.

    You can select the newly created datasource and click Test, to test connectivity.