Break Down Data Silos: Cross Heterogeneous Boundaries with a Single SQL Query | The Technology Behind GBase 8a DBLink

What is DBLink?

"The data is right there, yet it feels like there's an impenetrable wall."

In today’s era of deep digital transformation, enterprise data is often scattered across multiple business systems, database clusters, and even heterogeneous data sources. Traditional data integration relies on complex ETL processes that are time-consuming and costly, and business demands can’t always wait for "tomorrow's" data.

GBase 8a MPP Cluster’s DBLink feature was purpose-built to break through this wall.

DBLink (Database Link) provides cross-cluster and cross-heterogeneous database access capabilities in GBase 8a. Through a transparent gateway mechanism, users can directly access remote database objects within a GBase 8a cluster as naturally as they would local tables.

Core Value: Achieve real-time associative analysis of local and remote data with a single SQL query — no data migration, no complex ETL.

Four Core Advantages of DBLink

01 Heterogeneous Integration: Breaking Database Boundaries

GBase 8a homogeneous DBLink uses a transparent gateway for cross-cluster access. The gateway acts as a bridge, handling authentication and command dispatch to the source cluster; the source receives tasks and executes them in parallel. Depending on the task type, results are either returned via the gateway or sent directly point-to-point from the source to the target end. The entire process supports SSL encryption to ensure data security. DBLink not only connects GBase 8a clusters but also seamlessly interfaces with heterogeneous databases such as Oracle, MySQL, Dameng, OceanBase (Oracle tenant), GaussDB, Teradata (TD), and GBase 8c. Whether you are in a coexistence period during Oracle migration to domestic platforms or in a multi-technology stack enterprise environment, DBLink allows GBase 8a to serve as a unified data access entry point.

02 Transparent Access: SQL On-Demand

Once a DBLink is created, remote tables can be directly referenced using the @dblink_name syntax. No application changes are required, and the learning curve is minimal.
-- Query a remote Oracle table
SELECT * FROM
oracle_schema.employees@ora_link WHERE dept_id = 1001;
-- Join local and remote tables in real time
SELECT a.order_id,
b.customer_name FROM
local_orders a JOIN
oracle_customers@ora_link b ON a.cust_id = b.id;

03 Bidirectional Data Flow: Push and Pull with Ease

DBLink supports two data interaction modes:
1. Data Pull:
SELECT remote data into local, commonly used for reporting and data comparison;
2. Data Push:
INSERT INTO ... SELECT to push local data to remote, commonly used for data distribution and result synchronization.
It also supports Passthrough mode, which directly forwards SQL to the remote database for execution, supporting full DML operations including INSERT, UPDATE, DELETE, TRUNCATE, and MERGE for true bidirectional capability.

04 Seamless Cloud-Hybrid Connectivity

GBase 8a Cloud Data Warehouse (GCDW) supports connectivity with on-premises traditional GBase 8a clusters through DBLink. As enterprises evolve to cloud-native architectures, there’s no need for a full-scale migration at once—DBLink enables a smooth transition under a hybrid architecture.

Seven Real-World Application Scenarios

01 Cross-System Data Integration in Financial Services

A bank’s core system data resides in Oracle, while its risk control analytics platform is built on GBase 8a. With DBLink, risk models can directly join with customer transaction records from the core system, making T+0 real-time risk control a reality.

02 Centralized Analysis for Enterprise Groups

Each subsidiary of a group deploys its own database, and the headquarters builds a "logical data warehouse" through DBLink to query sales and inventory data across all subsidiaries in a unified manner, eliminating hours of daily ETL waiting.

03 High-Performance Homogeneous Database Migration

A bank’s GBase cluster is being migrated to Inner Mongolia. With minimal network latency (20 ms), data migration via DBLink can reach speeds exceeding 1,100 MB/s.

04 Parallel Running During Database Migration

During the Oracle migration process, some services have already moved to GBase 8a while others remain on Oracle. DBLink enables real-time data interchange between the two systems, making the cutover smoother and risks more manageable.

05 Hybrid Architecture: Cloud Data Warehouse and On-Premises Databases

The cloud data warehouse handles analytical computation, while the on-premises databases handle transaction processing. This forms a closed loop: on-premises data is uploaded to the cloud for analysis, and cloud results are written back to on-premises systems.

06 Regulatory Reporting and Data Marts

Regulatory data is scattered across multiple business clusters. With DBLink, it is consolidated into a data mart layer, combined with local dimension tables for further processing, increasing reporting efficiency several times over.

07 Zero-Downtime Data Migration Transition

When migrating from Oracle, MySQL, or other databases to GBase 8a, you can first establish connections via DBLink and then gradually switch read paths on the business side, ensuring an "active-active" setup during the migration.

In a data-driven era, speed and connectivity are core competitive advantages. GBase 8a’s DBLink feature enables enterprises to instantly fuse multi-source data and unlock its value — without starting from scratch or waiting for lengthy data migration.