I recently presented the webinar "Interrogating Your Cloud Applications with Oracle?" to Oracle shops through the Independent Oracle User's Group (IOUG). This session was presented earlier in the year at Collaborate 12 and the audience went crazy over real-time SQL access to Salesforce CRM via ODBC and JDBC. This presentation also applies to standards based connectivity to additional SaaS sources such as Aprimo, Eloqua, SugarCRM, RightNow,Success Factors, Taleo, ADP. Intaact, Concur from the recently announced DataDirect Cloud.
Connect SQL Developer to Salesforce.com for direct real-time SQL-92 access from Oracle Servers running on Linux (or Windows, AIX, Solaris, HPUX) using Oracle Database Gateway for ODBC (dg4odbc).
Connect DB Visualizer via JDBC to view the schema and data in your SaaS application. This is a direct connection without a staging database.
Other standards based ODBC/JDBC Oracle applications include:
• Learn why Cloud application data is difficult to include in your existing reporting tools.
• Make your Cloud Applications data look like Oracle
• Get more value out of your Cloud tools
Click here to view a PDF of the presentation slides
Post a blog comment, interact with social media or call 1-800-876-3101 to speak live with a Solutions Consultant to learn how other organizations are making progress with direct real-time SQL access to SaaS applications.
Sumit Sarkar is a Chief Data Evangelist at Progress, with over 10 years experience working in the data connectivity field. The world's leading consultant on open data standards connectivity with cloud data, Sumit's interests include performance tuning of the data access layer for which he has developed a patent pending technology for its analysis; business intelligence and data warehousing for SaaS platforms; and data connectivity for aPaaS environments, with a focus on standards such as ODBC, JDBC, ADO.NET and ODATA. He is an IBM Certified Consultant for IBM Cognos Business Intelligence and TDWI member. He has presented sessions on data connectivity at various conferences including Dreamforce, Oracle OpenWorld, Strata Hadoop, MongoDB World and SAP Analytics and Business Objects Conference, among many others.
Copyright © 2019 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.