Difference between revisions of "Database Settings V10"

From FMR Knowledge Base
Jump to navigation Jump to search
(Created page with "Category:FMR_Configuration_Reference Text to be written")
 
Line 1: Line 1:
 
[[Category:FMR_Configuration_Reference]]
 
[[Category:FMR_Configuration_Reference]]
 +
==Database type==
 +
This page allows you to provide the connection details to your chosen database service which will be used as the main operating database.
  
Text to be written
+
Options avaialble are:
 +
* MySql
 +
* Oracle
 +
* SQL Server
 +
* Custom
 +
 
 +
The schema must already exist, but can be empty in which case the Registry will create all of the necessary tables. If you specify an existing Registry schema here, the service will attempt to load the content and settings within.
 +
 
 +
If your database service requires special parameters such as authentication details, use the Custom Database Type option which allows the JDBC connection string to be set.
 +
 
 +
==Server==
 +
 
 +
==Port==
 +
 
 +
==Schemea==
 +
Enter the name of the schema as it appears in your chosen application.
 +
 
 +
==Usedid==
 +
This is the userid for the database (NOT the User Name used in the Registry).
 +
 
 +
==Password==
 +
This is the password for the database (NOT the password used in the Registry).
 +
 
 +
If you make any changes, don't forget to use the Apply Settings button before leaving the page.
 +
 
 +
 
 +
 
 +
Back to [[https://wiki.sdmxcloud.org/Category:FMR_Configuration_Reference Configuration options]]

Revision as of 02:47, 11 September 2020

Database type

This page allows you to provide the connection details to your chosen database service which will be used as the main operating database.

Options avaialble are:

  • MySql
  • Oracle
  • SQL Server
  • Custom

The schema must already exist, but can be empty in which case the Registry will create all of the necessary tables. If you specify an existing Registry schema here, the service will attempt to load the content and settings within.

If your database service requires special parameters such as authentication details, use the Custom Database Type option which allows the JDBC connection string to be set.

Server

Port

Schemea

Enter the name of the schema as it appears in your chosen application.

Usedid

This is the userid for the database (NOT the User Name used in the Registry).

Password

This is the password for the database (NOT the password used in the Registry).

If you make any changes, don't forget to use the Apply Settings button before leaving the page.


Back to [Configuration options]