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.
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.
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.
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.
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 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:
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:
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.
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.
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.
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.
This option sets the size of the font used in the designer.
This option lets you set the designer color – Silver, blue or none.
It specifies a directory for storing a temporary file, such as a buffer file generated during a computation.
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:
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.