Connectors
Connectors in ViewZen Analytics establish links between the platform and external data sources. They store connection details like name, type, and configuration settings, enabling seamless data access
⚙️ Connector Actions
🆕 Create a New Connector
You can create a connector to any supported data source such as PostgreSQL, MySQL, SQL Server, CSV, MongoDB, Google Sheets, Oracle E-Business Suite, SAP, and others.
Steps to Create a Connector:
Enter connector details — name, short name, and description.
Select the connector type from the list of supported data sources.
Configure the connection with required credentials and settings.
Choose the data you want to access.
[TIP] Choose descriptive names (e.g.,
Sales_DB_Prod) to easily identify your connectors later.
🧪 Test a Connector
You can test a connector during creation or editing to verify that it connects successfully before using it in pipelines or dashboards.
Common reasons for connection test failures:
🔑 Invalid credentials
Username, password, or token is incorrect.
🚫 Insufficient permissions
The database user lacks access rights.
📴 Server offline
The database or service is down or unreachable.
🔒 Network restrictions
Firewall or VPN blocking access.
🌐 Host unreachable
The source system or hostname cannot be resolved.
🗝️ SSH configuration error
SSH tunneling details are incorrect — invalid SSH host, username, private key, or tunnel port.
🔁 Use a Connector
Once a connector is created successfully, it can be reused across multiple pipelines and assets.
Usage Highlights:
Bring data into pipelines for processing and transformation.
Enable live access to external data — no manual reloads needed.
Maintain consistent, secure, and reusable connections across different workflows.
[TIP] Use connectors to centralize data access and avoid repetitive configuration across projects.
🗑️ Delete a Connector
You can delete an existing connector from the Connectors page.
[NOTE] Only connectors not actively used by any pipeline or asset can be deleted. If dependencies exist, remove them first before deletion.
📘 Connector Catalog
The Connector Catalog provides a complete view of the connector and it's associated assets.
It displays details such as:
Associated users groups
Linked pipelines
Connected live datasets
Relevant properties and configurations
Benefits:
See dependency relationships at a glance.
Manage and track connector usage.
Ensure data availability across workflows.
Last updated