Create a Catalogue from table

Use Case

You have a database containing table(s) that you want to use with RDMP (in either MySql, Sql Server, Oracle or Postgres).

Steps

Step 1 - Open the Catalogues collection

1. Click on Catalogues in RDMP top menu

Open

2. From the collection menu bar select New…->From Database…

Open

Step 2 - Data Source parameters

1. Fill in the database details

UserID / Password (optional): When connecting the database to test if a catalogue can be created in it, the system will use these credentials. If not informed, RDMP will use windows credential by default.

Server: by default, the SQL server which has been setup when RDMP has been installed. It can be changed at this stage if another server exists.

Database: List of all database on the server.

Table / Valued function: RDMP supports querying both tables, views and table valued functions (Sql Server only). Tables and views accessible by the user appear in the Table dropdown while table valued functions are listed seperately.

Refresh button will refresh the list of databases/tables available for Catalogue creation.

2. Click on Import

Step 3 - Configure Catalogue items extractability

 Once the catalogue has been imported, a new window pops up to configure the level of confidentiality for each item of the new catalogue.

1-   Catalogue Name (mandatory): By default, it’s the name of the file and Table create in the database to store data related to the catalogue. It can be changed without impacting the table name

2-   Table Name (mandatory): When created the table has been named by the file name. It can be modified at this stage, but it doesn’t change the Catalogue name. Unless necessary, there is no specific reason to change it.

3-    Acronym: Used for the metadata catalogue title. It can also be used to name the extracted file / folder, as a way of shortening the name down

4-   Description: Used for the metadata catalogue description

5-   Project link:   

If a project has been created previously and the catalogue is specific to this project only, click pick and select the project.

6-   Configure the level of extractability of items.

 There are 2 ways of configuring the extractability level:

• Individual configuration: each item is also configurable one by one in the main window.

• Mass configuration: under Set All, at the bottom right of the window, select the extractability level you want all items to be at.

7-   Patient Identifier Column: this field establish the patient identifier for the catalogue. This is mandatory and will be anonymised automatically when the catalogue is extracted.

8-   Filter: When the catalogue contains a lot of Catalogue Items, the Filter as the bottom of the window allows a quick search in the items.

9-   Final Step

 Once all parameters for Catalogue extractability is in place, either

• press Ok, job done

• or Add to existing Catalogue to JOIN with another table and create only one Catalogue (the linkage will be created automatically based on the Patient Identifier)

The number of columns added to the existing catalogue will depend on the extractability configuration just setup. Only Core items will be added.

• or Cancel (Do not create a Catalogue)

At this stage the table with data has already be imported to the database suggested at the first screen. The system then asks if the table needs to be kept or not. If kept, the catalogue won’t be created but it can be re-created later using the option Create Catalogue from table.