Home Partners Company
Enhanced Access to Your Force.com Solutions

Enhanced Access to Your Force.com Solutions

August 04, 2014 0 Comments

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 RootStockVeeva offers a CRM solution for the life sciences, to highlight just a few.

Standard Remedyforce Dashboard

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

Remedyforce Reporting via Microsoft Excel or Access and ODBC

Enterprise BI applications, such as MicroStrategy, are compatible.

Remedyforce Reporting with MicroStrategy and ODBC

Remedyforce Reporting with MicroStrategy and ODBC

JDBC-compatible applications like DbVisualizer will work, too.

Remedyforce Reporting via DbVisualizer and JDBC

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 via JDBC and Datadirect Cloud - Admin Server

Remedyforce integration with Adobe ColdFusion Builder via JDBC and Datadirect Cloud

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.

Greg Stasko

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.

Read next Meet “Mustang,” the New Approach to Real-Time Data Access
Comments
Comments are disabled in preview mode.