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.
Updated: 13 Nov 2020 15:11 EST
Infosys Limited
IN
I guess you need to create 2 different extract rule of same class with different name.
Updated: 15 Nov 2020 10:45 EST
US Department of Veterans Affairs
US
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.