Connecting to Adobe Campaign Cloud Database

Avatar

Avatar

shreyas_digi_ma

Avatar

shreyas_digi_ma

shreyas_digi_ma

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

Adhiyan

Employee

Avatar

Adhiyan

Employee

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)