Problem:
For some customers with strong security requirements the Data Express DXESAMPLING Utility is not acceptable and cannot be used because of the reasons below:
1. User console interaction is needed to get the source Data Store Name (DSN).
2. It is not applicable for batch use.
3. The method.rc file is only searched on Administration areas ("Program Files", "All Users") and this cannot be altered by non-administrator users or by automation scripts.
Resolution:
New parameters are added to the DXESAMPLING Utility to satisfy the customers’ needs. These parameters are valid for Oracle and ODBC Extension.
The new syntax of the command is:
dxesampling - d<path> -i<input method.rc file>
where:
-d<path>
-d means that the files sampling.dat and method.rc are read from the directory specified in the parameter <path>. If this option is not specified Data Express will use the default configuration directories.
Example 1:
dxesampling -d “C:\\Testlib1”
The process will read the sampling information (file sampling.dat) and the connection information from the file method.rc both located in the directory C:\\Testlib1\\config and will create the produced log file in the directory C:\\Testlib1\\log.
-i<input method.rc file>
-i means that the input connection information is read from a different ‘’FileName.rc’’ file, equal to the method.rc file. The name and the path to the new .RC file can be specified in this parameter.
Example 2:
dxesampling -d “C:\\Testlib1” -i “C:\\Testlib2\\method1.rc”
The process will read the connection information from the method1.rc file placed in the folder C:\\Testlib2 and will create the produced log file in the folder C:\\Testlib1\\log.
In order to create the file .RC follow the steps below:
1. Create a .INI flat file, named FileName.ini.
2. Specify the parameters below and comma "," as a delimiter. Three formats are valid:
a) Connection type (ODBC or ORACLE),Connection Alias,Schema Name,Userid,Password
b) Connection type (ODBC or ORACLE),Connection Alias,Schema Name,Userid,Password,,,,
c) Connection type (ODBC or ORACLE),Connection Alias,Schema Name,Userid,Password,dummy,dummy,dummy,dummy, dummy
3. Encrypt the .INI file using the command: dxeencrypt.exe FileName
#DataExpressdxesampling.exeODBCOracleExtensiondummy
#MFDS
#EnterpriseDeveloper
