Accessing Multiple DB's through one instance

Avatar

Avatar
Validate 1
Level 2
vasanthg9836694
Level 2

Likes

5 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
vasanthg9836694
Level 2

Likes

5 likes

Total Posts

6 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
vasanthg9836694
Level 2

10-05-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

271 likes

Total Posts

397 posts

Correct reply

199 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile

Avatar
Boost 250
Employee
ramon_bisswanger
Employee

Likes

271 likes

Total Posts

397 posts

Correct reply

199 solutions
Top badges earned
Boost 250
Affirm 100
Give Back 25
View profile
ramon_bisswanger
Employee

10-05-2019

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

Answers (0)