TableTrans^®

Specify, execute, and automatically document complex data transformations
Specify and extract transformed data interactively or in batch mode to files or databases
Provides a wide range of built-in transformation operators and database functions to minimize programming
Replaces intricate programs written in statistical or database languages
Includes features specifically designed to support compliance with 21 CFR Part 11

Visual Programming
Simplify data management and retrieval tasks through visual programming. TableTrans enables companies to migrate valuable legacy data accurately and reliably, by simplifying the specification, execution, documentation, and review of complex transformations.
Transform data visually, step-by-step.
Develop complex data transformations faster and with fewer errors than by writing and debugging code.
Visual transformations diagrams are easy to understand, modify and explain to others.

Flexibility
Take fine control over data transformation. TableTrans lets you control how tables are created and stored to ensure efficient execution. You can index tables to accelerate the execution of downstream transform steps, you can specify optional parameters to control each table's physical storage, and you can sample a table's rows to create representative subsets of the database to test and debug your transformation logic quickly.
Select from many data transformation operators. TableTrans provides dozens of transform steps to help you restructure data. All the functionality of SQL is available without programming. Built-in dialogs make complex tasks, like multi-way joins, table folding or unfolding, and table column mapping easy to configure.
Make complex data transformation simple. TableTrans lets you develop the processing for complex tasks in minutes.

Examples:

• Specify high performance text classification algorithms by defining sequences of lexical operations to standardize text, followed by database lookups that search dictionaries and synonym lists for matching codes.Flexible autocoding helps users evaluate and deploy algorithms to support emerging coding standards such as medDRA.

• Import data from ASCII, SAS, Oracle and ODBC sources, join or union data together, remove duplicates, remove columns, subset rows or derive new columns using all the power of Oracle, restructure data through table unfolding or folding operations, and map these data to a pre-existing table's schema, and then insert rows into an existing table.

Accuracy & Reliability
Maintain accuracy and reliability during data transformations. TableTrans provides reliable transformation by replacing intricate programs written in statistical or database programming languages with transformations comprised of pre-built, fully tested components. Automatic documentation supports design review to ensure each transformation's correct specification and implementation.

Reusability
Reuse and share data transformations.TableTrans transformations contain sets of self-contained steps, and this makes them easy to review, modify, and reuse. The visual user interface lets you see the overall logic of each transformation, and then drill down to see the details of each transform step. Parameterized transform steps prompt users for values at execution time, so you can create flexible transformations that are easily reused. You can also create subdiagrams to combine transform steps, so the database logic can be reused in other transformations.
Implement complex and reusable validation strategies. TableTrans lets you validate data easily by specifying SQL expressions to select records containing inconsistent column values. You can create cross-table edit checks by validating tables or views which join two or more tables. Downstream transform steps can be used to insert error log records which identify the type of error found in each faulty data record, to support discrepancy resolution.

Automatic Documentation
Automatically document data transformations. TableTrans produces documentation automatically that describes each transformation's logic. This feature helps cross-functional teams specify, review, and validate transformation designs effectively and thoroughly.

21 CFR Part 11 Compliance
TableTrans is 21 CFR Part 11 compliant and can therefore be used to process clinical data in regulated environments.
Audit session information is recorded automatically, by default, and stored in the database server.
Support for row-level auditing is built-in and is initiated on demand.