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

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