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

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
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Employee
Adhiyan
Employee

Likes

239 likes

Total Posts

342 posts

Correct Reply

124 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
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)