Accessing the Open Metadata Interpreter

The Open Metadata Interpreter (OMI) is a feature of Interactive Reporting database connection files—files that enables Interactive Reporting Studio to manage database connectivity. OMI is implemented using the Metadata Definition dialog box of the Database Connection Wizard.

  To open the Metadata Definition dialog box:

  1. If Interactive Reporting Studio is not connected to a database, select the Interactive Reporting database connection files that you want to direct to the metadata source and log on.

  2. Select Tools, then Connection, and then Modify.

    The Database Connection Wizard is launched with the Meta Connection Wizard displayed.

  3. Select whether to run the Meta Connection Wizard on the current connection or on a different connection.

    If you select a different connection, the Select Metadata Interactive Reporting database connection field becomes active.

    1. Enter the full path and file name of the Interactive Reporting database connection file that you want to use. You can also click Browse to navigate to the location of the Interactive Reporting database connection file.

    2. Click Next.

      The Password dialog box is displayed.

    3. Enter the database name in the Host Name field and the database password in the Host Password field and click OK.

    4. Select the current database name and password to make the metadata connection or to specify an alternate name and password.

      If you specify an alternate user name and password, enter the name and password that you want to use for the metadata connection.

  4. Click Next.

  5. Select the metadata schema where the meta settings are stored from the drop-down box.

    Metadata schema are provided by third party vendors and saved in the bqmeta0.ini file. When you select a metadata schema, the predefined schema populates the fields in the Metadata Definition dialog box and is saved to the Interactive Reporting database connection file. If you select another schema, the metadata definitions are overwritten in the Interactive Reporting database connection file.

    If you want to customize the metadata settings, select Custom from the drop-down box and click Edit. The Metadata Definition dialog box is displayed, which contains tabs for tables, columns, joins, lookup, and remarks.

    For detailed explanations of the metadata definitions, see Configuring the Open Metadata Interpreter.

  6. Enter the schema name or owner of the metadata repository table (for custom settings) or click Next to complete the Meta Connection Wizard and return to the Data Connection Wizard.