Problem Description:

How to export QuickBooks Data to OpenOffice using QXL

Solutions: 

Download and install OpenOffice on your system.

Start QXL Desktop

Export the QuickBooks Company Data

Once the export is complete, the output folder showing the list of files will open automatically.

The output folder will contain the exported files.

Start your OpenOffice application on your Desktop.

Click on the "Open" option to navigate the exported files' Output folder.

Double-click on any file to open it with the OpenOffice application.

Or

Select any file and click on "open" with the OpenOffice application.

SQL Server

• Enable Encrypted Connections to the Database Engine
• How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
• How to Enable Encrypted Connection to SQL Server

My SQL

• Configuring MySQL to Use Encrypted Connections (5.5)
• Using Encrypted Connections (8.0)
• Configuring MySQL to Use Encrypted Connections (8.0)
• Building MySQL with Support for Encrypted Connections (5.7)

How to join/reconnect to QXL Online

Refer: How to download and install QXL Online

After installation, you may notice the following icons on the desktop.

The first use of QXL Online

First, ensure you have access to the QuickBooks Online company file with Administrator privileges to authorize QXL Online to connect to your QuickBooks Online Company file. 

In case you are using QuickBooks Online Accountant (a ProAdvisor), you need to be logged in to "Your Books" (the option in the left menu bar for accountants) or the client's books.

To authorize QXL Online to connect to your QuickBooks Online Company file, click the Red/Green toggle button.

QXL Online connection wizard should appear. Enter a Connection name to identify which account this represents, then click "Connect to QuickBooks."

QXL Online will have a QuickBooks Online authorization page on your default browser. Click "OK" to authorize QXL Online at QuickBooks Online.

Click on "Connect to QuickBooks" to begin the authorization process. (For QXL-Online v18.0.0.025 or lower). For QXL-Online v18.0.0.026 and above, this step will be skipped, and you will be prompted with QuickBooks credentials.

By clicking "Authorize QXL Online to Connect to your QuickBooks Online," you open the authorization screen. You need to authorize your company file to work with QXL Online.
You need to enable a pop-up from your browser.

Enter your QuickBooks User ID & Password, then click "Sign In."

For QuickBooks Online Simple Start/Essentials/Plus Account

Select the company file you want to use with QXL Online if you have multiple company files.

For ProAdvisor Account

Select "Company/Firm" from the list. Click "Add app to the firm."

After selecting the company, please click the "Next" button.

Please click the "Connect" or "Authorize" button. It will allow "QXL for QuickBooks Online" to access your QuickBooks Online company data file.

After successful authorization, it will return to the QXL Online page with a connected status. You can close this window.

QXL Online is successfully connected to your QuickBooks Online company. Click "OK" & "Close" to complete the configuration.

Switch back to QXL Online and click Export Data.

After the export is completed. The exported data folder will open. Exported data is placed at the following location by default:

C:\Users\User Name\Documents\QXL\Company FileName Folder

QXL Online Features:

1. Export QuickBooks Online Data to Excel format.

2. Export QuickBooks Online Data to CSV format.

3. Export QuickBooks Online Data to SQL Server.

4. Choose export file(s) location.

5. Export to Separate files or a single file.

6. Export all tables, selected tables, or excluded tables.

7. Custom Query Export.

Also, Refer:
QXL Online options and settings