| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Prerequisite
In order to successfully create a new catalogue from table, make sure the table has already been created. If the creation of a Catalogue from a file as failed in the process but the table has been created, this menu will also allow the end of creation of the catalogue in RDMP.
...
This process is sensitive to failure due to:
Column type incompatibility
Fields size capacity
…
...
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
Click on "
Catalogues(button)" in RDMP top menu
...
2. Right click on the folder where the catalogue needs to be created and select “Create new catalogue from file…”
...
From the collection menu bar select New…->From Database…
...
Step 2 - Data Source parameters
Fill in the database details
...
Table / Valued function: It is possible to either choose a table of the database or existing function which provides a dataset. That what will allow multiple tables to create a catalogue.Refresh button will check in the table and database are available for Catalogue creationRDMP 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 with success, a new window pops up to configure the level of confidentiality for each item of the new catalogue.
...