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

SOLVED

Accessing Multiple DB's through one instance

vasanthg9836694
Level 2
Level 2

Hello,

We have our current instance connected to SQL servers database. We want to access data from a different database (Redshift). Can we have 2 DB connections for a single instance? Can we have SQL server as primary DB which hosts all the adobe tables and we can access few tables from Redshift? If yes, How?

Below are some of the details.

Current version : Adobe Campaign Classic (Hybrid deployment) V.6.1.1

Primary DB : MSSQL 2012

Please let me know your thoughts.

Thank you,

vasanth

1 Accepted Solution
ramon_bisswanger
Correct answer by
Employee
Employee

Hi Vasanth,

external DB access is possible via FDA:

Accessing an external database (FDA)

Redshift is listed in the FDA section of the compatibility matrix thus should work:

Campaign Classic Compatibility Matrix

View solution in original post

1 Reply
ramon_bisswanger
Correct answer by
Employee
Employee

Hi Vasanth,

external DB access is possible via FDA:

Accessing an external database (FDA)

Redshift is listed in the FDA section of the compatibility matrix thus should work:

Campaign Classic Compatibility Matrix

View solution in original post