To Import and publish data to inmydata from on on-premise solution inmyda proveds the Configure Data Sources Client Application. This page givesdetailed notes on how to create, modify, delete and distribute Systems, Links and Subjects that are used to import and publish data.
Save Changes - Saves Changes made whilst in the Analytics Engine Screen.
Undo Changes - Undo all changes made whilst in the Analytics Engine Screen.
Subject Explorer - Opens the subject explorer window.
Import / Export - Opens the Import / Export Wizard to allow the Import of Systems,
Client Settings - Open the client settings window.
No longer implemented
New System - Allows the Creation of a new System
New Link - Allows the Creation of a new Link
New Lookup - Allows the Creation of a new Lookup
New Subject - Allows the Creation of a new subject
Delete - Delete a Seleted Item
Clone Subject - Creates a New Subjected by Cloning an Existing Subject
Update Lookups - force Lookups to be refreshed on the client, using the Update Lookups Wizard
Systems let you define the connections to your business application that you wish to extract data from.
Once you have defined a system you can connect to your business application and Import or Create the Links between its Tables. The Links define the relationships between the various Tables in the application and provide the foundation for the report Subjects. A subject is a grouping of related tables that you wish to be included together for reporting purposes.
Links define the relationships between the Tables in the relational database applications that your Systems connect to.
Links are used to control the way in which you assemble your inmydata Subjects, ensuring that they are only built using Tables with a known relationship.
Most of the Links you use will be those which are inherent to the Tables and Indexes in your application, but sometimes you may also wish to define Links of your own.
To make the process of defining Links as easy as possible, you can let inmydata do the work, and Import Links From The Database. inmnydata does this by analysing the common fields and indexes within the database.
For those times when you need to Link tables that do not have an obvious connection, the Link Wizard will guide you through the process letting you Create Or Modify Links quickly and simply.
Lookups allow you to define user friendly selection lists that can be used to select parameter values when a query is run.
Lookups retrieve data from tables in your business application to build the selection lists. This data can be cached on the client, to improve performance. You can use the Update Lookups Wizard to force Lookups to be refreshed on the client.
Lookups can be assigned to fields in a subject in the subject wizard. Lookups can also be assigned to input parameters in business logic subjects. If a lookup is assigned to a field or input parameter, the lookup will be used to prompt for values in the query wizard and run query wizard.
The Lookups Wizard allows you to create and modify lookups.
There are three types of Subject you can build. Freeform Subjects allow you to combine related tables which have Links between them, or you can achieve more complex Subjects by creating them from Business Logic Procedures or PROGRESS Smart Data Objects .
All inmydata Data Definitions (Queries) are based on Subjects. Subjects are a way of controlling the Query building process, preventing the use of unrelated tables, inefficient sorting on non-index columns, inefficient finds on non-index columns and the display of sensitive or system data.
By grouping together related tables and allowing you give columns appropriate labels, Subjects also simplify the Query building process for the end user by removing the need for any knowledge of the structure of the underlying application database.
Alternatively it is possible to use an Clone an Existing Subject.
Using the Subject Explorer you can enquire on, select (if you currently have the subjects tab selected) and search for particular subjects.
You can only delete a Subject while working in the inmydata Configre Data Sources Application Screen.
WARNING; if you delete a Subject, you will no longer be able to run any existing Data Defintions (Queries) built on that Subject.
Select the Subject you wish to delete by clicking on its name in the tree view.
Click on the 'Delete' Icon on the Ribbon.
Remember to Save your changes.
If a New subject is required that is similar to an existing one it is possible to Clone the original and use it as a basis of the New Subject.
You must be in the inmydata Configure Data Source screen to Clone a subject.
Select the Subject you wish to Clone by clicking on its name in the tree view.
Select the Subject you wish to Clone by clicking on its name in the tree view, then...
Click on the Clone Subject Button on the Ribbon.
A dialogue box will appear asking if you want to make copies or the Subjects links and Lookups
Click on 'Yes' to make copies, otherwise click on 'No'.
The list of Subjects will now display a New item, the Clone, labelled 'Copy of'
Remember to Save your changes.
Lookups retrieve data from tables in your business application to build the selection lists. This data can be cached on the client, to improve performance. The Update Lookups Wizard allows you to force Lookups to be refreshed on the client.
To open the Update Lookups Wizard open the Configure Data Sources screen.
Click in the Update Lookups Button
This will display the Update Lookups Wizard
To Save Changes in the Configure Sources Applciation, use either of the methods below. Saving changes saves all changes made across all Systems, Links, Lookups and Subjects.
Click on the 'Save' icon in the toolbar.
Click on 'File', then 'Save Changes' in the menu.