NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
=== Define a JDBC data source ===__NOEDITSECTION__
To define a JDBC data source, select '''JDBC Data Source''' in the '''Type''' drop-down menuof the Add Data Source page. The following information then needs to be provided:
<ul>
<li>'''Name:''' name that allows identifying the data source</li>
</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 menuof the Add Data Source page. 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__
A virtual data source is a combination of two or more other data sources. Therefore, the existence of other data sources (typically JDBC and/or JNDI) is a prerequisite. To define a virtual data source, choose '''Virtual Data Source''' in the drop-down menu of the Add Data Source page. The following page appears.
[[File:MINT_add_data_source_Virtual.png|center]]
As for other data sources, a name, ID, optional description and a repository location have to be provided. Then, the lower pane allows choosing several data sources from previously defined ones. Choose two or more data sources that need to be analyzed together. When creating a [[Create Domains|domain]] selected tables of these different data sources can then be joined.
A virtual data source is particularly useful if there is the need to combine an IMSMA staging area with another database that contains additional data, e.g. on socioeconomic figures. The prerequisite though is the existence of a common key between the data sets.
{{NavBox Business Intelligence}}
[[Category:VIE]]