X hits on this document





120 / 131

that it is dedicated to SAS as target.

Reverse- Engineer


Reverse engineering Knowledge Module to retrieve the table and view structures in SAS (columns only).

Specific Requirements

Knowledge Modules for SAS leverage the SAS/CONNECT and SAS/BASE utilities. Therefore, both these modules should be installed on the machine running the Oracle Data Integrator Agent.

The Knowledge Modules also use the SAS interpreter to run SAS commands. You should know the location of the SAS interpreter (It is called sas.exe on Windows platforms) and provide it to the Knowledge Modules in the SAS_COMMAND KM option.

See the SAS documentations for more information on SAS/CONNECT and SAS/BASE configuration.

Note: Oracle Data integrator does not use the JDBC/ODBC drivers from the SAS/SHARE package. This component is not available on all SAS versions.

The following topics can help you configure these Knowledge Modules for SAS.

Obtaining a SAS Username and Password

You should ask the SAS Administrator for a valid username and password to connect to the SAS server. This user should have enough privileges to read/write data to the data libraries and to read/write and create objects in the work libraries. Typically, an administrator account could be used. You should also ask for the SAS server name.

Configuring Oracle Data Integrator for SAS

The following restrictions apply when using the SAS Knowledge Modules:

  • 1.

    The JDBC URL of your SAS server (in the JDBC Tab of the Topology) must contain the path to the SAS/CONNECT Signon script used to connect to the SAS server. For example: p:\oracle\sas\saslink\tcpunix.scr.

  • 2.

    The SAS/CONNECT Signon script used to connect to the SAS server should be accessible on the machine running the Oracle Data Integrator Agent. In this file, the username and password should be set using variables called userid and password, as shown below. These variables are set at run- time by the Knowledge Modules when connecting to the server and passed to the script.

/*----------------UNIX LOGON----------------*/ /*------------------------------------------*/ *input 'Userid?'; type "&userid" LF; waitfor 'Password', 30 seconds : nolog; *input nodisplay 'Password?'; type "&password" LF;

  • 3.

    Remove the “$” signs for all prefixes of your physical schema definitions. For example, the prefix for the integration tables should be “I_” instead of “I$_”.

  • 4.

    Primary keys and foreign keys do not exist in SAS. You can choose to add them manually in your Models.

Knowledge Modules Reference Guide


Document info
Document views269
Page views272
Page last viewedWed Oct 26 18:10:07 UTC 2016