How does the Oracle database integration work with HelixTree (Open DataBase Connectivity [ODBC] Driver)?
Basically, ODBC is a generic driver interface for HelixTree to talk to a variety of free and proprietary databases. You first have to install an “Oracle ODBC Driver” in order to communicate with an Oracle database, or a “MySQL ODBC driver” for communicating with a MySQL database. Next, you open the ODBC driver manager in windows (In Control Panel->Administrative Tools->Data Sources (ODBC)) and create either a user or system data source (the only difference is that a system data source is usable by any user on a system). The Data Source specifies what ODBC driver you are using, what database you are connecting to, your login credentials, and sometimes even the table, etc. Once you have a data source created (such as “My Oracle Data Source”), you run HelixTree, open a project, go to the Import Wizard, click ODBC, select the data source from the list of data sources and then click “next”. The data source usually has some custom options at this point, even to the point of entering in custo
