...
- A supported version of PostgreSQL to house the RED Metadata Repository, the installation wizard can create it the metadata database during installation. If you want to create it manually, see this section for the user permissions recommendations section.
- The matching version of PostgreSQL ODBC Driver to your PostgreSQL database version installed.
- An ODBC DSN setup to connect to your RED Metadata Repository database (PostgreSQL Unicode(64) driver preferred). The installation wizard can create one or you can create it manually.
- A valid WhereScape RED software license.
...
You can click Create Database & DSN to create the required database and connection or you can enter the required information if you already created them.
| UI Expand |
|---|
| title | Creating a database and DSN with the wizard |
|---|
|
- Click Create Database & DSN and enter the following information:
Data Source Name: The name for the ODBC data source (DSN) the wizard will create. Database Host Name: The hostname or IP of the PostgreSQL server. Database Server Port: The port number the PostgreSQL server listens to. User Name: Enter the PostgreSQL user that can connect to the server and can create and write databases. Password: Enter the password for the PostgreSQL user. - Click Validate to verify all the information you entered works.
- After a successful validation, click Next to continue.
- On the Metadata Database screen, the Data Source Name field should be pre-populated with the new DSN that was created.
- Click next to continue with the installation.
|
| UI Expand |
|---|
| title | Using an existing DSN and empty database |
|---|
|
- Specify a data source to which RED connects and the login details for the selected source database.
Data Source Name: Select from the dropdown list the ODBC data source name (DSN) for the metadata repository connection. User Name/ Password: Enter the User Name and the Password to connect to the metadata repository connection. Connection String: Accepts the token replacement of RED Tokens, DNS, Username, and password. By default, click Validate to populate this field automatically with a default connection string, which is a mandatory field for ODBC Database connections for RED. - After successful validation, click Next to continue.
|
| Note |
|---|
|
The validation is performed against the selected data source to ensure: - The database is not already being used by another RED repository.
- The database is not being used for another purpose.
|
Target Database Enablement Pack Install
...