First, you set up a Database Connection (choose Data Connections from the Admin menu and click on the New Connection link):
The Updates tab lets you tell CatBase whether you want to update your existing data or delete all the records in the table first and import a fresh set of data. See the Updating Data tutorial for more info about updating.
The Preferences tab lets you set various preferences for the data import, such as running a script and converting embedded style tags (see the Importing Data tutorial for more details).
The Query tab enables you to specify which data to extract:
It's simple to set up:
With CatBase Data Chameleon Edition you can easily extract data from, or publish it to, an ODBC-compliant data source such as Microsoft Sql Server, Excel, Access, or MySql.
Note: if you are using CatBase on a Macintosh computer, you will need to install an ODBC driver and configure it. See the Configuring an ODBC Driver tutorial for more info.
Once you have created a Data Connection, you can then set up an Import Style.
Now all you need to do is go back to the Main tab and click the Import Now button!
Importing data can be automated via the Event Scheduler - for example, you can set it to automatically update itself from your data source every night.
Once you have imported the data, you can easily publish it in any number of different ways by setting up Publishing Projects.