Digibee Documentation
Request documentationBook a demo
English
English
  • Quick start
  • Highlights
    • Release notes
      • Release notes 2025
        • May
        • April
        • March
        • February
        • January
      • Release notes 2024
        • December
        • November
        • October
        • September
        • August
          • Connectors release 08/20/2024
        • July
        • June
        • May
        • April
        • March
        • February
        • January
      • Release notes 2023
        • December
        • November
        • October
        • September
        • August
        • July
        • June
        • May
        • April
        • March
        • February
        • January
      • Release notes 2022
        • December
        • November
        • October
        • September
        • August
        • July
        • June
        • May
        • April
        • March
        • February
        • January
      • Release notes 2021
      • Release notes 2020
    • AI Pair Programmer
    • Digibeectl
      • Getting started
        • How to install Digibeectl on Windows
      • Digibeectl syntax
      • Digibeectl operations
  • Digibee in action
    • Use Cases in Action
      • Improving integration performance with API pagination
      • Automating file storage with Digibee
      • Reprocessing strategy in event-driven integrations
      • Key practices for securing sensitive information in pipelines with Digibee
      • OAuth2 for secure API access
      • Secure your APIs with JWT in Digibee
      • Integration best practices for developers on the Digibee Integration Platform
      • How to use Event-driven architecture on the Digibee Integration Platform
      • Dynamic file download with Digibee
      • Microservices: Circuit Breaker pattern for improving resilience
      • Error handling strategy in event-driven integrations
    • Troubleshooting
      • Integration guidance
        • How to resolve common pipeline issues
        • How to resolve Error 409: “You cannot update a pipeline that is not on draft mode”
        • How to resolve the "Pipeline execution was aborted" error
        • Integrated authentication with Microsoft Entra ID
        • How to resolve the "Failed to initialize pool: ONS configuration failed" error
        • How to perform IP address mapping with Progress database
        • How to build integration flows that send error notifications
        • How to send logs to external services
        • How JSONPath differs in connectors and the Execution panel
        • Using JSONPath to validate numbers with specific initial digits
        • How to analyze the "Network error: Failed to fetch" in the Execution panel
        • How to handle request payloads larger than 5MB
        • How to configure Microsoft Entra ID to display groups on the Digibee Integration Platform
        • How to build an HL7 message
      • Connectors behavior and configuration
        • Timeout in the Pipeline Executor connector
        • How to use DISTINCT and COUNT in the Object Store
        • Understanding @@DGB_TRUNCATED@@ on the Digibee Integration Platform
        • How to resolve names without a DNS - REST, SOAP, SAP (web protocols)
        • How to read and write files inside a folder
        • AuthToken Reuse for Salesforce connector
        • How to resolve the "Invalid payload" error in API Integration
        • Supported databases
          • Functions and uses for databases
      • Connectors implementation and usage examples
        • Google Storage: Usage scenarios
        • DB V2: Usage scenarios
        • For Each: Usage example
        • Template and its uses
        • Digibee JWT implementation
        • Email V1: Usage example (Deprecated)
      • JOLT applications
        • Transformer: Getting to know JOLT
        • Transformer: Transformations with JOLT
        • Transformer: Add values to list elements
        • Transformer: Operations overview
        • Transformer: Date formatting using split and concat
        • Transformer: Simple IF-ELSE logic with JOLT
      • Platform access and performance tips
        • How to solve login problems on the Digibee Integration Platform
        • How to receive updates from Digibee Status Page
        • How to clean the Digibee Integration Platform cache
      • Governance troubleshooting guidance
        • How to consume Internal API pipelines using ZTNA
        • How to use Internal API with and without a VPN
        • How to generate, convert, and register SSH Keys
        • mTLS authentication
          • How to configure mTLS on the Digibee Integration Platform
          • FAQs: Certificates in mTLS
        • How to connect Digibee to Oracle RAC
        • How to connect Digibee to SAP
        • How to connect Digibee to MongoDB Atlas using VPN
        • How to manage IPs on the Digibee Integration Platform
        • Configuring the Dropbox account
        • How to use your Gmail account with the Digibee email component (SMTP)
        • How to use the CORS policy on the Digibee Integration Platform
      • Deployment scenarios
        • Solving the “Out of memory” errors in deployment
        • Warning of route conflicts
    • Best practices
      • Best practices for building a pipeline
      • Best practices on validating messages in a consumer pipeline
      • Avoiding loops and maximizing pipeline efficiency
      • Naming: Global, Accounts, and API Keys
      • Pagination tutorial
        • Pagination tutorial - part 1
        • Pagination tutorial - part 2
        • Pagination tutorial - part 3
        • Pagination tutorial - part 4
      • Pagination example
      • Event-driven architecture
      • Notification model in event-driven integrations
      • OAuth2 integration model with Digibee
      • Best practices for error handling in pipelines
    • Digibee Academy
      • Integration Developer Bootcamp
  • Reference guides
    • Connectors
      • AWS
        • S3 Storage
        • SQS
        • AWS Secrets Manager
        • AWS Athena
        • AWS CloudWatch
        • AWS Elastic Container Service (ECS)
        • AWS Eventbridge
        • AWS Identity and Access Management (IAM)
        • AWS Kinesis
        • AWS Kinesis Firehose
        • AWS Key Management Service (KMS)
        • AWS Lambda
        • AWS MQ
        • AWS Simple Email Service (SES)
        • AWS Simple Notification System (SNS)
        • AWS Security Token Service (STS)
        • AWS Translate
      • Azure
        • Azure CosmosDB
        • Azure Event Hubs
        • Azure Key Vault
        • Azure ServiceBus
        • Azure Storage DataLake Service
        • Azure Storage Queue Service
      • Enterprise applications
        • SAP
        • Salesforce
        • Braintree
        • Facebook
        • GitHub
        • Jira
        • ServiceNow
        • Slack
        • Telegram
        • Twilio
        • WhatsApp
        • Wordpress
        • Workday
        • Zendesk
      • File storage
        • Blob Storage (Azure)
        • Digibee Storage
        • Dropbox
        • FTP
        • Google Drive
        • Google Storage
        • OneDrive
        • SFTP
        • WebDav V2
        • WebDav (Deprecated)
      • Files
        • Append Files
        • Avro File Reader
        • Avro File Writer
        • CSV to Excel
        • Excel
        • File Reader
        • File Writer
        • GZIP V2
        • GZIP V1 (Deprecated)
        • Parquet File Reader
        • Parquet File Writer
        • Stream Avro File Reader
        • Stream Excel
        • Stream File Reader
        • Stream File Reader Pattern
        • Stream JSON File Reader
        • Stream Parquet File Reader
        • Stream XML File Reader
        • XML Schema Validator
        • ZIP File
        • NFS
      • Flow
        • Delayer
      • Google/GCP
        • Google BigQuery
        • Google BigQuery Standard SQL
        • Google Calendar
        • Google Cloud Functions
        • Google Mail
        • Google PubSub
        • Google Secret Manager
        • Google Sheets
      • Industry solutions
        • FHIR (Beta)
        • Gupy Public API
        • HL7
        • HubSpot: Sales and CMS
        • Mailgun API
        • Oracle NetSuite (Beta)
        • Orderful
        • Protheus: Billing and Inventory of Cost
      • Logic
        • Block Execution
        • Choice
        • Do While
        • For Each
        • Retry
        • Parallel Execution
      • Queues and messaging
        • Event Publisher
        • JMS
        • Kafka
        • RabbitMQ
      • Security
        • AES Cryptography
        • Asymmetric Cryptography
        • CMS
        • Digital Signature
        • JWT (Deprecated)
        • JWT V2
        • Google IAP Token
        • Hash
        • Digibee JWT (Generate and Decode)
        • LDAP
        • PBE Cryptography
        • PGP
        • RSA Cryptography
        • Symmetric Cryptography
      • Structured data
        • CassandraDB
        • DB V2
        • DB V1 (Deprecated)
        • DynamoDB
        • Google Big Table
        • Memcached
        • MongoDB
        • Object Store
        • Relationship
        • Session Management
        • Stored Procedure
        • Stream DB V3
        • Stream DB V1 (Deprecated)
        • ArangoDb
        • Caffeine Cache
        • Caffeine LoadCache
        • Couchbase
        • CouchDB
        • Ehcache
        • InfluxDB
      • Tools
        • Assert V2
        • Assert V1 (Deprecated)
        • Base64
        • CSV to JSON V2
        • CSV to JSON V1 (Deprecated)
        • HL7 Message Transformer (Beta)
        • HTML to PDF
        • Transformer (JOLT) V2
        • JSLT
        • JSON String to JSON Transformer
        • JSON to JSON String Transformer
        • JSON to XML Transformer
        • JSON to CSV V2
        • JSON to CSV Transformer (Deprecated)
        • JSON Path Transformer V2
        • JSON Path Transformer
        • JSON Transformer
        • Log
        • Pipeline Executor
        • QuickFix (Beta)
        • SSH Remote Command
        • Script (JavaScript)
        • Secure PDF
        • Store Account
        • Template Transformer
        • Throw Error
        • Transformer (JOLT)
        • Validator V1 (Deprecated)
        • Validator V2
        • XML to JSON Transformer
        • XML Transformer
        • JSON Generator (Mock)
      • Web protocols
        • Email V2
        • Email V1 (Deprecated)
        • REST V2
        • REST V1 (Deprecated)
        • SOAP V1 (Deprecated)
        • SOAP V2
        • SOAP V3
        • WGet (Download HTTP)
        • gRPC
    • Triggers
      • Web Protocols
        • API Trigger
        • Email Trigger
        • Email Trigger V2
        • HTTP Trigger
        • HTTP File Trigger
          • HTTP File Trigger - Downloads
          • HTTP File Trigger - Uploads
        • REST Trigger
      • Scheduling
        • Scheduler Trigger
      • Messaging and Events
        • Event Trigger
        • JMS Trigger
        • Kafka Trigger
        • RabbitMQ Trigger
      • Others
        • DynamoDB Streams Trigger
        • HL7 Trigger
        • Salesforce Trigger - Events
    • Double Braces
      • How to reference data using Double Braces
      • Double Braces functions
        • Math functions
        • Utilities functions
        • Numerical functions
        • String functions
        • JSON functions
        • Date functions
        • Comparison functions
        • File functions
        • Conditional functions
      • Double Braces autocomplete
  • Development cycle
    • Build
      • Canvas
        • AI Assistant
        • Smart Connector User Experience
        • Execution panel
        • Design and Inspect Mode
        • Linter: Canvas building validation
        • Connector Mocking
      • Pipeline
        • How to create a pipeline
        • How to scaffold a pipeline using an OpenAPI specification
        • How to create a project
        • Pipeline version history
        • Pipeline versioning
        • Messages processing
        • Subpipelines
      • Capsules
        • How to use Capsules
          • How to create a Capsule collection
            • Capsule header dimensions
          • How to create a Capsule group
          • How to configure a Capsule
          • How to build a Capsule
          • How to test a Capsule
          • How to save a Capsule
          • How to publish a Capsule
          • How to change a Capsule collection or group
          • How to archive and restore a Capsule
        • Capsules versioning
        • Public capsules
          • SAP
          • Digibee Tools
          • Google Sheets
          • Gupy
          • Send notifications via email
          • Totvs Live
          • Canvas LMS
        • AI Assistant for Capsules Docs Generation
    • Run
      • Run concepts
        • Autoscalling
      • Deployment
        • Deploying a pipeline
        • How to redeploy a pipeline
        • How to promote pipelines across environments
        • How to check the pipeline deployment History
        • How to rollback to a previous deployment version
        • Using deployment history advanced functions
        • Pipeline deployment status
      • How warnings work on pipelines in Run
    • Monitor
      • Monitor Insights (Beta)
      • Completed executions
        • Pipeline execution logs download
      • Pipeline logs
      • Pipeline Metrics
        • Pipeline Metrics API
          • How to set up Digibee API metrics with Datadog
          • How to set up Digibee API metrics with Prometheus
        • Connector Latency
      • Alerts
        • How to create an alert
        • How to edit an alert
        • How to activate, deactivate or duplicate an alert
        • How to delete an alert
        • How to configure alerts on Slack
        • How to configure alerts on Telegram
        • How to configure alerts through a webhook
        • Available metrics
        • Best practices about alerts
        • Use cases for alerts
      • VPN connections monitoring
        • Alerts for VPN metrics
  • Connectivity management
    • Connectivity
    • Zero Trust Network Access (ZTNA)
      • Prerequisites for using ZTNA
      • How to view connections (Edge Routers)
      • How to view the Network Mappings associated with an Edge Router
      • How to add new ZTNA connections (Edge Routers)
      • How to delete connections (Edge Routers)
      • How to view routes (Network Mapping)
      • How to add new routes (Network Mapping)
      • How to add routes in batch for ZTNA
      • How to edit routes (Network Mapping)
      • How to delete routes (Network Mapping)
      • How to generate new keys (Edge Router)
      • How to change the environment of Edge routers
      • ZTNA Inverse Flow
      • ZTNA Groups
    • Virtual Private Network (VPN)
  • Platform administration
    • Administration
      • Audit
      • Access control
        • Users
        • Groups
        • Roles
          • List of permissions by service
          • Roles and responsibilities: Governance and key stakeholder identification
      • Identity provider integration
        • How to integrate an identity provider
        • Authentication rules
        • Integration of IdP groups with Digibee groups
          • How to create a group integration
          • How to test a group integration
          • How to enable group integrations
          • How to edit a group integration
          • How to delete a group integration
      • User authentication and authorization
        • How to activate and deactivate two-factor authentication
        • Login flow
      • Organization groups
    • Settings
      • Globals
        • How to create Globals
        • How to edit or delete Globals
        • How to use Globals
      • Accounts
        • Configuring each account type
        • Monitor changes to account settings in deployed pipelines
        • OAuth2 Architecture
          • Registration of new OAuth providers
      • Consumers (API Keys)
      • Relationship model
      • Multi-Instance
        • Deploying a multi-instance pipeline
      • Log Streaming
        • How to use Log Streaming with Datadog
    • Governance
      • Policies
        • Security
          • Internal API access policy
          • External API access policy
          • Sensitive fields policy
        • Transformation
          • Custom HTTP header
          • CORS HTTP header
        • Limit of Replicas policy
    • Licensing
      • Licensing models
        • Consumption Based model
      • Capacity and quotas
      • License consumption
    • Digibee APIs
      • How to create API credentials
  • Digibee concepts
    • Pipeline Engine
      • Digibee Integration Platform Pipeline Engine v2
      • Support Dynamic Accounts (Restricted Beta)
    • Digibee Integration Platform Dedicated SaaS
      • Digibee Integration Platform architecture on Dedicated Saas model
      • Requirements for Digibee Dedicated Saas model
      • Site-to-Site VPN for dedicated SaaS customer support
      • Dedicated Saas customer responsibilities
      • Custom Images of Kubernetes Nodes
      • Digibee Dedicated SaaS installation on AWS
        • How to install requirements before installing Digibee Integration Platform on EKS
        • Permissions to use Digibee Integration Platform on EKS
        • How to create custom nodes for EKS (Golden Images)
    • Introduction to ZTNA
  • Help & FAQ
    • Digibee Customer Support
    • Request documentation, suggest features, or send feedback
    • Beta Program
    • Security and compliance
    • About Digibee
Powered by GitBook
On this page
  • Amazon Aurora
  • Amazon Aurora MySQL
  • Amazon Aurora PostgreSQL
  • DB2
  • Apache Hive
  • Teradata Database
  • SQL Server
  • Oracle
  • MySQL
  • Maria DB
  • Progress
  • Sybase
  • PostgreSQL
  • OLAP DataSource via MDX
  • JTOpen for AS/400
  • SAP HANA
  • Firebird
  • DB Informix
  • Netsuite
  • Snowflake

Was this helpful?

  1. Digibee in action
  2. Troubleshooting
  3. Connectors behavior and configuration

Supported databases

Discover the types and versions of databases supported by the Digibee Integration Platform and how they can make integration pipeline creation easier for all users.

PreviousHow to resolve the "Invalid payload" error in API IntegrationNextFunctions and uses for databases

Last updated 3 months ago

Was this helpful?

You can access databases using specific components, such as:

The database support mentioned here doesn't apply to deprecated versions of components. We recommend that you don't use deprecated components. Some examples of deprecated components are:

The Digibee Integration Platform currently supports the following databases:

Amazon Aurora

The Digibee Integration Platform offers support for both Amazon Aurora engines.

Amazon Aurora MySQL

The Digibee Integration Platform offers support for the following versions:

  • 1, 2, and 3

Connection String

jdbc:mysql://<host>:<port>/<database>

Amazon Aurora PostgreSQL

The Digibee Integration Platform offers support for all versions.

Connection String

jdbc:postgresql://<host>:<port>/<database>

DB2

The Digibee Integration Platform offers support for the JDBC IBM DB2 driver and covers the following versions:

  • DB2 level version: 11.5

  • Driver version: 4.26.14

Connection String

jdbc:db2://127.0.0.1:1724/dbtest

This process is handled by the Digibee support team, but you must provide the JDBC IBM DB2 driver for activation. This process is exclusive to the requesting customer's realm.

Apache Hive

The Digibee Integration Platform offers support for Apache Hive via JDBC Connector 2.6.17 for Cloudera Enterprise only and covers the following versions:

  • Apache Hive versions 1.0.0 to 3.1

Connection string

 jdbc:hive2://localhost:10002

This process is handled by the Digibee support team, but you must provide the Cloudera JDBC driver for activation. This process is exclusive to the requesting customer's realm.

Teradata Database

The Digibee Integration Platform offers support for the following versions:

  • Teradata Database 16.10, 16.20, 17.00, 17.10 and 17.20.

Connection String

jdbc:teradata://192.168.64.2/DATABASE=DBC,DBS_PORT=1025

Your company's driver licensed by Teradata must be activated to connect across supported database versions. This process is handled by the Digibee support team, but you must provide the Teradata JDBC driver for activation. This process is exclusive to the requesting customer's realm.

SQL Server

The Digibee Integration Platform offers support for the following versions:

  • Microsoft SQL Server 2019

  • Microsoft SQL Server 2017

  • Microsoft SQL Server 2016

  • Microsoft SQL Server 2014

  • Microsoft SQL Server 2012

  • Microsoft SQL Server 2008 R2

  • Azure SQL Database

  • Azure SQL Data Warehouse or Parallel Data Warehouse

  • Azure SQL Managed Instance (Extended Private Preview)

Connection via Microsoft SQL 2019 version is supported, but some features of this version may not be available.

Connection String

jdbc:sqlserver://[serverName[\instanceName][:portNumber]]

Oracle

The Digibee Integration Platform offers support for the following versions:

  • 19.x

  • 18.3

  • 12.2 or 12cR2

  • 12.1 or 12cR1

  • 11.2 or 11gR2

Connection Strings

  • Oracle Net Syntax

jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=5221))
(ADDRESS=(PROTOCOL=TCP)(HOST=host2)(PORT=5221)))
(CONNECT_DATA=(SERVICE_NAME=orcl)))

In the Oracle database, the connection string can contain multiple endpoints. If your connection string contains more than one endpoint, the Oracle driver will attempt to connect to each endpoint until it's successful or there is no other endpoint.

  • Syntax with Service Name

jdbc:oracle:thin:@//localhost:5221/orcl

Only thin-type connections are supported. By accessing the databases specified in this connection string, you confirm that you have the required Oracle licenses.

MySQL

The Digibee Integration Platform offers support for the following versions:

  • 5.6

  • 5.7

  • 8.0

Connection String

jdbc:mysql://<host>:<port>/<database>

Digibee Integration Platform deactivates MySQL driver’s interpretation of Maria DB strings. However, you can use Maria DB’s drive to connect to older versions of MySQL.

Maria DB

The Digibee Integration Platform offers support for the following version:

  • 5.5.3+

Connection String

jdbc:mariadb://<host>:<port>/<database>

Digibee Integration Platform deactivates MySQL driver’s interpretation of Maria DB strings.

Progress

The Digibee Integration Platform offers support for the following version:

  • OpenEdge 10.1.x+

Connection String

jdbc:datadirect:openedge://hostname:port

Sybase

The Digibee Integration Platform offers support for the following version:

  • SAP/Sybase ASE

Connection String

jdbc:sybase:Tds:host:port

PostgreSQL

The Digibee Integration Platform offers support for all versions.

Connection String

jdbc:postgresql://host:port/database

OLAP DataSource via MDX

The Digibee Integration Platform offers support for the following versions:

  • Hyperion Essbase 7

  • Microsoft Analysis Services 2005

  • Mondrian (no version information)

  • SAP BW 3.0a+

Connection Strings

  • MS SQL Server

jdbc:jdbc4olap:http://<server>:<port>/OLAP/msmdpump.dll
  • Mondrian

jdbc:jdbc4olap:http://<server>:<port>/mondrian/xmla
  • SAP BW

jdbc:jdbc4olap:http://<server>:<port>/sap/bw/soap/xmla?sap-client=number

This type of connection uses the XML for Analysis (XMLA) standard, which must be enabled in the OLAP server to be accessed.

JTOpen for AS/400

No compatibility information

Connection String

jdbc:as400://<server>[:port];prompt=false

SAP HANA

No compatibility information

Connection String

jdbc:sap://<server>:<port>

Firebird

The Digibee Integration Platform offers support for the following versions:

  • 2.5+

Connection String

jdbc:firebirdsql://<HOST>:<PORT>/C:\PATH_TO_DATABASE/DATABASE_FILE.FDB

DB Informix

No compatibility information

By accessing the databases specified in this connection string, you confirm that you have the required IBM licenses.

Connection String

jdbc:informix-sqli://<HOST>:<PORT>/<DATABASE>:informixserver=<INFORMIX_SERVER>

Netsuite

No compatibility information

By accessing the databases specified in this connection string, you confirm that you have the required Netsuite licenses.

This database driver supports only the SELECT operation.

Connection String

jdbc:ns://{Server Host}:{Server Port};ServerDataSource={Server Data Source};encrypted=1;Ciphersuites={Cipher Suite};CustomProperties=(AccountID={Account Id};RoleID={Role Id})

Snowflake

By accessing the databases specified in this connection string, you confirm that you have the required Snowflake licenses.

The Digibee Integration Platform offers support for the following versions:

  • 3.51.x +

Connection Strings

  • Syntax

jdbc:snowflake://<account_name>.snowflakecomputing.com/?<connection_params>
  • Example

jdbc:snowflake://wxyz.us-central1.gcp.snowflakecomputing.com/?db=snowflake_sample_data&sfSchema=TPCH_SF100
  • When batch mode is used and an error occurs, the Snowflake driver doesn't return the number of successful transactions or the number of errors. Only the first SQL execution error is returned and the entire transaction is rolled back, even if the "rollbackOnError" option is deactivated.

  • Snowflake doesn't support OUT and INOUT parameters. If you try to use these parameters, Snowflake returns a SQLFeatureNotSupportedException error.

  • When the batch mode is used, the BINARY and VARBINARY fields aren't supported.

The available features are based on . Your company's driver licensed by IBM must be activated to connect across supported database versions.

The available features are based on . Your company's driver licensed by Cloudera must be activated to connect across supported database versions.

So if your connection string contains multiple endpoints and you set the "oracle.net.connect_timeout" parameter in the Custom Connection Properties for components such as , , and , it's important to know that the timeout applies to each specified endpoint individually. It doesn't apply to all endpoints at the same time.

The Database Access port (standard 8471) must be mapped according to the . We also recommend specify the parameter prompt=false to prevent the driver from requesting credentials. These credentials are provided automatically.

Read to know more about configuring connection string parameters.

We are currently using the legacy version 3.10.3 of the JDBC driver due to a limitation in more recent versions: it's not possible to work with micro service by allocating a 64MB memory (this configuration refers to a small pipeline in the Digibee Integration Platform). Visit for further information.

Snowflake does not support CLOB or BLOB fields. For this reason, the "Blob as file" option doesn't work for the DB and Stream DB components. Read Snowflake's documentation about and for more information.

DB V2
Stream DB V3
Stored Procedure
Stream DB V1
DB V1
the official documentation of DB2
the official documentation of JDBC Cloudera driver
DB V2
Stream DB V3
Stored Procedure
IBM documentation
Snowflake's documentation
Snowflake’s change log documentation
unsupported data types
binary input and output