Problem: 

Data Express uses an online process to insert table information into the Data Express Knowledge Base.  For this process  the Distributed Loader is used. Userid and password  for the selected connection are entered on the Distributed Loader menu.  The problem is that for security reasons  the users  do not know the passwords.

Solution:

It is possible now to load table information (in distributed environment) in the Data Express Knowledge Base through a batch process  using an encrypted password contained in a file.  For this purpose a parameter  -c  is added to Data Express dxegenloadfile utility.  The solution is applicable  for ODBC and Oracle Extension.    

To start the utility  enter the command below from the command prompt within the executables directories  of the ODBC/Oracle Extension installation:        

  dxegenloadfile –c  

The dxegenloadfile utility will check and take the connection  parameters from the method.rc file, located  in the corresponding  ODBC/Oracle config folder.  This utility generates a file with table information in the corresponding ODBC/Oracle log folder, depending on the connection that is used.  The generated file can be passed to the Distributed Loader  via the ‘’Load from File’’ menu.