Can I expose SQL Server Database information to a Salesforce Community in a Pie Chart Dashboard?

Question

There are a billion records in SQL Server so probably not a good idea to transfer all records to Salesforce. Is there a good ETL tool that could sum up summarize the records and store the results in an object in Salesforce and then put a dashboard in the community for that info? Or should I write a script for the SQL Server and send the needed data for the pie chart to the visualforce page and have that populated in the Dashboard (can the dashboard be dynamic and based off of a values in a callout?).

Ben Vedmart · Answer

I reccomend Skyvia ( https://skyvia.com/data-integration/integrate-salesforce-sql-server ). It offers a true ETL solution to move data between Salesforce and SQL Server in any direction. A free plan with 10000 loaded records per month is available.

Can I expose SQL Server Database information to a Salesforce Community in a Pie Chart Dashboard?

Integration

Related Learning

More Help