To Import and publish data to inmydata from on on-premise solution inmydata provides the Configure Data Sources Client Application. This page details how to create, modify, delete and distribute Systems, Links and Subjects that are used to import and publish data. 

 

clip737

Save

Save Changes - Saves Changes made whilst in the Analytics Engine Screen.

Undo

Undo Changes - Undo all changes made whilst in the Analytics Engine Screen.

SubjectExplorer

Subject Explorer - Opens the subject explorer window.

ImportExport

Import / Export - Opens the Import / Export Wizard to allow the Import of Systems,

ClientSettings

Client Settings - Open the client settings window.

No longer implemented

System

New System - Allows the Creation of a new System


Link

New Link - Allows the Creation of a new Link

MagnifyingGlass

New Lookup - Allows the Creation of a new Lookup

Subject

New Subject - Allows the Creation of a new subject

Delete

Delete - Delete a Seleted Item

CloneSubject

Clone Subject - Creates a New Subjected by Cloning an Existing Subject

UpdateLookups

Update Lookups - force Lookups to be refreshed on the client, using the Update Lookups Wizard



New System 


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.

 

The System Wizard makes it simple for you to Create A New System or Modify An Existing System whenever you require.



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.


New Lookup


 

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.



New Subject


 

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.

 

Using the Subject Wizard, you can Create a New Subject or Modify An Existing Subject quickly and easily.

 

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.


Delete


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.

 

 

clip705

Remember to Save your changes.


Clone Subject


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.

 

clip734

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'.

clip735

clip736

 

The list of Subjects will now display a New item, the Clone, labelled 'Copy of'

Remember to Save your changes.


Update Lookups

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. 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

 

 

clip218

 

This will display the Update Lookups Wizard 

 



Save Changes


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.

 

 

clip665

OR...

 

Click on 'File', then 'Save Changes' in the menu.

 

 

 

clip664