Test connection on remote engines
Test connection is a diagnostic feature that validates the configuration and connectivity between your remote engine and a data source using the provided credentials and connection parameters. When you use a remote engine, you can test connections for most DataStage connectors directly from your remote engine deployment. Remote engine support for test connection allows you to validate connection parameters from your on-premises environment. This capability is essential when your database hosts are accessible only within your local network.
Why test connections
Testing connections helps you:
- Verify that connection parameters are correct before running jobs
- Identify configuration issues early in the setup process
- Validate that credentials have the necessary permissions
- Reduce troubleshooting time by catching errors before job execution
How test connection works
When you initiate a test connection, the remote engine:
- Establishes a network connection to the data source using the specified host and port
- Authenticates using the provided credentials
- Executes a simple query or command to verify access
- Returns a success or failure message with diagnostic information
Connectors that support test connection
The following connectors support test connection on remote engine.
| Connector name | Connector ID |
|---|---|
| Amazon Aurora for MySQL | mysql-aurora |
| Amazon Aurora for PostgreSQL | postgresql-aurora |
| Amazon RDS for MySQL | mysql-amazon |
| Amazon RDS for Oracle | oracle-amazon |
| Amazon RDS for PostgreSQL | postgresql-amazon |
| Amazon Redshift | RedshiftPX |
| Amazon S3 | AmazonS3PX |
| Apache Derby | derby |
| Apache HDFS | hdfs-apache |
| Apache Hive | HiveConnectorPX |
| Apache Impala | impala |
| Apache Kafka | KafkaConnectorPX |
| AWS Databricks | databricks-aws |
| Box | box |
| ClickHouse | clickhouse |
| DataStax Enterprise | datastax |
| Dremio | dremio |
| Dropbox | dropbox |
| Elasticsearch | elasticsearch |
| FTP | ftp |
| Generic S3 | generics3 |
| Google BigQuery | bigqueryPX |
| Google Cloud Pub/Sub | GooglePubSubPX |
| Google Cloud Storage | GoogleCloudStoragePX |
| Google Looker | looker |
| Greenplum | greenplum |
| HTTP | http |
| IBM Cloud® Databases for MongoDB | mongodb-ibmcloud |
| IBM Cloud Databases for MySQL | mysql-compose |
| IBM Cloud Databases for PostgreSQL | postgresql-ibmcloud |
| IBM Cloud Data Engine | sqlquery |
| IBM Cloud Object Storage | cloudobjectstoragePX |
| IBM Cognos Analytics | cognos-analytics |
| IBM Data Virtualization | dv |
| IBM® Data Virtualization Manager for z/OS® | dvm |
| IBM Db2® | db2 |
| IBM Db2 Big SQL | bigsql |
| IBM Db2 for DataStage | DB2ConnectorPX |
| IBM Db2 for i | db2iseries |
| IBM Db2 for z/OS | db2zos |
| IBM Db2 on Cloud | db2cloud |
| IBM Db2 Warehouse | dashdb |
| IBM Informix® | informix |
| IBM Master Data Management | match360 |
| IBM MQ | WebSphereMQConnectorPX |
| IBM Netezza® Performance Server | netezza |
| IBM Netezza Performance Server for DataStage | NetezzaConnectorPX |
| IBM Planning Analytics | tm1odata |
| IBM watsonx.data Presto | lakehouse |
| MariaDB | mariadb |
| Microsoft Azure Blob Storage | azureblobstorage |
| Microsoft Azure Cosmos DB | cosmos |
| Microsoft Azure Databricks | databricks |
| Microsoft Azure Data Lake Storage | AzureDatalakePX, AzureDatalakeStorageMetaPX |
| Microsoft Azure Fabric Warehouse | fabricwarehouse |
| Microsoft Azure File Storage | azurefilestorage, AzureStorageConnectorPX |
| Microsoft Azure SQL Database | azuresql |
| Microsoft OneDrive | onedrive |
| Microsoft SharePoint | sharepoint |
| Microsoft SharePoint Files | sharepoint-file |
| Microsoft SQL Server | sqlserver |
| Microsoft Azure Synapse Analytics | azuresynapse |
| MongoDB | mongodb |
| MySQL | mysql |
| ODBC | ODBCConnectorPX |
| OpenSearch IBM Cloud | opensearch-ibmcloud |
| Oracle | oracle |
| Oracle Database for DataStage | OracleConnectorPX |
| PostgreSQL | postgresql |
| Presto | presto |
| Salesforce API for DataStage | SALESFORCEJCConnectorPX |
| Salesforce.com | salesforce |
| SAP ASE | sybase |
| SAP IQ | sybaseiq |
| SAP OData | sapodata |
| SingleStoreDB | singlestore |
| Snowflake | SnowflakeConnectorPX |
| Tableau | tableau |
| Teradata | teradata |
| Teradata database for DataStage | TeradataConnectorPX |
| Trino | trino |