Software Products: eLoader™

eLoader automates loading data into Oracle Clinical. Use eLoader to input data from external sources, map data to Oracle Clinical structures, convert incoming data using custom SQL derivations, perform validation checks, generate the Oracle Clinical load file, and run Oracle Clinical batch data load jobs. Leading pharmaceutical companies rely on eLoader to convert studies from legacy systems to Oracle Clinical format.

Key Features and Benefits

• Move data into Oracle Clinical without programming
• • Compare incoming data with existing Oracle Clinical records and automatically calculate repeats, subevents, qualifiers and more
  • Replace custom code traditionally required for data loading with an easy-to-use application
  • Natively understands Oracle Clinical and TMS without programming, and the software is 21 CFR Part 11 compliant
• Automate routine Oracle Clinical data loading tasks
• • Supports important Oracle Clinical processes such as updating repeats and deleting removed records
  • Automate data processing from receipt to final loading as a single background process
• Simplify and speed Oracle Clinical data loading by supporting custom processing
• • Map data elements
  • Convert data values
  • Check records
  • Automatically calculate subevents
  • Repeats and qualifying values
  • Identify incoming records as inserts, updates or deletes
  • Perform tasks interactively or in batch mode
• Load data from common clinical data formats
• • Load data from diagnostic labs, CROs, scanned CRFs, EDC systems, safety systems, Clintrial, SAS and XML data
• Features
• • Import data from any ASCII file (user-defined format), XML file (CDISC) or Oracle table
  • Map items to Oracle Clinical metadata/keys and convert or decode incoming data using SQL
  • View source records and files directly from eLoader
  • Identify and handle incremental, cumulative and deleted data
  • Perform standard or custom validation checks to halt processing or reject records
  • Calculate repeats and subevents automatically
  • Alert administrators of successful and failed jobs automatically
  • Scan, import, prepare and load files into Oracle Clinical automatically
  • Track files from receipt through loading
  • Load terms into TMS without Oracle Clinical study setup
  • Implement protocol and function-based user security
  • Create full audit trails automatically

System Requirements for eLoader:

• Operating System: Windows NT 4.0, 2000
• Memory: 23 Mb
• Disk Space: 10 Mb

Supported:

• Oracle 7.3 and later, including 8i and 9i
• Certified with Oracle Clinical 4.0.x and TMS 4.0.x
• eLoader implements the same technology stack as Oracle Clinical and TMS