Database Loading

Introduction to ESTARD Data Miner

Introduction to Data Mining

Step By Step Guide

Program Interface

Using Databases

Using Rules & Decision Trees

BI Functions

Reporting & Saving

Home page

Loading a Database Using Native Drivers

The first step to start working with ESTARD Data Miner is to load the database.

From the file menu select "Load Learning Database" or click the "Load Database" icon on "Database" page. This will open the database loading wizard.

Using the native drivers to access your data:

1. Choose the driver type from the "Driver Type" drop down menu.

It can be:

Text (.txt , .csv, .tab)

2. Depending on the database you are connecting to you will need to input additional information as shown below:

For users of MSSQL2000 and MSSQL2005: User Name: Enter the user required by your database Password: Enter your password Database Name: Enter the name of the database you are accessing Database Server: Enter the IP or localhost name of your SQL server Schema Name: This is an optional entry, but is useful for filtering tables displayed when loading the SQL database.
For users of MySQL: User Name: Your MySQL user name Password: The password to your MySQL Account Database Name: The name of the database you are trying to access (optional) Host: localhost or the IP address where the database is available. Port: The port you need to use to access the database. The default value is example: 3306.
For users of Oracle: User Name: Your user name for the Oracle Database Password: Your Oracle password Database: The IP address and location of your oracle database. For example: 192.168.30.4/ORCL
Other database types For other database types just click on "Open Database" button and select the database file from the dialog.
3. Click on "Next" button
4. Select tables you'd like to use from the list.