function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Joseph Bauer 8Joseph Bauer 8 

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

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?). 
Boris FrankBoris Frank
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.