Database application: Depot
The database application that's all about continuity across the Complete OFFICE suite. Depot allows you to seamlessly integrate your data stored in Depot databases such as contracts and addresses, or calendar information, and use it across any Complete OFFICE document you create. Advanced users will also be able to utilise the built-in database engine for complex queries, data sorting, statistics and more. Depot puts the data in your hands.
What does Depot give you?Depot is the database front-end of the Complete OFFICE suite. With Depot, you can seamlessly integrate your existing database structures into the other components of Complete OFFICE, or create an interface to use and administer your data as a stand-alone application. You can use imported and linked tables and queries from MySQL, PostgreSQL or Microsoft Access and many other data sources, or design your own with Depot, to build powerful front-ends with sophisticated forms, reports and views. Support is built-in or easily addable for a very wide range of database products, notably the provided HSQL, MySQL, Adabas D, Microsoft Access and PostgreSQL.
Depot is a full-featured desktop database front end, designed to meet the needs of a broad array of users, for all kinds of usages, such as: • keeping track of collections of objects; • maintaining customer information databases; • maintaining student grade and curriculum databases; • storing survey information and experimentation data; • storing population and census data; • producing monthly financial reports in companies and organisations • managing audit, quality assurance and production data. |
|
Depot provides wizards to help users who are new to database design (or just new to Depot) to create tables, queries, forms and reports, and it comes supplied with a set of predefined table definitions for tracking assets, customers, sales orders, invoices and many other commonly-useful items.
If you're looking for a database for single-user situations, Depot comes configured with the full HSQL relational database engine. It's an ideal solution for uncomplicated needs, and for people requiring an easy-to-understand, simple-to-use system: the data is stored right inside the Depot file.
But Depot also caters to power users and enterprise requirements, and provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.
Depot is much more than a tool that can be used for stand-alone purposes: it is also perfectly integrated with the Complete OFFICE suite's other applications.
For example:
• Depot can supply address book data for mail merges in Wordsmith, using the industry-standard LDAP protocol, or using commonly-seen address book formats such as Microsoft Outlook, Microsoft Windows, Mozilla and of course - CompleteMAIL;
• Depot can be used for creating linked data ranges in Numerate files, for data pilot analysis or as the basis for charts.
Therefore, although the Depot database front end is a powerful asset in itself, it also adds major functionality and potential to the other Complete OFFICE applications. If used in conjunction with the macro programming capability that is also incorporated in each Complete OFFICE component, you have usage possibilities that are almost only bounded by your imagination.
If you're looking for a database for single-user situations, Depot comes configured with the full HSQL relational database engine. It's an ideal solution for uncomplicated needs, and for people requiring an easy-to-understand, simple-to-use system: the data is stored right inside the Depot file.
But Depot also caters to power users and enterprise requirements, and provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.
Depot is much more than a tool that can be used for stand-alone purposes: it is also perfectly integrated with the Complete OFFICE suite's other applications.
For example:
• Depot can supply address book data for mail merges in Wordsmith, using the industry-standard LDAP protocol, or using commonly-seen address book formats such as Microsoft Outlook, Microsoft Windows, Mozilla and of course - CompleteMAIL;
• Depot can be used for creating linked data ranges in Numerate files, for data pilot analysis or as the basis for charts.
Therefore, although the Depot database front end is a powerful asset in itself, it also adds major functionality and potential to the other Complete OFFICE applications. If used in conjunction with the macro programming capability that is also incorporated in each Complete OFFICE component, you have usage possibilities that are almost only bounded by your imagination.
