Many powerful vertical solutions are now available on the Force.com platform via the AppExchange - For ITSM (IT Service Management), there is BMC’s Remedyforce. Navatar Group offers Financial Services solutions, and ERP and accounting solutions are available from FinancialForce and RootStock. Veeva offers a CRM solution for the life sciences, to highlight just a few.
Standard Remedyforce Dashboard
Force.com solutions provide varying capabilities when it comes to reporting or analytics. Being based on the Force.com platform, the integrated reporting or analytics will likely be delivered via your browser. If you’re a Force.com developer, this means that you will be providing some level of reporting or analytics in your application. If you’re a user of an application built on the platform, you will likely be using the BI or reporting features delivered with your solution. (I’ll be using a Remedyforce sandbox here.)
What if you’d like to access your data from other applications? Maybe you're more comfortable with SQL than SOQL? If you're a developer, are requests for custom reports from your customers driving you crazy? If you're a user of a Force.com solution, perhaps your company has standardized on particular BI or analytics applications - what if you could use them with your Force.com data ? But of course, all of this can only be done if it can be done securely.
Developers or end-users - unlock your data! You can now access the data that’s in virtually any Force.com solution that stores data in custom or standard Salesforce objects from your favorite BI/reporting/analytics applications! App Dev environments. Even from data federation applications such as Oracle's Database Gateway for ODBC!
For example, with Datadirect Cloud, Remedyforce users, as well as users of almost any Force.com solution that stores data in standard or custom objects, can use ODBC-compatible visualization applications like Tableau to access their data.
Remedyforce Reporting with Tableau via ODBC
They can also use Microsoft Excel or Access.
Remedyforce Reporting via Microsoft Excel or Access and ODBC
Enterprise BI applications, such as MicroStrategy, are compatible.
Remedyforce Reporting with MicroStrategy and ODBC
JDBC-compatible applications like DbVisualizer will work, too.
Remedyforce Reporting via DbVisualizer and JDBC
Even web appdev platforms like Adobe ColdFusion can easily integrate Force.com data.
Remedyforce integration with Adobe ColdFusion via JDBC and Datadirect Cloud - Admin Server
Remedyforce integration with Adobe ColdFusion Builder via JDBC and Datadirect Cloud
Datadirect Cloud gives you realtime SQL access via ODBC or JDBC to your data stored in standard or custom Salesforce objects. Powerful, easy-to-setup and easy-to-use. No ETL required! And fully secured over SSL and HTTPS.
Do you work with Force.com solutions? Enduser or developer - unlock your data TODAY. Try Datadirect Cloud for free.
View all posts from Greg Stasko on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.