NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
To define a JDBC data source, select '''JDBC Data Source''' in the '''Type''' drop-down menu. The following information then needs to be provided:
<ul>
<li>'''Name: ''' name that allows identifying the data source</li><li>'''Resource ID: ''' internal ID, is filled by the system but can be adapted (no special characters allowed). Once saved, the Resource ID cannot be changed.</li><li>'''Description: ''' optional description of the data source</li><li>'''JDBC Driver:''' choose the appropriate driver in the drop-down list. For a connection to an [[IMSMA Staging Area|IMSMA staging area]], choose '''PostgreSQL (org.postgresql.Driver)'''. In the case of other data source, select the corresponding driver.</li><li>'''Host:''' IP address of the host on which the database to connect to is running.</li><li>'''Port:''' port on which the database is running on the host defined above. The default port number for Postgres is 5432.</li><li>Port:</li><li>'''Database:''' name of the database to connect to, e.g. staging.</li><li>'''URL:''' this is the full URL connection to the database. It is filled automatically, in the right syntax, with the information entered above (host, port, database).</li><li>'''User Name:''' name of a database user that can connect to the database. For example, the user imsma can usually connect to the staging area. It is recommended though to define a read-only user on the database and use this one to connect with MINT/lightMINT.</li><li>'''Password:''' password of the above defined database user.</li><li>'''Time Zone:''' leave the default (Use database setting) - the time zone of the database is then the reference time zone.</li><li>'''Save Location:''' browse to a location of the MINT repository to save the data source.</li>
</ul>
{{Note|The data sources are usually set up at the beginning of a MINT implementation and should not change. However, in case of doubt or if a new data source has to be created, contact your [[Management Consulting Team|GICHD IM focal point]]}}
=== Define a JNDI data source ===__NOEDITSECTION__