DBmoto Database.pptVIP

HiT Software, Inc. All rights reserved. HiT Software, Inc. All rights reserved HiT Software Confidential With DBMoto , replicate data from a Source Database to a Target Database DB2/400 SQL Server Oracle SQL Server MS Access Oracle MySQL DB2/400 DB2/UDB Sybase DB2/390 SQL Base MySQL INTERNET e-commerce, e-business, customer support DATA WAREHOUSE Statistics, charts, analytical applications, reporting DATABASE MARKETING CUSTOMER RELATIONSHIP MANAGEMENT Real time database replication between DB2/400, SQL Server, Oracle, MS Access, MySQL, DB2/UDB. DBMoto’s powerful enabling technology runs on Windows 2000 and Windows NT. Business intelligence applications based on Windows or WEB need real-time data. Source Databases CLIENT/SERVER Software for Windows Target Databases ODBC OLEDB + DTS * ODBC OLEDB FTP ? * Microsoft SQL Server Data Transformation Services Specific for DBMS ? ? ? ? No program development on DBMS ? ? ? ? No program development on Windows ? ? ? ? Process intensive on DBMS ? ? ? ? User-defined functions ? ? ? ? Event-based ? ? ? ? Based on Transaction Log ? ? ? ? Detailed logs ? ? ? ? Wizard-based SQL tables creation ? ? ? ? Easy replication setup ? ? ? ? Real-time ? ? ? ? Comparison between DBMoto and other solutions Source database Target database From Source to Target Database: Start the process in a few minutes DBMoto easily supports you in: Creating tables in your target database (SQL Server, Oracle, DB2/400, MS Access, MySQL, DB2/UDB and Sybase) Defining replication criteria (tables, fields and transformation functions) Starting the data replication process HiT DBMoto Main Features User friendly Full refresh (all records scanned) Real-time mirroring (based on Source journal) No programming needed on DBMS No naming conventions or proprietary fields needed on Source database objects. Entire replication process configured and managed from Windows platform.