BUSINESS INTELLIGENCE

DATA CENTER MANAGEMENT

CellarStone Inc QXchange Review

About QXchange

QXchange is data integration software designed with a simple, intuitive user interface that maps data through drag-and-drop functionality. The platform facilitates data conversion with Excel-like functionality, and transfers data between many standard data formats and applications including Excel, comma delimitated flat files, MS Access, MS SQL Server, MySQL, QuickBooks, and Salesforce.com.

The platform simplifies various data formats so that they look the same from a user’s perspective, facilitates the simple and clear setup of extraction instructions, and allows users to save and re-execute instructions as often as necessary. Additionally the platform allows users to set up scheduled instruction execution, logs all ETL process errors for review, and allows users to combine multiple data items when transforming data.

About the Company

CellarStone Inc is headquartered in California with a partner office in Chennai, India.

QXchange Key Features

• Extracts opportunities from Salesforce.com to create customer jobs and sales orders in QuickBooks
• Extracts accounts from Salesforce.com to create customers in QuickBooks
• Extracts invoices from QuickBooks to update opportunities in Salesforce.com
• Extracts accounts and opportunities from Salesforce.com to create an Access database for further reporting
• Extracts leads from Salesforce.com to create an Excel file for forwarding to marketing activities
• Extracts a series of Excel files and converts them into fixed-length text files for use in other systems
• Allows users to upload sets of comma-delimited text files into a MS SQL Server database
• Enters orders from online ecommerce systems in order to load them into QuickBooks as sales orders and invoices
• Captures customer data entered online to create customers within QuickBooks
• Gathers vendor data entered online to create vendors within QuickBooks