Software Products: TableTrans®

TableTrans software lets you specify complex data transformations easily, as sequences of simple transform steps. TableTrans works with Oracle to build, store and generate code for data transformations. The user interface displays transformations intuitively as icons and connections that represent transform steps and their ordering. The program provides reliable transformation by replacing intricate programs written in statistical or database programming languages with transformations comprised of prebuilt, fully tested components. Automatic documentation supports design review to ensure each transformation's correct specification and implementation. By providing rapid and intuitive access to data and metadata, TableTrans helps you review the content and structure of the database at any point in a data transformation. Leading biopharmaceutical and medical device companies use TableTrans to migrate legacy databases, load data warehouses, validate data and other complex and intricate data manipulation tasks.

Key Features 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, specify optional parameters to control each table's physical storage and 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
• 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

System Requirements for TableTrans

• TableTrans Client and TableTrans Administration Tool
• • Workstation: Pentium-class PC
  • Operating system: Windows 2000, XP, Vista
  • Oracle client software that supports (at the minimum) the version of the database to which they will be connecting

Supported:

• Access to Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g with Oracle's networking software (Net Services, Net8,  SQL*Net, etc.)
• Direct import of SAS transport files created with SAS PROC COPY, XPORT Engine, version 6.12 or higher
• All Windows-compliant ODBC drivers including SAS Universal ODBC