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
The old paradigm is out. The new paradigm is AI. AI automation is InTouch AI — and database work runs on a general AI-native engine, not a dead config-era box.
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.
A specialized ETL box does one thing and can never grow an AI core. A general AI-native engine does everything that box does — and then reads its own failures, refreshes an expired connection, smart-retries the load, and tells you in one sentence what happened. The reverse is impossible. That is why a general engine eats specialized tools.
Key Benefits
Reduce Costs
Eliminate expensive ETL tools like DataStage and Informatica. InTouch AI 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 AI generates correct SQL syntax for your target database. Define what you need, not how to get it.
Security Advantage: No More Script Vulnerabilities
The credential vault is the trust floor. Database connections live in a centralized repository with AES-256 encrypted passwords, referenced by name, never written into a script — and never exposed even to the AI itself. 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, governed by role-based access control.
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?
Competitors bolt AI onto a config-era core. You can't bolt on a center. InTouch was built with AI at the center, and the vault, scheduling, RBAC, and audit sit behind it. The contract is now intelligent: tell it what to do, when, what to do when it works, what to do when it doesn't, and who to notify — and the "doesn't work" clause is no longer a dumb retry-and-email-a-log rule. It reads the failure, knows why, and heals it. No legacy ETL tool can say that.
| 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?
Stop bolting AI onto a dead config-era core. Run your database work on the engine that was built AI-native — enterprise-grade integration without the enterprise price tag.
Contact Blue Isle Software