CONNX Data Integration Suite 14.8.0 | InfoNaut - The Query Tool | Using InfoNaut | Starting InfoNaut
 
Starting InfoNaut
*To start and set up InfoNaut:
1. Locate the CONNX Driver folder in your program list and start InfoNaut - The CONNX Query Tool. The main InfoNaut window shows.
If you connected to a data source in a previous session of InfoNaut, a prompt appears asking whether you want to reconnect.
The reconnect prompt shows the previous data source and "Yes" and "No" buttons.
*If you want to reconnect, click the Yes button and proceed to Step 4.
*If you want to choose a new data source, continue to Step 2.
2. Select Connection > Add New Connection from the menu bar. The Select Data Source window appears.
In the Select Data Source window you can choose between the File Data Source and Machine Data Source tabs and provide a DSN Name.
3. Click the Machine Data Source tab to view a list of user and system DSNs. Select a DSN for your CONNX database from the list. You can do that by either double-clicking on the DSN name, or by clicking the OK button.
You can also add a DSN to the Machine Data Source list by clicking the button "New".
4. The CONNX Integrated Login window appears.
The CONNX Integrated Logon window has fields for a User ID and Password, as well as Database Connection Options.
*If you are using Windows NT Integrated Security, you are logged in automatically. Proceed to Step 7.
*If you are not using Windows NT Integrated Security, proceed to Step 5.
5. Type a CONNX user name in the User Name text box and type a CONNX password in the Password text box. If you don't want the default selection, select an application type from the Application list box. Click Ok.
The default selection for the Application list box is a connection to all applications. See Managing Applications in the CONNX Security chapter in the User Reference Guide for a description of how to set up applications and application security.
6. If you are using RMS or VSAM databases, or you haven't connected to a database before, the CONNX Database Logon dialog box appears. Type the server name, a user name, and a password in the corresponding text boxes in the CONNX Database Login section. Port 6500 is listed in the TCPIP Port text box by default. Any change made to the port setting in this text box becomes a permanent change to the port setting of the database.
The Database Logon window contains the text boxes for the necessary information.
7. Click the OK button to establish a connection to your data.
The Connection Established message box appears.
8. Click the Show Tables button in the InfoNaut window to open a window that contains a list of the tables from the current database that you can access with the current configuration. Double-click on a table to create a query that selects all data from that table.
The query SELECT * FROM <TABLENAME> is inserted into the query text box on the main form.
9. Click the Execute query (The query button is located right under the File button and has a green exclamation point.) button to run the query and view the results. If necessary, you can click the Execute query button again to cancel lenghty queries.
To run a new query against the same database, type a query in the Query text box. The Execute Query button is enabled if you have an established connection to a data source.
The data from the table appears in the lower pane as in the image below. See "Chapter 2: CONNX Security" in the CONNX User Reference Online Guide or the Security and Administration Guide for more information on database and application management.
10. Click the Build query button (The Build query button is located next to the Execute query button and) to open the Query Builder window.
See the "Query Builder" section in this guide for more information.
11. From here on you can:
*Open a new data source by clicking Add Connection in the Connection menu. The current data source is automatically closed.
*Close the current data source by clicking Close Connection in the Connection menu.