Database Integrations

Fast Connection to Any Database or ERP

Compatible with BAS ERP, 1C, PostgreSQL, Microsoft SQL Server, MySQL, SAP, and Odoo. 100% Read-Only through isolated replica.

Integrations & Compatibility

Supported Databases, ERP Systems & Data Warehouses

Seamless compatibility with modern and legacy enterprise infrastructure. 100% read-only access without altering source configurations.

ERP & Accounting8.2, 8.3, BAS ERP, Manufacturing, Trade Management

BAS & 1C Enterprise

Full support for BAS ERP, Trade Management, Manufacturing, and Accounting. Automatic translator of low-level table IDs (_AccumRG, _Document) to business terminology.

Direct reading of accumulation and periodic registers

Support for OData REST API or native SQL via read replica

0% CPU and memory footprint on 1C application cluster

Preserves complex multi-currency document posting logic

Режим: Read-Only SQL Replica / OData Standard

Relational DBMSPostgreSQL 11, 12, 13, 14, 15, 16, 17+

PostgreSQL

Deep integration with enterprise PostgreSQL. Supports streaming physical/logical replication, table partitioning, TimescaleDB, and pgvector extensions.

Hot Standby replica connectivity with sub-second lag

Parallel execution of heavy analytical queries

JSONB column parsing for semi-structured data

Query optimization via pg_stat_statements metrics

Режим: Direct Streaming Replica (TLS 1.3)

Enterprise DBMSMS SQL Server 2012, 2014, 2016, 2019, 2022

Microsoft SQL Server

Tuned for high-throughput MSSQL instances. Native support for AlwaysOn Availability Groups with read-only routing and snapshot isolation.

AlwaysOn Availability Group secondary routing

Non-blocking query execution (SNAPSHOT isolation)

Columnstore table support for lightning OLAP queries

Granular SQL Login and Active Directory service accounts

Режим: AlwaysOn Secondary Replica / Read-Only User

Global Enterprise ERPSAP ECC 6.0, SAP S/4HANA 1909-2023+

SAP ERP & SAP S/4HANA

Connects to SAP HANA in-memory analytical views and core FI/CO, SD, MM modules via certified read-only RFC and CDS views.

Real-time queries to Core Data Services (CDS Views)

Secure authorization via RFC / NetWeaver protocols

Consolidated ledger, debtor, and inventory analytics

Full compliance with ISO 27001 and enterprise security standards

Режим: SAP RFC / HANA Read-Only Replica

Modular ERPOdoo 14, 15, 16, 17, 18+

Odoo ERP

Direct semantic mapping with Odoo ORM models (Accounting, Inventory, Sales, CRM). Multi-company ledger separation and automated warehouse tracking.

Direct PostgreSQL representation of Odoo models

Warehouse tracking across internal and transit locations

Instant sales order unit margin calculation

Compatible with both Community and Enterprise editions

Режим: PostgreSQL Read Replica / API

Web Databases & Columnar StoresMySQL 8+, MariaDB 10.5+, ClickHouse 22+

MySQL, MariaDB & ClickHouse

Integration with e-commerce relational databases and columnar ClickHouse clusters for processing millions of analytical rows per second.

Sub-second aggregation over massive retail sales records

Asynchronous replication without affecting store performance

Multi-region data mart federation

Extremely low memory and CPU footprint

Режим: Read Replica / Columnar Storage Node

How to Connect in 3 Simple Steps (DBA Guide)

Straightforward setup process requiring zero application restarts.

Provision a SELECT-only Database User

Create a dedicated service user with strict SELECT-only privileges. This makes write or destructive operations physically impossible.

CREATE USER talktobase_ro WITH PASSWORD "secure_pass";
GRANT CONNECT ON DATABASE production_db TO talktobase_ro;
GRANT USAGE ON SCHEMA public TO talktobase_ro;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO talktobase_ro;

Establish Encrypted Network Channel

Whitelist TalkToBase dedicated static IP or establish a WireGuard / IPSec VPN tunnel. All traffic is encrypted via TLS 1.3.

Fast Automated Metadata Indexing

TalkToBase introspects schema definitions and compiles a semantic knowledge graph. Executives can query data in Telegram right after setup.

Frequently Asked Questions by CTOs and DBAs

Can TalkToBase queries cause locks on our production database?

No. Queries run strictly against a read replica and utilize non-blocking snapshot isolation modes.

How are obscure ERP table names resolved?

TalkToBase incorporates an automated schema parser that resolves technical names into human-readable business semantics.

Can we restrict access to sensitive columns (e.g., salaries)?

Yes. You can revoke permissions at the SQL user level or configure data masking in the TalkToBase admin portal.

GET STARTED

Order Your Free TalkToBase Evaluation Pilot

We will connect a test replica in 15 minutes and demonstrate how AI answers real questions about your business.