1.50.2 Seed Data for Source Table Name

This topic describes about the seed data for source table name.

The list of “Source Table Name” for selection under the drop-down and the subsequent selection of each source table columns are controlled via SQL injection to the following tables under CMNCORE schema:

To add a new Source Table, User can make an entry as follows:

INSERT INTO RP_LOOKUP_DATA_STORE (ID, KEY, TYPE) 
VALUES ('101', 'SCHEMAJNDI.YOURTABLENAME', 'TABLE_NAME');

Table 3-114 Source Table

Column	Comments
ID	Unique identifier of each row in the table.
KEY	Represents the source table along with the source jndi. (For example: If your Source schema has the following jndi jdbc/MYDB and your source table name is MY_NEW_TABLE, the value would be MYDB.MY_NEW_TABLE
TYPE	Represents the type of Key. Default the value as TABLE_NAME in this case.

To configure the columns of the source table, user can make the following entries.

Insert into RP_LOOKUP_VALUES_DATA_STORE (ID,VALUE,RP_LOOKUP_DATA_STORE_ID) 
values ('UUID_UNIQUE_1','COLUMN_NAME_1','UUID_UNIQUE');
Insert into RP_LOOKUP_VALUES_DATA_STORE (ID,VALUE,RP_LOOKUP_DATA_STORE_ID) 
values ('UUID_UNIQUE_2','COLUMN_NAME_2','UUID_UNIQUE');
Insert into RP_LOOKUP_VALUES_DATA_STORE (ID,VALUE,RP_LOOKUP_DATA_STORE_ID) 
values ('UUID_UNIQUE_3','COLUMN_NAME_3','UUID_UNIQUE');
Insert into RP_LOOKUP_VALUES_DATA_STORE (ID,VALUE,RP_LOOKUP_DATA_STORE_ID) 
values ('UUID_UNIQUE_4','COLUMN_NAME_4','UUID_UNIQUE');
Insert into RP_LOOKUP_VALUES_DATA_STORE (ID,VALUE,RP_LOOKUP_DATA_STORE_ID) 
values ('UUID_UNIQUE_5','COLUMN_NAME_5','UUID_UNIQUE');
Insert into RP_LOOKUP_VALUES_DATA_STORE (ID,VALUE,RP_LOOKUP_DATA_STORE_ID) 
values ('UUID_UNIQUE_6','COLUMN_NAME_6','UUID_UNIQUE');

Table 3-115 Source Table

Column	Comments
ID	Unique identifier of each row in the table.
VALUE
RP_LOOKUP_DATA_STORE_ID