Creating Data Sources in MINT: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
← Older editNewer edit →
Evinek (talk | contribs)
NoPublic, Bureaucrats, Administrators
1,068 edits
No edit summary
Evinek (talk | contribs)
NoPublic, Bureaucrats, Administrators
1,068 edits
No edit summary
Line 2: Line 2:
{{Under construction| This page is under construction}}
{{Under construction| This page is under construction}}


A connection to a database (for example to the [[IMSMA Staging Area]]) is called a '''Data Source'''. The first step to get started with MINT or lightMINT is to create a data source. The tool needs to know where the data that has to be analysed is stored. A data source can be:
A connection to a database (for example to the [[IMSMA Staging Area]]) is called a '''Data Source'''. The first step for getting started with MINT or lightMINT is to create a data source. The tool needs to know where the data that has to be analysed is stored. A data source can be:
* an IMSMA staging area database
* an IMSMA staging area database
* any other database
* any other database

Revision as of 09:01, 7 October 2014

This page is under construction

A connection to a database (for example to the IMSMA Staging Area) is called a Data Source. The first step for getting started with MINT or lightMINT is to create a data source. The tool needs to know where the data that has to be analysed is stored. A data source can be:

  • an IMSMA staging area database
  • any other database
  • an XML or Excel file -- the preferred way however is to import or dump the content of a file in a database and then connect MINT to the database. This solution simply scales better and is better manageable. Please get in touch with your GICHD IM focal point prior to including file-based data into MINT.

Types of data sources

Define a JDBC data source

Define a JNDI data source

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:Business Intelligence|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:Business Intelligence|}}}}{{#if:Install Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation|{{#if:Business Intelligence|}}{{#if:|}}{{#if:Staging Area Generator|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if: IMSMA Staging Area Database · Connecting to IMSMA Staging area from ArcGIS · Connecting to IMSMA Staging area from Excel · Sharing an IMSMA Staging Area|{{#if:Business IntelligenceInstall Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation|}}{{#if:IMSMA Staging Area|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:Business IntelligenceInstall Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation IMSMA Staging Area Database · Connecting to IMSMA Staging area from ArcGIS · Connecting to IMSMA Staging area from Excel · Sharing an IMSMA Staging Area|}}{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Other Reporting Tools|{{#if:Other Reporting Tools|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if: Introduction to indicators|{{#if:Indicators|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:Business IntelligenceInstall Staging Area Generator · Using Staging Area Generator · Post Processing SQL Scripts · SAG Spatial reference system · Name Rules Staging Area · Scheduling the Staging Area creation IMSMA Staging Area Database · Connecting to IMSMA Staging area from ArcGIS · Connecting to IMSMA Staging area from Excel · Sharing an IMSMA Staging Area|}}}}
{{{above}}}
{{{imageleft}}}
Staging Area Generator
{{{image}}}
IMSMA Staging Area
{{{group3}}}
{{{list3}}}
Other Reporting Tools
Indicators
{{{group6}}}
{{{list6}}}
{{{group7}}}
{{{list7}}}
{{{group8}}}
{{{list8}}}
{{{group9}}}
{{{list9}}}
{{{group10}}}
{{{list10}}}
{{{group11}}}
{{{list11}}}
{{{group12}}}
{{{list12}}}
{{{group13}}}
{{{list13}}}
{{{group14}}}
{{{list14}}}
{{{group15}}}
{{{list15}}}
{{{group16}}}
{{{list16}}}
{{{group17}}}
{{{list17}}}
{{{group18}}}
{{{list18}}}
{{{group19}}}
{{{list19}}}
{{{group20}}}
{{{list20}}}
{{{below}}}
{{#switch:|subgroup|child=
|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:creating data sources in mint 

|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}

Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Creating_Data_Sources_in_MINT&oldid=16775"