SQL in ACC

[akashaj7696]

Can someone help me with resources/docs to learn to write SQL in Adobe campaign classic?

[Darren_Bowers · Accepted solution]

Hi @akashaj7696 - Florian has some great blog posts / snippets on lots of different topics including queryDef & custom SQL functions:

• https://blog.floriancourgey.com/2018/08/use-querydef-the-database-toolkit-in-adobe-campaign
• https://blog.floriancourgey.com/2020/01/adobe-campaign-snippets
• https://blog.floriancourgey.com/2018/12/replace-in-expression-of-adobe-campaign

There's also the Adobe docs as a reference

Cheers

Darren

[akashaj7696]

Thanks for the documents, but i'm specifically looking for SQL Data Management scripts, which is written in SQL Activity in the workflow palate, it would be really helpful if you can provide some guidance there!

[Darren_Bowers]

Hi @akashaj7696 - that would be dependant on your database implementation. I would look for documentation on PostgreSQL or SQL Server. That isnt really Campaign specific, unless you are after a data dictionary for Adobe Campaign then you just look at the schema definitions in Data schemas. Cheers Darren

[akashaj7696]

Thanks so much Darren!