Export
Execute custom SELECT queries and export results directly to files. Define output format, field delimiters, record limits, and choose to overwrite or append to existing files.
New in Version 8
InTouch SQL Tool
Enterprise Database Integration Without the Enterprise Complexity
Eliminate ETL Tools. Eliminate Custom Scripts. Keep Your Budget.
Native database connectivity without expensive ETL tools, insecure scripts, or complicated middleware. Connect to virtually any database — Oracle, SQL Server, MySQL, PostgreSQL, and more — with a single, secure, reusable connection.
Key Benefits
Reduce Costs
Eliminate expensive ETL tools like DataStage and Informatica. InTouch delivers enterprise-grade database integration at a fraction of the cost.
Enhanced Security
Centralized credential management with AES-256 encrypted passwords. No more credentials scattered across scripts and config files.
Exceptional Performance
Proprietary batching technology delivers imports 1000X faster than standard JDBC. Configurable batch sizes for optimal throughput.
Simplicity
Minimal SQL knowledge needed — InTouch generates correct SQL syntax for your target database. Define what you need, not how to get it.
Security Advantage: No More Script Vulnerabilities
InTouch stores all database connections in a secure, centralized repository with encrypted passwords and role-based access control. When credentials change, update one connection object instead of hunting through dozens of scattered scripts. Eliminate the security risk of plaintext passwords in shell scripts, batch files, and configuration files.
Database Operations
Import
Load data using proprietary batching technology — 1000X faster than standard JDBC. Intelligent column mapping, automatic header handling, and configurable batch sizes.
SQL Statement
Execute any SQL statement directly — UPDATE, DELETE, INSERT, DDL. Modify records, reset triggers, update inventory, or alter database structures.
SQL Stream
Execute complex sequences of SQL operations defined inline or loaded from a file. Transaction control with commit and rollback support.
Stored Procedure
Execute stored procedures across all supported database types. Full parameter support including IN, OUT, and IN-OUT parameters with result set handling.
Universal Database Support
Oracle
Including Oracle Autonomous Database and all on-premises versions.
Microsoft SQL Server
On-premises and Azure SQL Database.
MySQL / MariaDB
All modern versions with full feature support.
PostgreSQL
Including Amazon RDS, Aurora, and all cloud variants.
IBM Db2
Mainframe, LUW, and cloud deployments.
Any JDBC-Compatible
Snowflake, Teradata, SAP HANA, Sybase, and more.
Why InTouch Over Scripts and ETL Tools?
| Capability | Manual Scripts | ETL Tools | InTouch SQL Tool |
|---|---|---|---|
| Credential Management | Plaintext in scripts | Proprietary vaults | AES-256 encrypted, centralized |
| Connection Validation | Fails at runtime | Varies | Pre-execution validation |
| Error Handling | Silent failures common | Complex configuration | Automatic detection and notification |
| Cross-System Workflows | Custom glue code | Limited | Native orchestration |
| Audit Trail | Manual logging | Varies | Complete timestamped logs |
| Scheduling | external scheduler | Built-in but expensive | Visual scheduler with triggers |
| Password Rotation | Update every script | Varies | Update one connection object |
| Error Notification | Build your own | Complex setup | Automatic email/subscriber alerts |
Use Cases
- ETL Pipeline Orchestration — coordinate multi-step data extraction, transformation, and loading across databases
- Data Warehouse Loading — scheduled bulk imports with proprietary batching for maximum throughput
- Report Generation — automated data extraction and formatting for business reporting
- Business Process Automation — trigger database operations based on events, schedules, or file arrivals
- Data Validation — scheduled queries to verify data integrity across systems
- Cross-Database Synchronization — keep data consistent across multiple database platforms
Technical Specifications
Connection Type
JDBC-based with connection pooling
Database Support
Any JDBC-compatible database
Security
AES-256 encrypted credentials
Transaction Control
Commit, rollback, savepoint support
Result Handling
CSV, Excel, JSON export or in-memory
Parameter Binding
Dynamic variable substitution
Error Handling
Detailed diagnostics and notifications
Logging
Complete audit trail with timestamps
Ready to Eliminate Your ETL Complexity?
Enterprise-grade database integration without the enterprise price tag.
Contact Blue Isle Software