-
A powerful ETL solution that reduces maintenance and deployment costs.
-
Easy and timely access to data.
-
Fast ETL delivery through a simple wizard-driven interface.
-
Comprehensive Source and Target Support.
-
Provides accurate output of data.
-
Moving and improving data.
Q2. What are the system requirements for running QXchange?
Answer:
The following minimum hardware is required for the effective functioning of QXchange:
- Operating System
- Microsoft Windows 2000 Service Pack 4
- Microsoft Windows XP Service Pack 2 or Later
- Microsoft Windows Vista
- Microsoft Windows Server 2003 Service Pack 2
- Processor - Minimum 1.5 GHz processor (2.2 GHz preferred), x86 based system
- Memory - 512 MB of RAM (1 GB preferred)
- Modules - Dot Net Framework 2.0 (with SP1 recommended)
- Browsers - IE 5.1(For windows 2000 only) or later
Q3. How is the Salesforce user authenticated and is the password secure in QXchange?
Answer:
Answer:
The license covers the installation and usage of our software on one machine.
Q5. Can QXchange handle custom date formats in excel?
Answer:
We are supporting custom date formats in excel.
Answer:
We create the job and push it to Windows Scheduler. So the user must have enough permission to run the Windows Scheduler.
Q7. Who can use QXchange?
Answer:
QXchange can be used by Database Administrators, System Administrators and Developers.
Q8. How do I install QXchange?
-
Double click the QXchange.exe file.
-
On the Welcome screen, click Next.
-
On the License Agreement screen, click on "I accept the terms of the license agreement", and then click Next.
-
On the Choose Destination Location screen, choose the path to install the files. Click the Change button to select the path or save it in the default path (C:\Program Files\QXchange) and click Next button.
-
On the Ready to Install the Program screen, click the Install button to start the installation process or click the Back button to move to the previous screens or click Cancel button to exit the wizard.
-
On the Install shield Wizard Complete screen, click the Finish button to complete the Installation process.
Q10. Is it possible to clear the existing job start date/end date for customer job in QuickBooks using QXchange?
After mapping the source and the destination database/data sources, click the Save Profile icon that appears on the toolbar. Alternatively you can select Save Profile option from the Options menu or press Ctrl+S. Then click Run Data Transfer icon that appears on the toolbar. Now the source and target databases/data sources will be integrated.
Q14. Can I view the path of a profile? If so, how?
Answer:
Yes, you can view your current profile while working with the application. To do so, click on the View Profile icon that appears on the toolbar. Alternatively, you can select View Profile from Profile menu or press Ctrl+V.
Answer:
Profile is a file that stores all settings related to a particular data transfer.
Answer:
Yes, you can create multiple profiles. Only one profile will be active at any particular time.
Answer:
Yes, you can view your current profile while working with the application. To do so, click on the View Profile icon that appears on the toolbar. Alternatively, you can select View Profile from Profile menu or press Ctrl+V.
Answer:
QXchange supports Excel sheets, Flat files (Text files) and other supported DAPs.
Answer:
Source database is one from which the data is taken and inserted to the target.
Answer:
Target database is one on which data manipulation and data insertion are done.
Answer:
To browse for the required file, click the Browse button that appears next to the source database drop down box.
Answer:
Row Delimiter is a separator that is used to separate rows or fields in the text file.
Answer:
Column Delimiter is a separator that is used to separate columns or fields in the text file.
Answer:
Encoding formats that can be used are ANSI, OEM and Unicode.
Answer:
Test connection is to test the particular database, sheet or file.
Answer:
While selecting the columns, the data type and length of a particular column can be viewed at the bottom of its respective tree views.
Answer:
Mapping is process by which a particular column gets its values from the corresponding mapped column(s) of the source table.
Answer:
For Excel Sheet, sheets are interpreted as tables and the first row of each sheet is interpreted as the columns for the corresponding sheet. For Text Files, each text file is one table where the text file name is the table name and the first row in the text file is its corresponding columns.
Answer:
The Source and Target databases can be mapped by dragging the columns from the Source and dropping it in the required columns of Target.
Answer:
Mapping table is used to integrate data.
The various output formats supported by QXchange are as follows:
-
Zip code
-
Phone Number
-
Social Security Number
-
International Standard Book Number (ISBN)
To implement a format on a particular column, select the column and click the Format button. A window pops up, displaying the format list. Select the required option from the list and click Apply.