My company uses a homegrown Apex (Oracle Application Express) ticketing system to assign internal tickets to our various teams. My present challenge is to use SharePoint Designer (SPD) to programmatically logon to the ticketing system, and pass the required parameters to it to create a new ticket.
I've tried to setup a database connection in SPD, but it looks like I can only surface read-only data that way (am I wrong?)
If the database connection won't work, how can I build an ECT to hit an Apex database?
If that won't work, is a custom activity my best shot?
Thank you in advance for your help, it's greatly appreciated!!