No description, website, or topics provided.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
data File clean up. Aug 8, 2014
drivers Adding libraries, drivers & FoodMart SQL script. Aug 8, 2014
libs Adding libraries, drivers & FoodMart SQL script. Aug 8, 2014
FoodMartLoader.sh Corrected wrapper script. Aug 9, 2014
README.md Update README.md Aug 9, 2014
ReadMe.txt Update ReadMe.txt Aug 9, 2014

README.md

FoodMart Data Loader

A wrapper to the Mondrian FoodMart Data Loader

INTRO

This is a small wrapper to the Mondrian FoodMart Data Loader, the JAR files were taken It takes the FoodMart SQL Creation script and loads the data onto the database of your choice.

The script is easily editable to add additional database options. As is the script assumes that all database servers are running on the local machine, this can be edited before running the wrapper script.

Drivers that are included on this version are:

  • ProstgreSQL
  • MySQL
  • SQL Server & Sybase

Pre-requistes:

  • Make sure you have a Java 7 or later in your PATH.
  • Unzip the content of data/DataScript.zip found into the 'data' directory.
  • Choose one of the following db_types:
    • mysql
    • postgres
    • sqlserver
    • sybase

Usage Instructions

Run the script as follows:

sh FoodMartLoader.sh --db <db_type>