A relational database is an organized collection of tables and views that contain related data. Data can be accessed and searched in many different ways without any changes needed to the database tables.

Most relational databases use a structured query language (SQL) to search and gather information from the data stored in the database.

Tungsten Transformation Toolkit supports the following relational databases:

• Microsoft SQL Server

• ODBC connected databases

• Oracle

To manage relational databases:

• Create a connection to a relational database

• Configure the connection:

  • Configure a Microsoft SQL Server connection.

  • Configure an ODBC connection.

  • Configure an Oracle connection.

  • Set up authentication for the relational database connection.

• Create a relational database.

Related topics:

• Databases tab - Project Settings window

• Manage databases