Apex Code Development You need to sign in to do that
Don't have an account?
Devon Allary Connect to SQL Server through Apex
I have an on-premise SQL Server application that I'm trying to connect to Salesforce. I'd like to be able to trigger updates to the SQL database from Salesforce - e.g. an opportunity is won and this sends a query to the database to create a new project record.
I've done this in the past using API's, but the SQL Server I'm using doesn't seem to have anything like that. What would be the best way - or third party software - to use to update a SQL database using Apex?
There's currently a connection set up between the two using DBAmp. If anyone has experience with that software, do you know if there's a way to call the methods programmatically from Apex?
I've done this in the past using API's, but the SQL Server I'm using doesn't seem to have anything like that. What would be the best way - or third party software - to use to update a SQL database using Apex?
There's currently a connection set up between the two using DBAmp. If anyone has experience with that software, do you know if there's a way to call the methods programmatically from Apex?