Creating an Encoded Connection File

You can create an encoded connection file by following these instructions:

  1. Create a Filename.ini text file that contains at least one line using one of these format specifications:
    dxegenloadfile (-i option) or dxeexport
    Format specification is TYPE,ALIAS,SCHEMA,USERID,PASSWORD where:
    • TYPE is ORACLE or ODBC
    • ALIAS is either your ODBC DSN or Oracle TNS alias
    • SCHEMA is your schema name that contains your tables
    • USERID and PASSWORD are the user credentials to connect to ALIAS
    dxegenloadfile example - ODBC,TUTORIAL,SRC,INSTALL,1
    This example uses ODBC extension to connect to DSN TUTORIAL with supplied user credentials, and retrieves table information from the schema SRC, so dxegenloadfile can create files for consumption by the Distributed Loader.
    dxeexport example - ODBC,Dist KB for DX 4.0,DX40,install,1
    This example uses ODBC extension to connect to DSN Dist KB for DX 4.0 with supplied user credentials, and retrieve knowledgebase information, allowing dxeexport to create required files for dxestart to mask and subset your data.
    dxestart (-i option or -o option)
    Format specification is TYPE,ALIAS,SCHEMA,USERID,PASSWORD where:
    • TYPE is ORACLE or ODBC
    • ALIAS is either your ODBC DSN or Oracle TNS alias
    • SCHEMA is your schema name that contains your tables
    • USERID and PASSWORD are the user credentials to connect to ALIAS
    dxestart -i option example - ODBC,TUTORIAL,SRC,INSTALL,1
    This example uses ODBC extension to connect to DSN TUTORIAL with supplied user credentials, and is the source data store (input). The source data store is be masked, subsetted, and placed in the target data store.
    dxestart -o option example - ODBC,Dist KB for DX 4.0,DX40,install,1
    This example uses ODBC extension to connect to DSN Dist KB for DX 4.0 with supplied user credentials, and is the target data store (output). The source data store is masked, subsetted, and placed in the target data store.
    Note: For any of these formats, you can optionally add ,,,,, to the end of the specification.
  2. Encode a Filename.ini file with dxeencrypt to create an encoded Filename.rc file. For example, from a command prompt, enter:

    dxeencrypt Filename.ini

  3. Use an encoded .rc file with dxegenloadfile, dxeexport, or dxestart.