Is there a way to integrate CRM with a PSQL database? We would like to use CRM as the front interface and have it then import into our internal PSQL database. I have been looking for an ODCB driver but with no luck. Any ideas would be greatly appreicated. Thanks.
*This post is locked for comments
Hi Scott,
I assume you running CRM on premise in which case you could read the data directly from SQL server by accessing the filtered views.
That said there are plenty of other ways you can integrate CRM with external systems. You could write custom code in a workflow or plugin to do a Rest call, data base update or add a message to a queue or bus
How frequently and fresh you require the data to be are all factors in your solution
hth
Joe
Hi Scott, I believe Cozyroc have an ssis adapter that may support your requitment se www.cozyroc.com/.../odbc-destination
Best Wishes, Raz
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (