Question
Multiple BIX extract output
I want the BIX extract output to 2 different destinations. 1 needs DDL other is expecting CSV. BIX supports these 2 output formats but can I use the same extract rule and have data in these 2 different outputs? So that data will be read only once.
As Raul said you may need two different extracts if you definitely want to achieve through BIX. We recently implemented BIX and it will be more useful if we involve DBA & ETL teams into this effort. If you really want to extract only once, you can extract as CSV and drop file into a file location work with DBA to schedule a process to load the data into target database or you can execute extracts to database and a DBA can export the data into CSV and put in a shared location from target database based on extract date time. This will be much faster since it won't involve reading from BLOB and more over mostly target database will be read-only databases not production ones.
You can generate extract in two files format alternatively as below -
a)update activity that calls extract rule -
step 1- call csv file extract rule
step2 - call OOTBactivity/custom activity to read extracted csv file and create in another file format /DDL
or
b)update activity that calls extract rule -
step 1- call csv file extract rule
step2 - call another DDL file extract rule
I guess you need to create 2 different extract rule of same class with different name.