Connecting to Adobe Campaign Cloud Database

Avatar

Avatar
Validate 1
Level 1
shreyas_digi_ma
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
shreyas_digi_ma
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

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

27-07-2017

I want a way to connect to the Adobe Campaign Database which is hosted on Cloud using my local Post GRE SQL Client. Is this possible?  This will help me in writing direct SQL Queries in my Post GRE SQL Client instead of using the Adobe Campaign Console Client.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile

Avatar
Establish
Employee
Adhiyan
Employee

Likes

241 likes

Total Posts

343 posts

Correct reply

124 solutions
Top badges earned
Establish
Give Back 50
Give Back 25
Give Back 10
Give Back 5
View profile
Adhiyan
Employee

27-07-2017

HI Shreyas,

What you are looking at may not be possible but you can still write SQL scripts directly in the Campaign Database hosted on cloud.

You can navigate to the SQL scripts section under Administration>configuration>. Here you can create any SQL script to interact with the DB.

Alternately , you can also use the SQL script activity in a workflow to write SQL queries and execute them on the DB.

A word of caution : The changes are done directly on the DB and may not be reversible depending on what you are doing (e.g- Truncate table) , so please follow due diligence in using the above options.

BR,

Adhiyan

Answers (0)