Introduction to Data Mining

• Getting Started With Data Mining
• Rules of Use
• FAQ

Step By Step Guide

• Step by Step Guide
• Query Types
• Working with Classes
• Using Rules and Decision Trees Settings
• Viewing Field Values

Program Interface

• The ESTARD Data Miner Menu
• Managing Panel
• Query Wizard
• ESTARD Data Miner Pages
• "Database" Page
• "Statistics" Page
• "Rules" Page
• "Decision Tree" Page
• "Initial Query" and "Query Parameters" Pages
• "What-If" Page
• "Search a Database" Page

Using Databases

• Learning Database
• Analysed Database
• Database Types
• Database Loading
• Loading a Database Using ODBC Drivers

Using Rules & Decision Trees

• Query Settings
• Using Rules
• Editing Rules
• Using Decision Trees

BI Functions

• Selecting BI Data to Use
• Fields Mapping Settings
• Patterns Searching: Simple Select Query

Reporting & Saving 

• Decision Trees and Rules Reports
• ESTARD Data Miner Files

Loading a Database Using ODBC Drivers

Using ODBC to Access Data:

1. From the file menu select "Load Learning Database" or click the "Load Database" icon on "Database" page. This will open the database loading wizard.
2. In the database loading wizard select "ODBC" as your driver type
3. From the "Database Type" drop-down menu select the type of database you will be connecting from the following options:
   • MSSQL2000
   • MSSQL2005
   • MySQL
   • Oracle
   • Sybase
4. Depending on the selected database type you will need to input additional information:

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.
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) Data Source: The name of the DSN connection file without an extension - for example: "mys"
Oracle: User Name: Your user name for the Oracle Database Password: Your Oracle password DNS: Select the DNS file you wish to use to connect Schema Name: This is an optional entry, but is useful for filtering tables displayed when loading the SQL database.
Sybase: User Name: The user name for your Sybase account Password: The password to your Sybase account Database Name: The name of the Sybase database you are trying to access Database Server: The path to the Sybase server Port: The port you wish to use (5000 is the default)