Database Administrator

TM can reduce the time and effort consuming procedure of increasing database performance as well as ensuring its availability by automating repeating tasks, thereby decreasing mistakes. TM has from the outset been designed to accommodate database integration, and has been successfully deployed on many large data migration projects. Benefits include:

• Allowing direct connection and management to the majority of databases, including common databases, such as:
  • Oracle Sybase
  • Postgre SQL
  • SQL Server
  • DB2
  • My Access
  • MySQL Additional

JDBC Drivers can also be specified for database connections.

• Decreasing mistakes by using an excellent iterative testing system, a debugger and meta data analysis, such as impact analysis and data lineage.
• Simplifying procedures and improving performance by automating repeating tasks and low level transforms.
• Increasing security

Specific database features include:

• Multi table batch writing where TM automatically determines that writing to Tables in batch mode is performed such that all table constraints are automatically obeyed.
• Table Plug-ins can be introduced to take specific actions as data is read or written, and can for example be used to ensure of caching of frequently accessed data.