Home Services Partners Company
Veeva CRM ODBC/JDBC drivers for direct SQL integration

Veeva CRM ODBC/JDBC drivers for direct SQL integration

January 24, 2013 0 Comments

I recently worked on several ODBC SQL integration projects with Veeva CRM shops in the Life Sciences Industry.  The two most recent projects included direct real-time data connectivity projects between the cloud based Veeva CRM and: Accelrys Pipeline Pilot and SAP Business Objects Universe.  And from my experience, technology professionals in life sciences are great to work with and tend to be much smarter than me.

How to achieve SQL integration with Veeva CRM

Veeva CRM is built on the force.com platform, and DataDirect Connect XE for ODBC and JDBC Salesforce drivers fully support the force.com platform for direct SQL access.  The drivers expose all standard and custom objects at the latest force.com API version to ensure you're able to access the entire Veeva data model in real time.

SQL Veeva CRM integration

Integrate Veeva CRM with Accelrys Pipeline Pilot

Pipeline Pilot is built on the scientifically aware Accelrys Enterprise Platform making it a common use case among life sciences shops running Veeva CRM.  This integration provides access to Veeva data to Accelrys Web Port, other Accelrys solutions such as Electronic Lab Notebook (ELN), Isentris, Chemical Registration and third-party applications such as Microsoft SharePoint or customer-developed applications.

Screenshot from accelrys.com

Here are my impressions on the integration:

  • Pipeline Pilot required 64-bit ODBC drivers on Windows Server x64 for which we recommend the DataDirect Connect64 XE for ODBC Salesforce driver.  32-bit versions are also available.
  • Performance was impressive for ETL operations against a hosted SaaS solution.
  • Pipeline Pilot is efficiently coded to perform ODBC parameter array inserts which can leverage codeless DataDirect Bulk Load into Veeva CRM.  Simply check the "Enable Bulk Load" box in the ODBC data source confirmation, and the driver will transparently leverage the Salesforce BULK APIs.  Verify driver version is 07.01.0077 (B0092, U0063) or higher.

Integrate Veeva CRM with SAP Business Objects

This is a very common use case for Veeva shops, and a complete write-up can be found here to create an SAP Business Objects Universe for Veeva CRM.

Additional standards based applications to integrate with Veeva include:

Data Integration with Veeva CRM

Laboratory Information Management Systems (LIMS) integration with Veeva

Life Sciences Intelligence and Analytics

Database Federation to Veeva CRM

Get started with direct SQL access to Veeva CRM

Sumit Sakar

Sumit Sarkar

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. 

Comments are disabled in preview mode.