function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Persistent SysPersistent Sys 

Real-time integration with back-end databases from FDC

* How to integrate FDC with a back-end MS SQL Server in real-time?

London BenLondon Ben
Unless I'm missing something in your question...

This really couldn't be much easier.

Simply create a basic web service to provide the functionality required as far as retrieving or writing to/from your SLQ database.

Then - simply consume this webservice - using the a wsdl generated class file.

You can then very easily do whatever you wish in FDC.

There is an enormous amount of information available on the interweb about various methods of constructing webservices which access a database - so I'm not going to go any further on the matter here beyond suggesting that being microsoft* - they make it pretty damned easy to achieve with visualstudio*.




* - yeah - I said both the M word and VS in the same sentence on this board :o - sorry
sfdcfoxsfdcfox
Does this post suggest that I can now use callouts in triggers? I've been waiting for that for a while, and I did not see it in the release notes. Prior to Summer '08, I recall getting a "Callouts not allowed in trigger" exception...
Ron HessRon Hess
there is a developer preview feature called Async Apex, uses the @future annotation on apex methods.  This allows you to begin an async process from a trigger, this can then make a call to callouts.

This feature should be available in developer editions only at this time.