NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
<li>'''JDBC data source:''' Java Database Connectivity (JDBC) is a Java-based data access technology. It allows access to relational databases, such as Postgres, MySQL, etc. For each database technology, a specific driver is needed. In both MINT and lightMINT, drivers for Postgres and MySQL are included, others might need to be installed on request.</li>
<li>'''JNDI data source:''' Java Naming and Directory Interface (JNDI) is also a Java-based technology to connect to and query data. It is defined directly on the (MINT/lightMINT) server, centrally and only once. The advantages over a JDBC connection are in maintainability and performance - JNDI manages pools of connections instead of opening many separate connections on the database if several processes are accessing the data simultaneously.</li>
<li>'''Virtual data source:'''this type of data source allows combining multiple JDBC and JNDI data sources in order to make them available through a [[Creating Domains|domain]]. This is very useful if several databases/data sources, e.g. IMSMA and an additional source, need to be analyzed together. In such a case, it is crucial though to identify a common key that allows joining the data sets.</li>
</ul>
== Define a JDBC data source ==__NOEDITSECTION__