n8n-nodes-cdata-connect-cloud

This is an n8n community node that allows you to integrate with CData Connect Cloud API in your n8n workflows.

Features

- Query Execution: Execute SQL queries against your connected data sources
- Metadata Retrieval: Get information about catalogs, schemas, tables, columns, and procedures
- Batch Operations: Execute multiple operations in a single request
- Stored Procedures: Execute stored procedures with parameters
- Workspace Support: Query specific workspaces
- Parameter Support: Use parameterized queries for security and flexibility

Installation

To install this node in your n8n instance:

$3

1. Go to Settings > Community Nodes in your n8n instance
2. Click "Install a community node"
3. Enter n8n-nodes-cdata-connect-cloud
4. Click Install

$3

1. Navigate to your n8n installation directory
2. Run: npm install n8n-nodes-cdata-connect-cloud
3. Restart n8n

Configuration

$3

1. In n8n, create new credentials of type "CData Connect Cloud API"
2. Fill in the required fields:
- Username: Your CData Connect Cloud email address
- Personal Access Token: Generate a PAT from your CData Connect Cloud Settings page
- Base URL: https://cloud.cdata.com/api (default)

$3

#### Query Operations
- SQL Query: Enter your SQL statement
- Default Schema: Optional default schema
- Schema Only: Return only schema without data
- Workspace: Optional workspace name
- Parameters: Add query parameters with proper data types

#### Metadata Operations
- Get Catalogs: Retrieve available data source catalogs
- Get Schemas: Retrieve schemas for a catalog
- Get Tables: Retrieve tables for a schema
- Get Columns: Retrieve columns for a table
- Get Procedures: Retrieve stored procedures

#### Batch Operations
- Batch Operations: JSON array of operations to execute

#### Execute Operations
- Procedure Name: Name of the stored procedure
- Parameters: Procedure parameters with data types

Usage Examples

$3

``sql
SELECT * FROM Salesforce1.Salesforce.Account LIMIT 10
`

$3

`sql
SELECT * FROM Salesforce1.Salesforce.Account WHERE Name = @accountName
`
With parameter:
- Name: @accountName
- Data Type: VARCHAR
- Value: Acme Corp

$3

`json
[
{"query": "INSERT INTO MyTable (id, name) VALUES (1, 'Test')"},
{"query": "UPDATE MyTable SET name = 'Updated' WHERE id = 1"}
]
`

API Reference

This node implements the CData Connect Cloud REST API endpoints:

- POST /api/query - Execute SQL queries
- GET /api/metadata/* - Retrieve metadata
- POST /api/batch - Batch operations
- POST /api/exec` - Execute stored procedures

For detailed API documentation, visit: https://cloud.cdata.com/docs/REST-API.html

Data Types

The node supports the following CData Connect Cloud data types:

| Value | Type | Description |
|-------|------|-------------|
| 5 | VARCHAR | String values |
| 8 | INTEGER | Integer numbers |
| 9 | BIGINT | Large integers |
| 11 | DOUBLE | Floating point numbers |
| 12 | DECIMAL | Decimal numbers |
| 14 | BOOLEAN | True/false values |
| 15 | DATE | Date values |
| 17 | TIMESTAMP | Date and time values |

Error Handling

The node includes comprehensive error handling:
- API errors are caught and reported with detailed messages
- Invalid JSON in batch operations is validated
- Missing required parameters are validated
- Connection and authentication errors are handled gracefully

Support

For issues related to this n8n node:
- Create an issue on the GitHub repository
- Check the n8n community forum

For CData Connect Cloud API issues:
- Refer to the official CData documentation
- Contact CData support

License

MIT License - see LICENSE file for details

Contributing

Contributions are welcome! Please:
1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Add tests if applicable
5. Submit a pull request

Changelog

$3

- Initial release
- Support for all major CData Connect Cloud API endpoints
- Complete parameter and workspace support
- Comprehensive error handling
- Full TypeScript implementation