NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
<li>'''Save Location:''' browse to a location of the MINT repository to save the data source.</li>
</ul>
Once all information has been filled, the connection can be tested and saved. {{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__
Once the data sources for a specific MINT implementation are fixed, it is recommended to define JNDI data sources instead of JDBC ones. However, a JNDI data source has to be defined directly on the server and thus has to be set up by the global MINT administrator. Therefore, the creation of a JNDI data source has to be requested to the [[Management Consulting Team|GICHD IM focal point]], and the following information has to be provided:
<ul>
<li>'''Name:''' name that allows identifying the data source</li>
<li>'''Driver:''' type of driver / type of database to connect to (e.g. Postgres)</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>'''Database:''' name of the database to connect to, e.g. staging.</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>
</ul>
A typical configuration on the server will then look as follows:
<pre>
<Resource name="jdbc/Staging" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="imsma" password="password"
driverClassName="org.postgresql.Driver"
validationQuery="SELECT 1"
testOnBorrow="true"
url="jdbc:postgresql://x.x.x.x:5432/staging"
factory="com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory"/>
</pre>
Once the connection is defined on the server, the corresponding JNDI data source can be defined in MINT. To define a JNDI data source, select '''JNDI Data Source''' in the '''Type''' drop-down menu. The resource name (e.g. jdbc/Staging in the example above) then needs to be provided in the '''Service Name''' box. Once all information has been filled, the connection can be tested and saved.
[[File:MINT_add_data_source_JNDI.png|center]]
=== Define a Virtual data source ===__NOEDITSECTION__
