Catalogs and schemas in database systems - Cloud

Talend Cloud API Services Platform Studio User Guide

Talend Documentation Team
Talend Cloud
Design and Development
Talend Management Console
Talend Studio
The structure of a database defines how objects are organized in the database. Different data storage structures are used to store objects in databases. For example, the highest-level structure (such as "Catalog" followed by "Schema" and finally by "Table") is not applicable to all database types.
Database name Version Catalog Schema
Oracle   no yes
MySQL   yes no
SQLServer 2000/2005/2008 yes yes
DB2   no yes
DB2 ZOS   no yes
Sybase   yes yes
Informix   yes yes
PointBase   no yes
PostgreSQL   yes yes
AS/400 V5R4 yes yes
Ingres   no yes
Teradata   no yes
Netezza   yes yes
SQLite   no no