I am new to Adobe suit and looking for your inputs on few my requirements.
We are looking for extracting detail transaction level data from DWB for each object (to be more precise, similar to 'select * from table' in oracle DB) to import into a relational DB for reporting needs. Can you please suggest whats best approach to export all the attributes/fields of each DWB table with the volume of 11M activities?
Adobe can deliver this raw data to the customer in a batched manner on a recurring daily or hourly delivery schedule. Each data feed comprises the raw data for a single report suite. In a user-friendly data feed service interface, you can select all/selected columns to be delivered on either of the following four distribution channels:
FTP (Data feed data can be delivered to an Adobe or your hosted FTP location)
SFTP (Data feed data can be delivered to an Adobe or your hosted sFTP location)
You can schedule your feed to deliver daily or hourly based on your need, can also get historical data feed (contact client care to get more details on this)