CatBase Data Chameleon
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.
It's simple to set up
- Set up a Database Connection to tell CatBase how to connect to your data source
- Set up an Import Style if you want to extract data from the data source, and/or
- Set up a Publishing Style Sheet to publish your CatBase data to the data source
Database Connection
First, you set up a Database Connection:
Note that if you are using CatBase on a Macintosh computer, you will need to install an ODBC driver and configure it (this is explained in the Reference Manual, Chapter 7, which you can download here).
Import Data directly from another data source
Once you have created a Database Connection, you can then set up an Import Style:
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:
The Preferences tab lets you set various preferences for the data import, such as running a script and converting embedded style tags:
The Query tab enables you to specify which data to extract:
Now all you need to do is click the Import Now button on the Main tab!
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 Style Sheets.
Publish data from CatBase to an ODBC Database
You can update existing data in your SQL or ODBC-compliant database or create new records from your CatBase database. To do this, first you must create a Database Connection, as shown above.
Next, create a Publishing Style Sheet - here's an example:
On the Prefs tab, you can choose various options such as only publishing records that are in a certain Set:
Go to the Create/Update tab to tell CatBase how you want to handle the creation and updating of data:
When you're ready to update your database, simply:
- Select the records you want to publish
- Click on the Publish Data button
- Select your Publishing Style Sheet
This process can be simplified by creating Publishing Projects and it can be automated via the Event Scheduler.
Got a question? Contact us and we'll get a speedy answer to you!
Ready to order? Find out how to purchase or lease CatBase Data Chameleon Editiion.
