| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
...
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
...
in RDMP top
...
menu
...
Step 2: Right click on the folder where the catalogue needs to be created and select “Create new catalogue from file…”
...
Step 3: 2. From the collection menu bar select New…->From Database…
...
Step 2 - Data Source parameters
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.
...
Database: List of all database on the server.
...
Table / Valued function: It is possible to either choose a table of the database or existing function which provides a dataset. Refresh button will check in the table and database are 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 Step 6: .
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.
...