All Products
Search

This Product

    DataWorks:GBase 8a

    Document Center

    DataWorks:GBase 8a

    Last Updated:Mar 26, 2026

    Use the GBase 8a node in DataWorks to write and schedule SQL tasks against a GBase 8a database, then integrate those tasks into broader data pipelines.

    Background information

    GBase 8a is a relational database management system (RDBMS). It supports storing large volumes of data and high-concurrency read and write operations. It is often used in sectors such as government, finance, telecommunications, and energy. GBase 8a supports SQL standards and provides various enterprise-level features, such as data partitioning, load balancing, and disaster recovery backups. For more information, see the official GBase 8a website.

    Supported regions

    China (Hangzhou), China (Shanghai), China (Beijing), China (Shenzhen), China (Chengdu), China (Hong Kong), Singapore, Malaysia (Kuala Lumpur), Germany (Frankfurt), US (Silicon Valley), and US (Virginia).

    Prerequisites

    Before you begin, make sure you have:

    • A Business Flow in DataStudio. DataStudio organizes development by Business Flows — create one before creating a node. See Create a workflow

    • A GBase 8a data source added to your workspace using a Java Database Connectivity (JDBC) connection string. See Data Source Management and GBase 8a data sources

    • Network connectivity between the data source and the resource group you plan to use. See Network connection solutions

    • (Optional, required for RAM users) The RAM user added to the workspace with the Develop or Workspace Administrator role assigned. Grant the Workspace Administrator role with caution due to its elevated privileges. See Add members to a workspace

    Step 1: Create a GBase 8a node

    1. Go to the DataStudio page. Log on to the DataWorks console. In the top navigation bar, select a region. In the left-side navigation pane, choose Data Development and O\&M \> Data Development. Select your workspace from the drop-down list, then click Go to Data Development.

    2. Right-click the target business process and choose New Node \> Database \> Gbase8a.

    3. In the Create Node dialog box, enter a Name for the node and click Confirm.

    Step 2: Develop a GBase 8a task

    Select a data source

    If your workspace has multiple GBase 8a data sources, select one on the node configuration page. If only one data source exists, it is used automatically.

    Note

    GBase 8a nodes support only GBase 8a data sources that are created using a Java Database Connectivity (JDBC) connection string.

    Write SQL

    Enter your SQL in the code editor. Example:

    SELECT * FROM usertablename;

    Use scheduling parameters

    DataWorks scheduling parameters let you pass dynamic values into your SQL at runtime. Define variables in the ${Variable name} format in your code, then set their values in the Schedule section of the Properties tab.

    Example:

    SELECT '${var}'; -- Used together with scheduling parameters.

    For parameter formats and configuration details, see Formats of scheduling parameters and Configure and use scheduling parameters.

    Step 3: Configure task scheduling

    Click Scheduling Configuration on the right panel and set the scheduling properties. For details, see Overview.

    Note

    Configure the Rerun Property and Upstream Dependent Node before submitting the task.

    Step 4: Debug the task

    1. (Optional) Select a debugging resource group and assign parameter values. Click the 高级运行 icon in the toolbar. In the Parameters dialog box, select a resource group and assign values to any scheduling parameters. For parameter assignment logic, see Task debugging process.

    2. Save and run the task. Click the 保存 icon to save, then click the 运行 icon to run.

    3. (Optional) Run a smoke test. Run a smoke test during or after submission to verify execution in the development environment. See Perform smoke testing.

    Step 5: Submit and publish the task

    1. Click the 保存 icon to save the node.

    2. Click the 提交 icon to submit. In the Submit dialog box, enter a Change Description and select code review options.

      Note

      • Configure the Rerun Property and Upstream Dependent Node before submitting.

      • If code review is enabled, a reviewer must approve the code before it can be published. See Code review.

    3. In standard mode workspaces, click Publish in the upper-right corner to deploy to production. See Publish tasks.

    What's next

    After the task is published, it runs on a recurring schedule based on its configuration. Click O\&M in the upper-right corner to open Operation Center, where you can view the scheduling and running status of the recurring task. See Manage recurring tasks.