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

SQL Code

Avatar

Avatar
Validate 1
Level 2
prabhuk78522504
Level 2

Likes

6 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
prabhuk78522504
Level 2

Likes

6 likes

Total Posts

6 posts

Correct Reply

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

22-02-2017

Hi,

   I want to directly write a  SQL Query in adobe campaign to pull the data. Is it possible? If possible means please share the document or link to learn me. Please help me

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

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

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

23-02-2017

Hi Prabhu,

In addition to the valuable input shared by Florent, an important point to note here is SQL code activity will only allow you to make UPDATEs, INSERTs and DELETEs from an existing table.

If you wish to fire a SELECT query, you can do so in a JS code activity using functions like sqlGetString(), sqlGetInt(), sqlSelect().

Please get in touvh with Adobe Support and request for access to JSAPI documentation. Details related to these functions are listed there.

Support will validate whether your license and then make this documentation available.

Hope this helps.

Regards,

Vipul

Answers (1)

Answers (1)

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

23-02-2017

Hi,

You can use a SQL code activity in a workflow.

To be able to execute a workflow with an SQL code activity in it, you will need the WORKFLOW and SQL SCRIPT EXECUTION named rights.

Hope this helps,

Florent.