Defining a Data Source via the Configuration File

Follow these steps to define a data source and populate the client control tables:

Note: This procedure assumes that either DBServer or Enterprise Server is running and that your signon parameters are configured appropriately.

  1. Because the following dbridge.cfg parameters are difficult to change later without redefining and recloning, make sure that they're set appropriately before you run the define command:

    allow_nulls

    clr_dup_extr_recs
    default_user_columns
    dflt_history_columns
    enable_dms_links
    external_column
    flatten_all_occurs

    force_aa_only
    maximum_columns
    min_varchar
    read_null_records
    sec_tab_column_mask

    split_varfmt_dataset
    use_bigint (SQL Server only)
    use_binary_aa
    use_clob (Oracle only)
    use_clustered_index (SQL Server only)
    use_column_prefixes
    use_decimal_aa
    use_date (SQL Server 2008 only)
    use_datetime2 (SQL Server 2008 only)
    use_nullable_dates
    use_primary_key
    use_time (SQL Server 2008)
    use_varchar

    For information on setting these parameters, see Appendix D.

  2. Enter the following command:

    dbutility [signon_options misc_options] define datasource hostname portnumber

    Where

    Is

    signon_options

    For each DATABridge Client type, the following command-line options sign on to the relational database:

    SQL Server or DB2:

    [-U userid] [-P password] [-O ODBCdatasource]

    Oracle:

    [-U userid] [-P password] [-D database]

    misc_options

    Any of the following miscellaneous command-line options:

    -L forces the client to use a new log file for this run.

    -T fileprefix to specify a prefix to be used instead of the default trace file prefix "trace".

    -f filename to specify a configuration file other than the default dbridge.cfg file in the working directory.

    -u allows the command to delete client control table entries for a data source that already exists.

    datasource

    For DBServer: The name that matches the entry for SOURCE in the DBServer control file. You can enter the data source name in uppercase or lowercase.

    For DBEnterprise: The name of a source (base or filtered) defined in Enterprise Server.

    hostname

    The domain name or IP address of the appropriate DATABridge server (DBServer or DBEnterprise).

    portnumber

    The TCP/IP port number on which the appropriate DATABridge server (DBServer or DBEnterprise) listens for incoming calls.

    For DMSII databases that have a large number of data sets and data items, the process of retrieving the layout information may take several minutes.

  3. Read the following section, Results of the Define Command, and then specify which data sets and data items you do not want to be cloned or updated, as explained in Customizing with User Scripts.

Example

Assuming the DBServer control file contains SOURCE ORDDB and PORT=5001 on the host "OURHOST.CIN.AAA.COM", you would enter the following:

dbutility define ORDDB OURHOST.CIN.AAA.COM 5001

The DATABridge Client calls DBServer to get DMSII database layout information. DBServer returns the DMSII layout information to the Client. The Client populates the control tables with the DMSII layout information and creates the corresponding relational database table layout.

The empty control tables (that were built during the dbutility configure command) are now populated.

For example, this SQL statement

select data_source, hostname, hostport from DATASOURCES

would yield a table similar to the following. Only the selected columns are shown.

data_source   hostname               hostport   

------------  ---------------------  ------

ORDDB         OURHOST.CIN.AAA.COM    5001