Product Home
DTM Data Comparer Online Documentation Prev Page Prev Page
General
Product profile
Connect
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Comparison
Synchronization
Table to Table Mode
Synchronous Navigation
Face-to-Face View
Database Mode
Key Definition
Column Mapping
Settings
General Settings
User Interface
Comparison Settings
Synchronization Settings
Report Settings
Project Properties
Script Viewer
Command Line
Console Mode
Process Cancellation
Comparison Report
Collate Window
Run SQL statement
SQL Console
Hot Keys
Information
Limitations
Support
License
Demo and Full versions
Install
How to buy
Upgrade
Uninstall
Products
Trademark Information
Glossary

Connection Quick Start Guide

Database How to connect
MS SQL Server Enter or select server name at the direct connection panel
Local SQL Server Express Enter .\SQLEXPRESS as server name at the direct connection panel
Oracle 1) Switch to data sources mode
2) select OCI as "Interface"
3) select your service name from data source drop-down menu
DB2 Use direct connection panel or
Use predefined ODBC DSN for custom connection settings
MySQL Install ODBC driver for MySQL from www.mysql.org
Use direct connection panel or
Use predefined ODBC DSN for custom connection settings
PostgreSQL Use direct connection panel or
Use predefined ODBC DSN for custom connection settings
Interbase/Firebird Install ODBC driver
Use direct connection panel or
Use predefined ODBC DSN for custom connection settings
Microsoft Access 1) Switch to "Desktop File" panel
2) Select "Access" as file type, enter or select file name
Microsoft Excel 1) Switch to "Desktop File" panel
2) Select "Excel" as file type, enter or select file name
Another database 1) Install ODBC driver for your database system
2) Create ODBC data source name using Windows ODBC Administrator
3) Switch to data sources mode
4) select your data source from drop down menu