"The service and support at Catbase is the best I have ever experienced with an enthusiastic, helpful and knowledgeable team always on hand when you need them."

– Marc de la Bauve, Europa Components

Publishing Workflow Example:

From MySql or MS Sql Server to Adobe InDesign or QuarkXPress

With CatBase it's very easy to produce a publication such as a catalogue, price list, or directory using data from a MySql or MS Sql Server database. You don't need to do any programming or write any scripts; you simply make selections in dialogue boxes in CatBase. Take a look at our short demonstration movie to see the process, and then read the rest of this Tutorial to find out more about how it's done.

CatBase integrates well with MySql!

This example shows how easy it is to extract data from an online MySql database and publish it with Adobe InDesign or QuarkXPress. But you can also publish data TO a MySql database. You can see an example here.

It also works with MS Sql Server

The process is exactly the same if your online database is Microsoft SqlServer: you can publish data to your SqlServer database and you can also extract data from a Sql Server database and publish it with InDesign or QuarkXPress.

See some more CatBase demonstration movies here.

Database publishing simplified!

CatBase makes it easy to produce your publication using InDesign. It does all the hard, boring work for you! The process, in a nutshell, goes like this:

  1. Get your data into the CatBase database. You can either enter it manually, import a delimited text file, or (Data Chameleon Edition) extract it from a MySql or ODBC-compliant database or spreadsheet (such as Microsoft SqlServer, MySQL, Access, etc.)
  2. Set up Publishing Style Sheets in the CatBase database. These tell CatBase what data you want to publish and how you want it sorted and formatted. You can have any number of Publishing Style Sheets, so you can publish your data in lots of different ways (and to various publishing destinations).
  3. Define a Set of records (for example, all records in the table; all people in Arizona; all products in a certain category; or all new products, etc.).
  4. Define a Publishing Project, which describes which Set of data to publish, which Publishing Style Sheet to format it with, and where to save the resulting file.
  5. Click on the Publish Data button on the main window to publish the data.
  6. Import the resulting file into your InDesign template. All the text is - magically - formatted exactly as you want it to be, with pictures included if appropriate!

What do do next ...

About Us | Site Map | Privacy Policy | Contact Us | Affiliates | ©2010 CatBase Software Ltd.