Data extraction from DWB to import into a relational database for reporting | Community
Skip to main content
S
sunil.kotturu
December 12, 2018
Solved

Data extraction from DWB to import into a relational database for reporting

  • December 12, 2018
  • 1 reply
  • 928 views

Hello Experts,

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?

Thank you very much!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Asheesh_Pandey

HI Sunil,

It looks your best go forward is Analytics Data Feed

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:

  1. FTP (Data feed data can be delivered to an Adobe or your hosted FTP location)
  2. SFTP (Data feed data can be delivered to an Adobe or your hosted sFTP location)
  3. Amazon S3
  4. Azure Blob

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)

Some useful links:

Feed Destination

Data Column Reference

Best Practices and General Information

Thanks,

Asheesh

1 reply

Asheesh_Pandey
Community Advisor
Asheesh_PandeyCommunity AdvisorAccepted solution
Community Advisor
April 27, 2019

HI Sunil,

It looks your best go forward is Analytics Data Feed

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:

  1. FTP (Data feed data can be delivered to an Adobe or your hosted FTP location)
  2. SFTP (Data feed data can be delivered to an Adobe or your hosted sFTP location)
  3. Amazon S3
  4. Azure Blob

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)

Some useful links:

Feed Destination

Data Column Reference

Best Practices and General Information

Thanks,

Asheesh

- Asheesh
Terms & ConditionsAccessibility statement

Loading footer...