I have used Enterprise Integration activities:
Insert Data
Query Data
Update Data
Can I Delete Data?
Thanks.
There isn't a built in Delete activity. However, you can use the Custom Query activity to do your deletions. It requires a little custom SQL in order to safely delete only the data you intend.
Thanks for the prompt answer Devin.
Regards,
Roisin
If your databases connections are configured with Direct SQL connections instead of ODBC, then you would use different syntax for the parameters/variables because it supports named parameters instead of just the wildcard like ODBC.
You're correct, and idk why I used the ODBC example. 🤦♂️Too much cross platform work lately.
@████████ I've been there too many times lol. Our original vendor actually set everything up with ODBC, including our SQL data sources, back when we first started so we were over a year into things before I realized we could just do direct with named parameters lol.