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

How to access External Database in ACS?

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

21 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

21 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

19-02-2019

Hi,

I am new to Campaign Standard. In Adobe Campaign Classic, we have activities Data loading(RDBMS) and SQL code for reading and writing data from/to external DB. How we could achieve the same in Adobe standard?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

19-02-2019

Hi,

you may refer to following documentation: Adobe Campaign Help | Key steps of adding a resource

It will be under Administration => Development => Custom Resource

Note: in Standard you won't have same flexiblity as in Classic.

Not all standard types can be extended via a custom schema.

Once you have a custom resource created, you could use an import workflow which is parsing your file and loading the data into the table.

Answers (2)

Answers (2)

Avatar

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Employee
ramon_bisswange
Employee

Likes

242 likes

Total Posts

353 posts

Correct Reply

182 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
ramon_bisswange
Employee

19-02-2019

You can't.

Adobe Campaign Standard does not support the integration of external databases and also does not support custom SQL activities.

You would have to export/import the data into the ACS database for working with it using regular Query/Segmentation/Enrichment activities

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

21 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

21 likes

Total Posts

56 posts

Correct Reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

19-02-2019

Hi Ramson,

I could export/import tables(Create/Replicate new tables in ACS DB from Ext. DB) from the External database into ACS database. But how to create custom resource/schema for the existing table in ACS database?

In Adobe campaign classic, we had an option to create new schema for existing table. How we could achieve the same in ACS?