Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
sunilkotturu
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
sunilkotturu
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
sunilkotturu
Level 1

11-12-2018

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!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

129 likes

Total Posts

334 posts

Correct Reply

144 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile

Avatar
Applaud 500
MVP
Asheesh_P
MVP

Likes

129 likes

Total Posts

334 posts

Correct Reply

144 solutions
Top badges earned
Applaud 500
Affirm 100
Contributor
Boost 100
Give Back 10
View profile
Asheesh_P
MVP

26-04-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

Answers (0)