Best Practices for Salesforce Data Access

Best Practices for Salesforce Data Access

• 1.
  Best Practices forSalesforce Data Access Intelligent Integration for BI, ETL, and Application Development Dion Picco, Progress Software, Product Marketing @dpicco, @ProgressSW, @DataDirect_News
• 2.
  BI/Analytics The ‘Good OldDays’ of Data Access Application Platforms Customers Orders Prospects Employees My ter n Da ta C ent er Ce a My at D
• 3.
  BI/Analytics Application Platforms Customers Orders Prospects Employees My ter n Da ta C ent er Ce a My at D
• 4.
  BI/Analytics ? ? ? ? Application Platforms ?? ? ?
• 5.
  The New DataAccess Landscape
• 6.
  Aren’t APIs Supposedto Solve this Problem? wth ro n al G u n An d u po % 76 om C
• 7.
  Aren’t APIs Supposedto Solve This Problem? APIs generally work great for programmers (the only people they were designed for) (and hopefully you only have a few sources)
• 8.
  Aren’t APIs Supposedto Solve This Problem? But they don’t help the rest of us! (analysts, operations, product managers, etc)
• 9.
  There Has toBe a Better Way! A way that is… Broadly Compatible with the Tools of Business Widely Known and Readily Available Skills Great for Developers and Analysts Alike
• 10.
  There IS aBetter Way! Industry standards for data access (Widely known, Broadly supported) Even Chili Knows SQL (Search for him on YouTube) SQL select insert update delete ODBC dsn JDBC
• 11.
  Benefits of aSQL Approach Business Intelligence & Analytics Real-time access to your SaaS data Compatible with your favorite tools Great for “What If?” analysis Web Site Content Web portal integration; massive performance improvements; realtime updates Data Integration and Migration Extract/Transform/Load, MDM, Data Quality initiatives Consolidate Infrastructure Develop Applications Simplified Interface Stop managing changing APIs Build ecosystem add-ons
• 12.
  Progress Offers 3Solutions to Salesforce Data Access +
• 13.
  Progress Offers 3Solutions to Salesforce Data Access • ODBC and JDBC drivers to SaaS applications like Salesforce • Precision control and tuning to suit your specific needs • Support for advanced features such as Bulk Load of data • Local caching to eliminate WS calls and maximize performance • Highly embeddable into your application, and deployable anywhere +
• 14.
  Progress Offers 3Solutions to Salesforce Data Access • ODBC and JDBC drivers to SaaS applications like Salesforce • One single ODBC or JDBC driver for access to ANY SaaS data • Precision control and tuning to suit your specific needs • SQL leveling equals simplicity and for your data connectivity needs • Support for advanced features such as Bulk Load of data • On-demand scalability and flexible subscription pricing • Local caching to eliminate WS calls and maximize performance • Minimize maintenance and updates due to SaaS API changes • Highly embeddable into your application, and deployable anywhere • Highly embeddable into your application +
• 15.
  Progress Offers 3Solutions to Salesforce Data Access • ODBC and JDBC drivers to SaaS applications like Salesforce • One single ODBC or JDBC driver for access to ANY SaaS data • Precision control and tuning to suit your specific needs • SQL leveling equals simplicity and for your data connectivity needs • Support for advanced features such as Bulk Load of data • On-demand scalability and flexible subscription pricing • Local caching to eliminate WS calls and maximize performance • Highly embeddable into your application, and deployable anywhere • Minimize maintenance and updates due to SaaS API changes • Highly embeddable into your application • Combine and blend data from many SaaS and on-premise data sources • Self-service data integration for business operations and analysts • No expensive, costly, risky traditional data integration • Effective new ways to collaborate with coworkers • Enhances your favorite data tools, from Excel to BI tools
• 16.
  Transforming How SaaSData Is Accessed With Progress DataDirect, SaaS data such as Salesforce will appear like just another relational database Not just Salesforce, but any application on the Force.com platform!
• 17.
  Since We’re Inthe DevZone… DIY Alternatives are Costly and Error Prone • Each SaaS API is unique • Each SaaS API is constantly changing • Each SaaS API has custom security and error handling Progress DataDirect Cloud Simplifies Data Integration • Standardized interface; broadest compatibility • Single API with consistent security and error handling • Works with virtually any language or platform • Optimized for performance and scalability Try it for free today: http://www.datadirectcloud.com 1 Interface. ∞ Data Access.
• 18.
  Choose your datasources Configure through your browser Test your SQL inline Connect to all with a single driver
• 19.
  Examples of DataDirectCloud in Use Cloud BI Analytics & Visualization • Customers demanded support for Salesforce.com data • Customers preferred direct real-time access instead of manual Excel import/exports • Chose and embedded DataDirect Cloud to provide Salesforce.com data access, just like the relational databases already supported • “Future proofs” Explore Analytics because new data sources are immediately supported as soon as they are ready in DataDirect Cloud 1 Interface. ∞ Data Access.
• 20.
  Try It forFree Today http://www.datadirectcloud.com Also, be sure to check out: http://www.datadirect.com http://www.progress.com 1 Interface. ∞ Data Access.
• 21.
  All about ProgressSoftware Our customers and partners have big ideas. We help them turn their ideas into business reality through the rapid development, deployment, and management of data driven applications. ▪ Our technology is used by nearly 140,000 organizations in more than 180 countries. ▪ Progress has a network of more than 2000 partners supporting more than 4000 applications ▪ More than 4 million people are using applications built on award-winning Progress technology—both on-premise and in the Cloud ▪ Progress Software trades on the NASDAQ index under the symbol PRGS
• 22.
  Dion Picco Product Marketing,Progress Software @dpicco