QXchange is a flexible, easy to use, data integration software. It can quickly and easily transfer data between many standard data formats and applications, including MS Access, Excel, Comma delimited flat file, MS SQL Server, MySQL, QuickBooks, Salesforce.com and others. 1. Extract Opportunities from Salesforce.com and create Customer Jobs and Sales orders in QuickBooks. 2. Extract Accounts fromSalesforce.com and create Customers in QuickBooks. 3.Extract Invoices from QuickBooks and update opportunities at Salesforce.com. 4. Extract Accounts & Opportunities from Salesforce.com and create them as an Access database for further reporting. 5. Extract Leads from Salesforce.com and create them as an Excel file for forwarding to marketing activities. 6. Extract a series of Excel files and convert them into Fixed-length text files to feed another system. Extraction Extraction module allows the specification of various data sources. Transformation Transformation allows the conversion of various data items. Loading Loading module allows the creation or update of output data items. Profiles ETL instructions are coded and saved as profiles for re-execution. Scheduling Profiles can be established to run at specified times. Logging Errors during the ETL process are logged. At the end of the process, the errors can be reviewed. Formula Expression QXchange allows the creation of formula expressions using math, string and logical operators combined with data items, variables, constants and functions.Overview
QXchange Benefits
QXchange Features
QXchange is architected for robustness and ease of use. The use of profiles allows the preservation of integration instructions and reuse. The user interface is largely designed to be a profile manager to manage the setup of these instructions. QXchange supports access to many different data formats. These data formats can be types of files (fixed length, comma delimited), type of database (Access, MySQL) or type of application (QuickBooks). Services are Also Available To Solve Integration Problems qxchange_support@cellarstone.com QXchange is a very easy to use, data integration software. The user interface is very simple and intuitive. Users can start using the application with no training. Most of the uses that the business users are faced with, can be easily established and executed from this tool. Data can be easily mapped by just dragging and dropping them to the right areas. QXchange is very flexible and allows the conversion of data in a very simple manner. Excel like functions are used to convert the data. Most users are familiar with these functions from their experience with Excel. QXchange can quickly and easily transfer data between many standard data formats and applications. Data formats include Excel, Comma delimited flat file, MS Access, MS SQL Server, MySQL, QuickBooks, Salesforce.com and others. It simplifies all of these various data formats so that they look exactly the same from a user perspective. It allows simple and clear setup of extraction instructions. These instructions can be saved and re-executed as often as necessary. The instructions can also be set up to run on a specific schedule, such as weekly runs. QXchange Architecture
Data Access Plug-Ins
QXchange Support
To Learn More, Contact us through
Reasons to Implement QXchange
