QXL Professional Edition options and settings - SQL
QXL Professional Edition options and settings / Configuration:
The first step in configuring the application is to click on the settings icon for QXL options details & navigate to the Pro Edition tab.
Pro Edition Tab:
You can export QuickBooks Data into SQL Server & ODBC database using Pro Edition Tabe. Please refer to the details for each option.
1. SQL / ODBC Connection:- You can see the list of added connections from the drop-down list.
2. Add New:- You can add a new SQL / ODBC connection by clicking on the "Add New" button.
3. Connection Name:- You can insert any value for Connection Name. Using the Connection Name, you can recognize SQL / ODBC connection that you want to configure.
4. Connection String:- You need to insert a valid connection string for connecting to SQL / ODBC database.
Sample SQL Server Connection String Format: Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;
Sample ODBC Connection String Format: DSN = Data Source Name
5. Connection Type:- You can choose the connection type using this option.
If you want to export data to the SQL Server database, select "SQL Server Driver" as a Connection Type.
If you want to export data to the ODBC database, select "ODBC Data Source" as a Connection Type.
6. TableName Prefix:- You can set Prefix before exported tables. The default TableName Prefix is "QXL." So all exported table names will have the prefix "QXL" (i.e., QXLAccount, QXLCustomer, QXLInvoice, etc..).
Note: You should use a unique TableName Prefix, which is unavailable in your database. If you use TableName Prefix, which is already available in the destination database, then destination table data will be replaced.
It would be best if you used a unique TableName Prefix, unavailable in your database. For Example: If you use TableName Prefix "QB" & you already have a table in your database with Prefix "QB," destination table data will be replaced with source data. To avoid this type of issue. It would be best if yd.
7. Mapping Type:- You can set ODBC Mapping Type for a different database from the drop-down list. You can select the mapping type:
- Microsoft Access for MS Access database.
- Microsoft SQL Server for SQL Server database.
- MySQL Server for MySQL database.
- Firebird Database for Firebird database.
- Others/Custom Mapping for the rest of ODBC Database.
Others/Custom Mapping:- You can set custom mapping for different data types as per your destination database. If your ODBC database supports a different datatype instead of the below-mentioned type, then you need to write the data type name in the textbox for the respective data type.
- Int16: It is a value type. It's stored Minimum capacity of -32768 and a Maximum capacity of +32767. It is signed and takes 16 bits.
- Int32: It is a value type. It's a stored Minimum capacity of -2147483648 and a Maximum capacity of +2147483647. It is signed and takes 32 bits.
- Int64: It is a value type. It is signed and takes 64 bits. Its stored Minimum capacity –is 9,223,372,036,854,775,808, and its Maximum capacity is +9,223,372,036,854,775,807.
- Boolean: The Boolean type represents the values true and false. Boolean data refers to the logical structure of how the machine language interprets the language. Boolean data refers to the logical structure of how the machine language interprets the language. Boolean data refers to the logical structure of how the machine language interprets the language. Although only two values are possible, they are rarely implemented as a single binary digit for efficiency reasons.
- Byte: A group of binary digits or bits (usually eight) operated on as a unit.
- Decimal: A decimal number, or just decimal, refers to any number written in decimal notation, although it is more commonly used to refer to numbers that have a fractional part separated from the integer part with a decimal separator
- Double: Double-precision numbers store an approximation of an actual number. Double precision floating-point. It will handle most decimals.
- DateTime: The DateTime type is used for values that contain both date and time parts.
- String: A string is a sequence of characters, either as a literal constant or as a variable.
- Memo: A Memo field can help store large amounts of alphanumeric information. The Memo data type allows up to 65,536 alphanumeric characters with options to set several properties, such as rich text formatting. Some typical uses for this data type would be a note, comments, description, or address field.
- Keyword Escape Chars: It will be used to escape a character mentioned in the first textbox with a character mentioned in the second textbox.
For Example: If you want to change ` with,' then you need to write ` in the first textbox & ' in the second textbox.
- Field Name Limit: If your database supports limited table/field name length, then you can set a limit from this textbox.
For Example: If you write 20 in the Field Name Limit text box, then all table & field names are created within 20 character limit.
- Boolean Value: You can configure a boolean value as either 1:0 or True: False.
8. Delete:- You can delete unwanted connections by clicking on the "Delete" button.
9. Save:- You can save/update connection information by clicking on the "Save" button.