You need to sign in to do that
Don't have an account?
Joseph 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 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.