Data Moving Tool

Data Moving Tool

Data Moving tool (DMT) is a Windows based ETL that Extracts, Transforms and Loads data to and from any data source. DMT was created by S.E.R. Software Solutions, a small California software company. DMT is designed to handle small to medium data volumes.

Contents

Overview / architecture

DMT is a Windows application composed of the DMT client and the DMT service. The DMT client allows users to create, manage and run extracts and loads from a windows user interface. Extracts and loads can be run on demand from the client. The DMT service contains the DMT scheduler that automatically runs extracts and loads at specific times, dates or intervals. The DMT service is a windows service that runs in the background without any user interaction (typically on a server). DMT uses the Microsoft .NET framework (2.0 and above) and communicates with databases through ODBC.

Functionalities

Data extraction (exports)

Data can be extracted from any ODBC data source. Users enter their own SQL statement to extract the data. Extracted data can be saved into data files in many formats (CSV, Tab delimited, HTML, delimited text, etc.) or reused by a load.

Data load (imports)

Data can be loaded data into any ODBC data source. It can be loaded into one or several destination tables (in the same or different databases). The data to load can come from any ODBC data source or data files in many formats (created by DMT or another program).

Data transformation

Data can be transformed before it is loaded into a destination table (e.g. Data combination, filtering, calculations, etc.). DMT can perform its own transformation with predefined functions and operators or let the target database perform the transformations with the target database set of functions and operators.

Scheduling

Extracts and loads can be scheduled to run automatically at specific times, dates or intervals. DMT's scheduler handles 4 configurable scheduling frequencies: Regular Interval, Daily, Weekly and Monthly (e.g. 1st Monday of each month, last day of each month, every 10th of the month, etc.).

Pre and post processes

DMT can execute external processes before and after the run of extracts and loads.

  • Run SQL statements or stored procedures
  • Execute external programs (i.e. run a command line)
  • Upload or download files via FTP
  • Send emails (with attachment containing exported or loaded data)

Run pre-conditions

Run pre-conditions allow extracts and loads to be triggered only if specified conditions are met.

  • Check the result of an SQL statement
  • Check the presence or content of a file

Supported databases

DMT supports any ODBC compliant database, e.g. Oracle, SQL Server, Sybase, IBM DB2 / Informix, MySQL, MS Access and many more including old ones (Visual FoxPro, DBase, etc.)

Version releases

Version Released Date
DMT 1.0 July 2010
DMT 2.0 April, 2011

External links


Wikimedia Foundation. 2010.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • Data General — Industry Computer Fate Acquired Successor EMC Corporation Founded 1968 …   Wikipedia

  • Tool — For other uses, see Tool (disambiguation). A modern toolbox. A tool is a device that can be used to produce an item or achieve a task, but that is not consumed in the process. Informally the word is also used to describe a procedure or process… …   Wikipedia

  • data compression — Process of reducing the amount of data needed for storage or transmission of a given piece of information (text, graphics, video, sound, etc.), typically by use of encoding techniques. Data compression is characterized as either lossy or lossless …   Universalium

  • machine tool — machine tooled, adj. a power operated machine, as a lathe, used for general cutting and shaping of metal and other substances. [1860 65] * * * Stationary, power driven machine used to cut, shape, or form materials such as metal and wood. Machine… …   Universalium

  • Match moving — In cinematography, match moving is a visual effects, cinematic techniques that allows the insertion of computer graphics into live action footage with correct position, scale, orientation, and motion relative to the photographed objects in the… …   Wikipedia

  • Autoregressive moving average model — In statistics, autoregressive moving average (ARMA) models, sometimes called Box Jenkins models after the iterative Box Jenkins methodology usually used to estimate them, are typically applied to time series data.Given a time series of data X t …   Wikipedia

  • Yet another Setup Tool — Infobox Software name = Yet another Setup Tool caption = YaST 2.16.51 (included in openSUSE Linux 11.0) collapsible = author = SuSE developer = Novell released = latest release version = 2.16 latest release date = latest preview version = latest… …   Wikipedia

  • Electronic data capture — An Electronic Data Capture (EDC) system is a computerized system designedfor the collection of clinical data in electronic format for use mainly in human clinical trials.Typically, EDC systems provide: * a graphical user interface component for… …   Wikipedia

  • Triple Exponential Moving Average - TEMA — A technical indicator used for smoothing price and other data. It is a composite of a single exponential moving average, a double exponential moving average and a triple exponential moving average. Developed by Patrick Mulloy, the TEMA was first… …   Investment dictionary

  • Dynamic Analysis and Replanning Tool — The Dynamic Analysis and Replanning Tool, commonly abbreviated to DART, is an artificial intelligence program[1] used by the U.S. military to optimize and schedule the transportation of supplies or personnel and solve other logistical problems.… …   Wikipedia

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”