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.
Posted: 8 months ago
Updated: 8 months ago
Posted: 18 Nov 2020 2:18 EST Updated: 18 Nov 2020 2:19 EST