These articles will present use cases which are technically oriented. Concerning system design aspects after having modeled the conceptual model in CaseTalk. If you have questions which remain unanswered please ask us. Your question may lead to an article on our website for the benefit of you and others.

Idera ER/Studio is a data modeling tool with a modern looking interface and great support for a wide range of databases. CaseTalk supports the logical data models using the a script generator. The generated script can simply be executed inside ER/Studio to have the logical model automatically build for you.

PowerDesigner is a tool used by many data architects. CaseTalk strengthens them in using language and well documented entities and tables. Yet, if your goal is simply to draw an relational diagram, you should perhaps consider replacing that with the CaseTalk Viewer.

Denodo is a Data Virtualization environment where the entire process of ETL is reduced to a configurable set of layers containing various views. These views depend on table definitions which reside in source systems. The upper layers of views should represent the business needs and are in need of solid data modeling. These upper layers of views in Denodo are like an interface. The most common usage is in a top-down design where you first define the fields and later associate the implementation(data) of the interface.

A conceptual information model of the business is a great asset. It's a solid investment since it is technology independent. Since IT undergoes changes at an accelerating pace, the only real long lived asset is this information model.

The reverse engineering creates an elementary CaseTalk model through a simple ADO connection. The tables, columns, key information and relations are all created as facts and are made verbalizeable. This way the database model can be validated as a conceptual model following the regular well formedness rules.