You can connect directly to a database to specify the data to acquire and to set
parameters to optimize the database connection.
You need to install a JDBC data access driver for your database middleware before using Query
with SQL. The data access driver is a .jar file that you
download from a database vendor site and copy to the driver folder in the
application installation path. Refer to the Related Information about finding and
installing the correct data access driver for your database middleware.
- On the Home page, select Acquire Data.
- In the Add new dataset dialog, select Query with
SQL, and select Next.
A list of database middleware appears.
- When a green check mark appears next to the middleware name, the
middleware is installed and you can start using Query with SQL.
- When a red cross appears next to the middleware name, the data access
driver for the middleware is not installed; you must install it.
- Choose the database middleware for the target database:
| Option |
Description |
| If the middleware is available |
Select the middleware, and select
Next. |
| If the middleware is not available |
Select Install, and install the
middleware. |
- Enter your logon credentials on the Login tab and, if necessary, enter
driver parameters on the Advanced tab.
- Select Create.
The SQL editor opens.
- Enter the SQL to fetch the required tables, preview the SQL query, and select
Create.
The Visualize room appears, and you can start building charts and
analyzing data. If you want to modify the dataset first, switch to the
Prepare room.