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

Is it possible to load data on custom and AC (classic) schemas with an external ETL tool?

Avatar

Avatar
Validate 1
Level 2
joanag55068639
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

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

Avatar
Validate 1
Level 2
joanag55068639
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

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

10-11-2017

Hello

on Adobe Campaign classic (v7) onpremise, is it possible to load data on custom schemas with an external ETL? And own AC schemas?

Regards.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

27-11-2017

Hi Joana,

You can either use the Adobe Campaign (classic v6/v7) capabilities (workflows with Collector file activities, etc), or your own ETL to import data in the dedicated schemas.


But please take care to all AC schemas having an auto-incremental key, so you can find autopk="true" in the schema, such as in NmsRecipient schema.
That means that the auto-increment primary key is managed by AC directly, not by the underlying RDBMS system (Database systems manage differently this kind of key, please refer to your RDBMS Oracle/SQL Server).

For all the autopk="true" schemas, there are sequences objects managed by AC, and this is stored in the xtkNewId table.
Please read the technical documentation about xtkNewId before trying to import data with your ETL tool, especially this one:

Database mapping


In addition to supported  web method from JSAPI to get an ID or range or ID, there are specific stored procedure for each sequence type, for instance with the default xtkNewId value of xtkNewId table (shared by more than 30 tables). Of course, the stored procedure code is specific to your RDBMS, you should read it...

Hence, with your ETL tool, it is mandatory to call this stored procedure to get a range of ID, then you can leverage them in your own ETL code.

Please check carefully the ETL code, and be sure to use this  stored procedure in order to not overwrite the sequence values and create a major issue.

Regards
J-Serge

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 2
joanag55068639
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

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

Avatar
Validate 1
Level 2
joanag55068639
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

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

27-11-2017

Thank you J-Serge.

Regards

Avatar

Avatar
Validate 1
Level 2
joanag55068639
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

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

Avatar
Validate 1
Level 2
joanag55068639
Level 2

Likes

4 likes

Total Posts

12 posts

Correct Reply

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

17-11-2017

Hi

I want to know if, in an On Premise installation, I could load data with my company's ETL tool (example, IBM DataStage) on:

  • customized schemas

  • Adobe Campaign schemas (for example, Recipients schema)

or if it's necessary  use Adobe Campaign's capabilities to load data with perform file imports or data import through APIs.

Regards.

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

16-11-2017

Hi,

Can you share more details about your need? There are some connectors available with AC Classic (like FDA to connect to external database, or CRM connectors, etc.), as well as capabilities to perform file imports or data import through APIs.

Florent