SAS/Access to Salesforce CRM for superior ODBC integration with SAS

SAS/Access to Salesforce CRM for superior ODBC integration with SAS

February 21, 2012 0 Comments

Did you know?

  • SAS began as a research project at my Alma Mater, North Carolina State University
  • SAS global headquarters in Cary, NC is two exits down the freeway from the Progress DataDirect office.
  • Progress DataDirect Connect XE for ODBC Salesforce driver can be used with SAS/Access for ODBC similar to any other relational data source.

Did you say DataDirect has a direct connection to query Salesforce.com and Database.com from ODBC intefaces? Yes.  We work with customers and prospects every week that run their SAS intelligence on Progress DataDirect drivers through the SAS/Access interface for ODBC.  They are now expanding connectivity to application data sources such as Salesforce.com with the Progress DataDirect Connect64 XE for ODBC Salesforce driver.  There is a good chance this driver is already deployed or being evaluated in your organization today.  Ask around!

Salesforce.com and Database.com will look like native SAS via relational data source

Why choose SAS/Access for ODBC? (from SAS website)

  • Integrate more data sources from more platforms.
  • Access data directly, easily and securely with native interfaces.
  • Gain faster performance and reduce network traffic.
  • Support integration through standards, including ODBC, JDBC and OLE DB.
  • Support both technical and business users.

Salesforce.com and Database.com will look like native SAS via relational data source

What are SAS shops saying about DataDirect Connect XE ODBC drivers for Salesforce with SAS?

  • Easy.  SAS/Access for ODBC to Salesforce does not require an additional data server tier, and only takes 15 minutes to add another connection through SAS/Access for ODBC.
  • Intuitive. The XE ODBC driver makes Salesforce.com look and feel like native SAS similar to relational sources: Oracle, DB2, Sybase or SQL Server.
  • Consistent. Organizations are already running the Salesforce driver to integrate on-premise applications from Informatica, Oracle, Microsoft, IBM, etc.  Adding SAS connectivity provides a standard interface to Salesforce with a consistent view across the organization of the latest objects exposed through the latest version of the Salesforce.com API.
  • Fast: The flexibility of the built in change data capture cache can significantly improve performance over the WAN for extracting data.  In the reverse direction, you can bulk load SAS Data Sets into database.com using the same driver!
  • Reliable.  Salesforce drivers are built on the same flagship Progress DataDirect Connect drivers framework that has powered your enterprise data connectivity for two decades across 32-bit and 64-bit Windows, Linux, AIX, Solaris, and HP-UX platforms.

How to get started today? 1. Download free 15 day trial of the DataDirect Connect XE for ODBC driver to integrate SAS/Access for ODBC to Salesforce. 2. Since we made Salesforce.com look and feel like a relational database, follow our tutorial for Superior ODBC Access from SAS on Linux. 3. Or call 1-800-876-3101 to speak with a live Solutions Consultant to learn how other organizations are making progress with DataDirect Connect Salesforce integration.

Sumit Sakar

Sumit Sarkar

Technology researcher, thought leader and speaker working to enable enterprises to rapidly adopt new technologies that are adaptive, connected and cognitive. Sumit has been working in the data access infrastructure field for over 10 years servicing web/mobile developers, data engineers and data scientists. His primary areas of focus include cross platform app development, serverless architectures, and hybrid enterprise data management that supports open standards such as ODBC, JDBC, ADO.NET, GraphQL, OData/REST. He has presented dozens of technology sessions at conferences such as Dreamforce, Oracle OpenWorld, Strata Hadoop World, API World, Microstrategy World, MongoDB World, etc.

Comments
Comments are disabled in preview mode.
Topics
Latest Stories
in Your Inbox

Subscribe to get all the news, info and tutorials you need to build better business apps and sites

More From Progress
570x321__Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Top 7 Considerations Before Choosing a Chatbot for Your Enterprise
Read More
 
232-132_How to Simplify Application Usage & Deployment with Microapps
How to Simplify Application Usage & Deployment with Microapps
Read More
 
kinvey-console-thumbnail
Getting Started with Kinvey
Read More