DMT (Data Moving Tool) A micro ETL to move data across any data sources
Download

DMT (Data Moving Tool) Ranking & Summary

DMT (Data Moving Tool) Tags

extractor Migrate data extractor data mover migrator data migrator Compare Data Sources data move ETL move Dropbox data data sources metadata driven ETL move data micro-biology data analysis data sources mapper expression micro-array data Powerful ETL tool

DMT (Data Moving Tool) Description

Data Moving Tool (DMT) Extracts, Transforms, Loads and Schedules data across any data source. No need for dedicated database tools. With DMT (Data Moving Tool) you'll be able to easily migrate your data and schedule the jobs in no time! NOTE: You need to apply for a trial key on this page in order to use the software. Main features: Data Extraction Features: Extract data from virtually any database Use your own SQL statements to control extracted data Generate data files in various formats Run extracts on demand at any time Unlimited number of extracted rows Run extracts automatically via scheduler Support Pre-Conditions and Pre/Post Processes Data Load Features: Load data into virtually any database Load data files in various format Link loads to extracts Data filtering (load conditions) Load data into multiple tables using UK and FK Run loads on demand at any time Unlimited number of loaded rows Run loads automatically via scheduler Support Pre-Conditions and Pre/Post Processes Data Transformation Features: DMT Transformations (performed by DMT independently from the target database) Database transformations (performed by the target database via its dedicated functions) Scheduler Features: Run extracts and loads Continually, Daily, Weekly, Monthly Begin and End date/time, max num of runs, run at specific time Run on specific days or months Advanced feature: Run every 1st, 2nd, 3rd, 4th, 5th or last Mon, Tue, Thu, Fri, Sat, Sun of the month Advanced features: Run every last Day of the month Run Pre-Conditions Features: Check the return of any SQL query before running extracts or loads Check the presence and/or content of a file before running extracts or loads Pre & Post Processes Features: Execute SQL statements or stored procedures before or after extracts or loads Execute a command line before or after extracts or loads Miscellaneous Features: Organize extracts and loads into groups and jobs Run Variables usable almost anywhere (e.g. insert runtime information in a log table) Expression editor/evaluator to facilitate editing/testing of complex load expressions Detailed customizable logs with Errors, Warnings, Run Events Powerful scheduler (windows service running in the background)

DMT (Data Moving Tool) Related Software