Starting OpenInsight

Launch OpenInsight.

Start, Programs, OpenInsight Development Suite, OpenInsight Sysprog.

Enter User Name: SYSPROG and Password: SYSPROG.

The OpenInsight 10 IDE for the SYSPROG application and SYSPROG user will be displayed as shown below.

From the OpenInsight 10 IDE choose File, Application… to create a new application. The New Application dialog box is displayed.

The Application Name and Password are the only required items in this dialog box.

Click in the Name edit line and type ADVENTUREWORKS. (Spaces are not allowed in an Application Name or User Name.)

Click in the Password edit line and type ADVENTURE123! Passwords must match the default policy requirements. Retype your password.

Note: The Inheritance drop down indicates <Default Inheritance>. This means that this newly created application inherits the components of the base application, SYSPROG, mentioned above.

Click the OK button to create the new ADVENTUREWORKS application.

The OpenInsight IDE for the ADVENTUREWORKS application will be displayed, as shown below.

1. The SQL Linking Wizard will step you through the process of linking tables from a SQL datasource to OpenInsight.

Since we have made a connection named ‘ADVENTUREWORKS_IRELAND’ earlier in the exercise, choose it from the list of connections available, and click on the ‘Next’ button.

Once the Connection has been selected we can then select the tables to work within the database being utilized by the connection. For the purposes of this exercise we will choose the HumanResources.Department, HumanResources.Employee, HumanResources.EmployeeDepartmentHistory, HumanResources.EmployeePayHistory, HumanResources.JobCandidate, HumanResources.Shift, Sales.Customer, Sales.SalesPerson, and Sales.SalesTerritory tables.

The next panel to appear is the Linking Results panel. The screen will show if the selected tables have been successfully attached.

The Wizard is now complete and you can manage your connection from the screen below. Connection details can be maintained via the Property Panel.

Right click on a table to build your OpenInsight shadow dictionaries.

Right click on a table to view the data dictionaries in the Table Designer.

Below are the converted shadow dictionaries that can be maintained via the Table Designer.

From the OpenInsight 10 IDE, go to View, Tool Panels, Database to open the Database Manager.

The Database Manager will display in the left tool panel. You can see we have attached SQL tables from the ADVENTUREWORKS_IRELAND volume.

Now that the files from our SQL database are attached to OpenInsight they are seen as native tables. From the TCL command prompt we can type the following:

LIST HUMANRESOURCES_DEPARTMENT ID-SUPP DEPARTMENTID NAME GROUPNAME MODIFIEDDATE BY NAME

Click the Execute button to run the command. The report will output to the Print Preview window.