Creating Data Sources in MINT

From IMSMA Wiki
Revision as of 16:20, 29 July 2014 by Evinek (talk | contribs)
Jump to navigation Jump to search
This page is under construction

The first step to get started with MINT is to create a data source. The tool needs to know where the data that needs 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 is does scale better and is better manageable. Please get in touch with your IM focal point at GICHD 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=16160"