Pivotal CRM Integration Module: DBConnection

The DBConnection will allow Pivotal CRM systems to integrate with any external datasource that provides ADO.Net or WebService (SOAP) access. Pivotal CRM projects usually require some kind of data integration with third party or legacy data sources. DBConnection provides the basis to establish on-line connections to these data sources. As a result, developers will not need to implement or develop the connection and mapping logic. They will just focus in the business logic while DBConnection takes care of managing the external connection details including the mapping logic between heterogeneous data models.

Main features:

  • Connection to any ADO.Net or WebService (SOAP) datasource
  • Declarative configuration of external connections and mappings using the Pivotal Client
  • Configuration of tracing, logging, transaction management as part of the integration platform
  • Automatic mapping of Pivotal entities (tables with secondaries and foreign keys) to external entities
  • Provides a cache policy management to improve performance
  • Provides a comprehensive API to be used on Pivotal Client/Server tasks
  • Developers will always work with an ADO.Net DataSource (even if the external data is exposed through a web service)

Suitable for: Pivotal CRM 6.0.8 or higher (CMS 6.0.5 o PCM 6.0.8 HF1)

Pivotal CRM Integration Module video-demo

Shows an example of how the DBConnection works. The video shows a simple case where an external database is synchronized on-line with Pivotal.   DBConnection – Data Integration for Pivotal from Grupo Lanka on Vimeo.

Pivotal CRM Integration Module – DBConnection flowchart :

CRM Pivotal Integration Module

Solicitar Pdf Solicitar Demo Solicitar Visita Virtual