I wondering how I should go about the following:
What I'm looking to do is display a table of our data within a saleforce tab. The table data would be coming from a database that is in our shop. I also want to be able to pass data to the page (tab) to lookup information as I'm searching through the salesforce accounts. Is this possible? If so what are some thoughts as to how to get this done?
Thanks for the ideas.
Here are a couple of ideas.
You could do this by integrating the data from your local database with Salesforce. Here are some applications to make the integration process easier:
- Informatica
- CastIron
- SnapLogic
- Boomi
- Jitterbit
- Another option is to expose your data from your local database using webservices. Once you've done that, you can import (or generate a class from) the webservice and consume it using Salesforce.
Getting the data is just the first step. If you use either option described above (integration or webservices), you will still need to develop a new Visualforce page and possibly an Apex Class (a custom Visualforce Controller or Extension) to display your data.
In addition, there may be other options using the new Force.com REST API or perhaps a Visualforce page with an iframe that passes querystring parameters to the referenced page.