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

Accessing Adobe campaign database in cloud

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct Reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct Reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

17-08-2017

HI

is there a way to read data from Adobe campaign Database that is on Cloud? I want to connect tableau to adobe campaing ( cloud version) to read data from log tables.

thanks in advance

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Employee
elliottja
Employee

Likes

5 likes

Total Posts

8 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
Affirm 3
View profile

Avatar
Boost 5
Employee
elliottja
Employee

Likes

5 likes

Total Posts

8 posts

Correct Reply

4 solutions
Top badges earned
Boost 5
Boost 3
Boost 1
Applaud 5
Affirm 3
View profile
elliottja
Employee

23-08-2017

There is no direct database access to an Adobe hosted Adobe Campaign instance. However, any and all required data can be exported out of the platform using the powerful data management workflow capabilities of the platform and made available to external reporting tools such as Tableau.

Answers (7)

Answers (7)

Avatar

Avatar
Validate 1
Level 1
nageshk26444950
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
nageshk26444950
Level 1

Likes

0 likes

Total Posts

4 posts

Correct Reply

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

05-11-2017

This is the official Adobe/Tableau announcement from 2014.

Tableau and Adobe Analytics: Digital Marketing Gets Even More Awesome | Tableau Software

You may be able to build a Web Data Connector as well, but I'm not sure if the log info is exposed in a way that would let that work.

Thank you

Nagesh Kumar

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct Reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct Reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

31-08-2017

thanks for the response. With workflow export it can be a solution but I was looking for something more close to realtime .

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

21-08-2017

Hi,

I am not 100% sure that there is any option for that Access to ACS database directly. If they had this option they would have provided that access to AC6/7 instead of building a IO api and connector.

Anyways, Raise a helpdesk ticket with Adobe.

As of Now you can export those logs in files and import them in Tableau by following instruction below.

Exporting logs

Regards,

Amit

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct Reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct Reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

21-08-2017

Thanks Amit

I know that that the instance that we are using is on Cloud and the database. I am assuming that we can still access that database directly right? do we have to get the Adobe to have that available or there is some documentation on how to access the database directly? If I have access to the database directly that I think I can have Tableau talk read from the tables  right?

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

20-08-2017

Hi,

If you are using On premise AC6/7, then you can connect Tableau server to Adobe Campaign Postgres database.

Read this article here: PostgreSQL

Bear in mind this will not work with ACS.

Regards,

Amit

Avatar

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct Reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile

Avatar
Give Back 10
Level 3
vendimb15716755
Level 3

Likes

20 likes

Total Posts

107 posts

Correct Reply

6 solutions
Top badges earned
Give Back 10
Give Back 5
Give Back 3
Give Back
Ignite 3
View profile
vendimb15716755
Level 3

18-08-2017

Thanks Amit

What I have investigated is  that those logs files are also available into the Adobe Campaign postgresSQL database. is there a way to have an ODBC connection that tableau can pull that data directly instead of going through Adobe Analytics? I am just trying to access the postgress database directly so I can get those log files and process.

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

17-08-2017

Hi,

This is not supported OOTB connector to support this integration although there is a way you can achieve this.

Step 1: Integratget Adobe campaign with Adobe analytics, follow instruction given in the link below

Adobe Campaign Reporting

Step 2: Adobe campaign tracking/logs will be available in Adobe analytics

Step 3: Get TDE file from Adobe analytics by following instructions in the following link.

Tableau data file

Step 4: Now You can send this TDE file to an FTP server. From there, you can create a script through which the Tableau Server can pick it up.

Regards,

Amit