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.
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.
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:
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.
Data Integration with Veeva CRM
Laboratory Information Management Systems (LIMS) integration with Veeva
Life Sciences Intelligence and Analytics
Database Federation to Veeva CRM
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 © 2018 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.