QXchange Integration with salesforce.com (lightning Ready)
Overview - Salesforce.com
QXchange is a powerful and easy to use data integration tool to access, integrate and manage large volumes of data from various systems. Extraction, transformation and loading of data are powered by QXchange with source and target database support.
QXchange helps organizations to bond together all enterprise data and ensures accuracy of data in a timely manner. QXchange is a simple stand-alone application that can be used by novice users with ease.
QXchange can quickly and easily transfer data between many standard data formats and applications, including MS Access, Excel, Comma delimited flat file, MS SQL Server, QuickBooks, Salesforce.com and also supports integration with the salesforce latest release Lightning Ready. It allows simple and clear setup of extraction, transformation and loading instructions to exchange data between different formats.
Salesforce.com is a pioneer in hosted software. It is the most popular hosted Customer Relationship Management (CRM) software used by small and mid-sized businesses in the world today. Salesorce.com has expanded beyond CRM and provides a hosted development platform as well as other applications such as Partner Relationship Management. There are more than 41,000 customers of Salesforce.com. Salesforce.com is available in many countries and used by many industries.
Salesforce.com, supplies the Force.com API (Application Programming Interface) to allow third party products to work with Salesforce.com. The API ensures that
the third-party software complies with security access to the data
provides strong error recovery and data logging to make sure data is protected
provides standardization across various upgrades of Salesforce.com
QXchange uses the Force.com API to access Salesforce.com and data objects contained in the platform. The QXchange application is certified by Salesforce.com.
QXchange uses sign-on information provided by the individual customer to identify itself while communicating through the Salesforce.com API. An existing user id and password can be used. The login information is encrypted and stored locally on the user machines. The application and login information is presented to the Salesforce.com authentication system to allow access to the QXchange application.
Use of the login information allows Salesforce.com to enforce access to various data objects based on the same security profile used within the application for direct access.
Data Access Plug-in
QXchange integration engine uses Data Access Plug-ins (DAPs) for individual application and data format integration. All the DAPs are called using a standard Application Program Interface (API). The Salesforce.com API is wrapped inside one of these DAPs. This allows for a smooth and standard operation across all the various DAPs.
QXchange is installed locally at the customer site so that customer data is directly loaded between customer machines and the Salesforce.com site without any other intervening web sites. QXchange sends a message request to Salesforce.com and Salesforce.com sends back a response message; the communication is managed synchronously.
The Salesforce.com API exposes most (but not all) of the data objects available in the Salesforce.com data file. Some of the various objects available are listed here and there are more objects accessible. QXchange able extract and load data to all the data objects supported by the Salesforce.com API including custom objects and custom fields.
Accounts, Contacts, Users, Group, Territory, Partner, Product, Pricebook, Division
Opportunity, Case, Solution, Contract, Lead
Task, Note, Document, Approval, Emailmessage, Event
The QXchange engine works the same for all different DAPs. Every data transfer is set up as a profile, with a source and target data file, which can be of different data formats. Data transfer between specific objects and the mapping of source to target fields are also set up in the profile.
The profile can be executed directly or can be scheduled to be executed later. The process can be run on a local desktop or on a server.
Salesforce.com can be defined as source data and the various objects can be accessed. Field level data from the objects can be extracted and mapped to destination objects and fields in different data formats. Data from multiple objects can be extracted. Multiple profiles can be set up to extract data from various objects. Source data can also be filtered using various expressions. Prior to executing extract the source data can be viewed to make sure the right records are getting selected.
Salesforce.com can be defined as target data and the various objects can be updated. Data can be updated to multiple objects. In some cases update may have to affect multiple data objects at the same time, for example: Invoice Header and Line.
Data can be updated in various modes: Insert, Update and Upsert. Insert expects the record being updated to be new and unique. Update expects the record to already exist. Upsert, tries to insert first and if that fails tries to update.
The QXchange ability to integrate Salesforce.com allows many uses. Certain limitations in Salesforce.com reporting can be exceeded with this tool. This allows many different scenarios:
Extract closed opportunities in the last month into Excel
Extract Account information with company names starting with “A”
Make a copy of all available Salesforce.com data in a MS SQL Server Database, for use in reporting
Insert spreadsheet invoice data sent from branch offices into Salesforce.com
Extract Opportunities from Salesforce.com and create Customer Jobs and Sales orders in QuickBooks.
Extract Accounts from Salesforce.com and create Customers in QuickBooks.
Extract Invoices from QuickBooks and update opportunities in Salesforce.com
Get orders entered from an online e-commerce system and load them into Salesforce.com as Opportunities.
Get customer data entered online and create Customers in Salesforce.com.
QXchange does a tremendous job, understanding the intricacies of the Salesforce.com data structure as well as the complications inherent in the data integration process. With this ability and its ease of use, it allows users to make more effective use of their Salesforce.com Data.
CellarStone Inc is an Appexchange partner with Salesforce.com.
To learn more about QXchange, fill out information at the Inquiry link.
AccessData Corp: Case Study AccessData Corp: Case Study
QXchange ensures Data Integration success for AccessData.
"QXchange solved our data integration needs by eliminating all of the manual work we were doing, which saved us an enormous amount of time."
- David Wariner - Business Systems Manager - AccessData Corp.