Adding SQL Connector mounts

Adding an SQL Connector mount involves specifying the database to which you want to connect and configuring the tables that users can access through WorldServer.

Procedure

  1. In WorldServer, go to Management > Asset Interface System > AIS Mounts.
  2. Select Add.
  3. On the Mount: New page, under Generic Configuration, do the following:
    1. In the Name box, enter the name of the mount that you want to add.
    2. In the Type list, select SQL Connector.
  4. Under SQL Connector Configuration, do the following:
    1. In the Database Type list, select the type of database to which you want to connect.
      Database typeFields available under SQL Connector ConfigurationDescription
      Microsoft SQL ServerDatabase ServerEnter the name of the machine on which the SQL database is installed.
      Database NameEnter the name of the database to which you want to connect.
      Instance NameIf the database has named instances, enter the name of the specific instance to which you want to connect. If the database does not have such instances, use the Default value.
      PortEnter the number of the port on which the database instance is listening.
      Hide NULL values for translatable columnsSelect this check box to hide the fields containing null values from the view. If you clear the check box, all the fields are displayed, regardless of their value.
      OracleDatabase ServerEnter the name of the machine on which the SQL database is installed.
      PortEnter the number of the port on which the database instance is listening.
      SIDEnter the Oracle System ID (SID) of your database.
      Hide NULL values for translatable columnsSelect this check box to hide the fields containing null values from the view. If you clear the check box, all the fields are displayed, regardless of their value.
      OtherJDBC Driver classEnter the name of the Java class that implements the JDBC driver for your database.
      Driver URLEnter the URL pointing to the database instance.
      Hide NULL values for translatable columnsSelect this check box to hide the fields containing null values from the view. If you clear the check box, all the fields are displayed, regardless of their value.
  5. Under Login Information, enter the credentials (user name and password) that you want WorldServer to use when it connects to the database.
  6. Under SQL Table Configuration, configure SQL tables, SQL columns, and the SQL Identifier Hierarchy.
  7. Select Save.