Pega Decision Data Loader

Configuration steps

1. Login to https://nextbestactionhubs.com/shop and order a key

2. Download the Dloader zip file

3. Unzip the file into the server directory

4. Configure the sample configuration run script file based on the table above

5. Execute run script with a sample selection

   1. Set SourceQuery to return a small sample of data

   2. Test SourceQuery in SQL client before execution

Alias : Important info for Oracle DB

When defining sourcequery for the Oracle database remember to define an alias for each property.

The format of the alias should be : <alias_name>_dot_<tablename>_

This is because the Oracle JDBC driver does not support the method getTableName

Example,

select customerID customerid_dot_customertable_, firstname firstname_dot_customertable_

from customertable