Tool

Read(121) Label: preview, datasource, execute,

First page

This item lets you view the first page of a composite table file or a bin file.

 

Open a composite table file or a bin file, click Tool -> First page, or  on the toolbar, to view data on the first page.

Next page

This item lets you view the next page in a composite table file or a bin file.

 

Open a composite table file or a bin file, and click Tool -> Next page, or  on the toolbar, to view data on the next page.

Previous page

This item lets you view the previous page in a composite table file or a bin file.

 

Open a composite table file or a bin file, and click Tool -> Previous page, or  on the toolbar, to view data on the previous page.

Last page

This item lets you view the last page in a composite table file or a bin file.

 

Open a composite table file or a bin file, and click Tool -> Last page, or  on the toolbar, to view data on the last page.

Preview view

This item lets you preview data of an exported view from a data extraction file.

Open a data extraction file, select a view to export, and click Tool -> Preview view, or  on View window, to pop up the following window:

Run

Run outputs a view from a data extraction file to a target composite file (CTX), bin file (BTX), text file (TXT), CSV file, Excel file (XLSX) or a database table.

 

Open a data extraction file, select a view, and click Tool -> Run, or  on the toolbar, to output a view. The following prompt will appear when the output is completed:

Data source

This lets you define parameters for a JDBC connection to the database and controls the connection and disconnection. Click Tool -> Datasource to open the following Datasource window:

Click [New] to create a new data source; [Delete] deletes a selected data source in the list; [Edit] lets you modify the information of a selected data source; [Connect] connects to a selected data source; and [Disconnect] close a data source connection. In the drop-down list after [Encryption level] the user can select an encryption type: Plaintext or password.

Here’s how to create a new data source:

Click [New] to open the following Database type box, where there are two types: JDBC & ODBC:

 

Ø  JDBC

Select JDBC and click [OK] to open Datasource dialog box, as shown below:

 

1. Datasource name - Any name a user wants, like ora and SQL17.

2. Database vendor - Select the corresponding database type; if there isn’t an eligible one, select Other.

3. Driver – Default is oracle.jdbc.driver.OracleDriver; users can enter other drivers.

For other drivers, copy the corresponding database’s JDBC driver jars into the designer installation directory (by default, C:\raqsoft\common).

4. Datasource URL – Default format is jdbc:oracle:thin:@192.168.0.1:1521:[user database name], like jdbc:oracle:thin:@192.168.0.68:1521:demo.

5. User – Database user name.

6. Password – the password for accessing database.

7. Batch size – The data volume a database can process each time in batch. The batch processing can increase performance greatly when handling a huge volume of data (adding/deleting data, etc.).

8. Qualify object with schema – This option decides whether a database table is preceded by a schema name, like dbo.Employee.

9. Enclose object name in quotes – This option determines whether to use a qualified table name.

Extended properties – Certain database products require additional properties which you can set on the Extended properties tab. These databases have different extended parameter names, which are automatically added after the general properties are configured. Certain database products, such as Access, don’t have the extended parameters.

 

Click [OK] to return to Datasource window where a newly-created JDBC data source is listed.

 

Ø  ODBC

 

On the Database type window, click [OK] to open the ODBC datasource box:

1.Datasource name - Any name a user wants, like ora and SQL17.

2.ODBC name - Name of an ODBC data source defined in the data source manager;

3.User - Database user name.

4.Password - The password for accessing a database.

5.Qualify object with schema –This option decides whether a database table is preceded by a schema name, like dbo.Employee.

6.Case sensitive – This option decides whether a command will respond correctly if you enter one or more characters in either lowercase or uppercase.

7.Enclose object name in quotes – This option determines whether to use a qualified table name.

Click [OK] to return to the Datasource window where a newly-created ODBC data source is listed.

Options

This item lets you configure the default properties and system parameters for the data file tool.

Click Tool -> Options to open the following tab:

Note: Restart the designer to apply modification of an option in blue.

 

Output takeover

The option determines whether to write the execution log to the Output panel. If it is unselected, the Output item won’t appear on the tool menu; if selected, users can click Tool -> Output to view the system log information, which may contain error messages, and perform debugging.

 

Auto-open previous file

Whether or not to open the file used when you last close the designer. By selecting the option, the system will automatically open the most recently used file at the start of the designer next time; if the file used last time doesn’t exist, error message will appear. No file will be opened if it is unselected.

 

Rows per page

This option lets you set the default number of rows displayed per page of a bin file or a composite table file opened in the designer.

 

Font size

This option sets the size of the font used in the designer.

 

Application appearance

This option lets you set the designer color – Silver, blue or none.

 

Temporary directory

It specifies a directory for storing a temporary file, such as a buffer file generated during a computation.

 

License file

The location of the data file tool’s license file. You can click Config to view the license.

To reconfigure the license file, click [Open] on the following box to re-select a license file:

Output

The menu item is for viewing the system log information. You can perform debugging if there are error messages.

Click Tool -> Output to open the following window:

Click [Copy] to copy the information elsewhere, and click [Clean] to remove the information.