If the delivery information is not easily available in the existing data sources, then you can consider creating a table to use for the query to create the delivery XML.
Following is a sample:
Note:
If the JDBC driver that you use does not support column alias, when you define the bursting control table, the columns must match exactly the control XML tag name. For example, the KEY column must be named KEY, upper case is required. PARAMETER1 must be named PARAMETER1, not parameter1 nor param1, or any other non-matching name.
CREATE TABLE "XXX"."DELIVERY_CONTROL"
( "KEY" NUMBER,
"TEMPLATE" VARCHAR2(20 BYTE),
"LOCALE" VARCHAR2(20 BYTE),
"OUTPUT_FORMAT" VARCHAR2(20 BYTE),
"DEL_CHANNEL" VARCHAR2(20 BYTE),
"PARAMETER1" VARCHAR2(100 BYTE),
"PARAMETER2" VARCHAR2(100 BYTE),
"PARAMETER3" VARCHAR2(100 BYTE),
"PARAMETER4" VARCHAR2(100 BYTE),
"PARAMETER5" VARCHAR2(100 BYTE),
"PARAMETER6" VARCHAR2(100 BYTE),
"PARAMETER7" VARCHAR2(100 BYTE),
"PARAMETER8" VARCHAR2(100 BYTE),
"PARAMETER9" VARCHAR2(100 BYTE),
"PARAMETER10" VARCHAR2(100 BYTE),
"OUTPUT_NAME" VARCHAR2(100 BYTE),
"SAVE_OUTPUT" VARCHAR2(4 BYTE),
"TIMEZONE" VARCHAR2(300 BYTE),
"CALENDAR" VARCHAR2(300 BYTE)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "EXAMPLES";
Tips for creating a creating bursting delivery table:
If the split data set does not contain a DELIVERY_KEY value, then the document is neither delivered nor generated. For example, using the preceding example, if customer with ID 123 is not defined in the bursting delivery table, this customer's document is not generated.
To enable a split data set to generate more than one document or deliver to more than one destination, duplicate the DELIVERY_KEY value and provide different sets of OUTPUT_FORMAT, DEL_CHANNEL, or other parameters. For example, customer with ID 456 wants his document delivered to two e-mail addresses. To achieve this, insert two rows in the table, both with 456 as the DELIVERY_KEY and each with its own e-mail address.