CData Software Acquires forceAmp | FAQ

forceAmp (www.forceamp.com) is a connectivity company that specializes in integration between Salesforce and SQL Server. Their flagship product, DBAmp, is a popular solution for real-time integration. DBAmp creates a real-time, bi-directional link between SQL Server and Salesforce that allows customers to access Salesforce data directly from SQL Server. A long-time Salesforce partner solution, DBAmp is trusted by hundreds of organizations to power back-office data movement and analytics processes.

The integration technologies from forceAmp are strongly aligned with those of CData. Both companies share a common technical vision: a SQL-centric approach to data connectivity. The acquisition of forceAmp further extends CData's presence in the Salesforce ecosystem and provides additional technical flexibility in data management and integration.

Organizations leverage DBAmp's simple data connectivity to support a wide variety of enterprise data scenarios, such as running reports on Salesforce data, writing complex stored procedures for two-way integrations, replicating Salesforce data in bulk to SQL Server with a single stored SSIS procedure, and more. Common use cases for DBAmp include:

• Replication from Salesforce to SQL Server to support BI, analytics and reporting
• Replication to SQL Server to reduce customer license requirements for Salesforce (data stored and accessed locally to support infrequent users)
• Data Synchronization - updates made to records in SQL Server pushed to Salesforce.

CData is committed to forceAmp technologies and the critical role they play in CRM integration. As such, forceAmp will continue development as a separate brand extension of CData.

The forceAmp team, including forceAmp Founder Bill Emerson, will join CData Software and continue to maintain and extend forceAmp's data connectivity and integration technologies. By joining forces with CData Software, forceAmp will become part of the world's most comprehensive suite of standards-based integration solutions. For forceAmp customers, the CData acquisition brings access to enhanced support services and greater integration possibilities.

For forceAmp customers, the CData acquisition brings access to all new support services and an enhanced roadmap of integration possibilities. With the growing industry shift to cloud, multi-cloud, and hybrid-cloud, CData will provide forceAmp customers with a straightforward migration path to leverage cloud infrastructure for data warehousing and data pipeline integration.

In addition, CData technologies expand integration for forceAmp users beyond the Salesforce ecosystem to integration with a broad range of CRM systems, ERPs, marketing automation tools, accounting platforms, and other applications and databases.

Rest assured that forceAmp products like DBAmp will continue to retain premium value pricing for years to come. At the same time, we plan to release all new technology and subscription bundles that dramatically extend the capabilities for Salesforce customers, providing ETL and live integration with dozens of new data sources and warehousing destinations.

DBAmp works through the Linked Server capability of Microsoft SQL Server. DBAmp is installed on SQL Server, and customers can access Salesforce through SQL scripts or through stored procedures kept on SQL Server. The functionality is similar to the capability available across CData ODBC Drivers via the SQL Gateway technology (www.cdata.com/sqlgateway/). DBAmp customers should feel right at home using CData ODBC Drivers to expand their SQL Server data connectivity.

At CData, we offer all types of data connectivity and integration solutions. The CData products that will be of interest to you will be largely dependent on how you use DBAmp today, and the connectivity needs of our organization. The following use-cases outline the most common opportunities:

• Do you currently connect with Salesforce from SQL Server using SQL queries and scripts?
  Take a look at the CData ODBC Drivers with embedded SQL Gateway capabilities. Our ODBC Drivers will provide seamless data connectivity to more than 250 enterprise SaaS, NoSQL, and Big Data sources, in the same way that you connect with Salesforce today.

• Are you currently replicating data to SQL Server but interested in migration to a new database or cloud data warehouse like Snowflake, Redshift, Azure or BigQuery?
  Take a look at CData Sync. Sync is an easy-to-use tool that replicates data from Salesforce, as well as more than 250 other data sources, with any database or data warehouse.
  • Automated continuous data replication between Salesforce and any database or data warehouse.
  • Run data replication on-premise or in the cloud via AWS, Azure, and Oracle OCI.
  • Build data pipelines that aggregate data from other data sources.
  • Straightforward data transformation capabilities can alter data in flight to conform to destination schema.
• Are you currently building integrations with DBAmp and SQL Server Integration Services (SSIS)?
  The CData SSIS Components include everything needed to extend SSIS packages with universal access to hundreds of different applications, services, databases, and APIs.
  • Use data flow components like 'lookup' as part of workflow processes.
  • Move SSIS workflow to the cloud (ADF).
  • Gain bi-directional data connectivity with 250+ data sources and destinations, including Salesforce and SQL Server.