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 

URGENT: Data Model in Sharepoint 2007/SQL 2005 and UI in VisualForce

Hello,

We want to port only the UI of an application running on Sharepoint 2007 with SQL 2005 DB. UI will be only for reporting and will be developed using VisualForce and has lots of charts.

Any best practices or pointers, as to how can we connect the VisualForce with Sharepoint seamlessly w/o having to do too much of plumbing?

Appreciate quick help on the subject.

Thanks.

ESES
So you want a visualforce page that reports on your data in your SQL 2005 DB. I guess you can write visualforce pages backed by apex code that makes webservice callouts to your api  to get the data needed for reporting.
Another approach can be to have some batch process that syncs your data into salesforce, and then you don't have to make api calls.