Roles
Users
Address Book
Holiday Calendar
Audit Logs
Custom Calendar
Control Center
Data GovernanceConnections in Infoveave allow you to establish links to various services and databases, enabling seamless data communication and workflow automation. Each connection type serves a specific purpose and can be utilized for various workflow tasks, enhancing the flexibility and functionality of Infoveave for data management and automation.
Table of Contents
1. Overview
Connections in Infoveave allow you to establish links to various services and databases, enabling seamless data communication and workflow automation. Each connection type serves a specific purpose and can be utilized for various workflow tasks, enhancing the flexibility and functionality of Infoveave for data management and automation.
Here is a summary of the available connection types:
Cloud Services: Includes API connections for communicating data between different software systems or applications.
Database Connections: Enable users to connect to a variety of databases such as Amazon Redshift, ClickHouse, Databricks, MariaDB, Microsoft SQL, MySQL, Oracle, Percona, Postgres, and SQLite.
Email Connections: Allow for retrieving emails from a server or sending emails through an email server.
Execute Connections: Includes connections like SSIS ETL for connecting to different SQL Server Integration Services.
File Transfer Connections: Enables you to connect to cloud storage services such as AWS S3 and Azure, as well as servers using FTP/SFTP for file transfer operations.
2. Steps to Create and Setup Connections
- To establish a new Connection in Infoveave, click on Administration Connections.
- All Connections, those created by you or shared with you will be displayed under the tabs My Connections and Shared Connections respectively.
- To establish a new database connection, click on New Connections.
- You will be redirected to the connections page to select the connection type.
- Select the required connection type form the list of available options.
- Provide the following information:
- Name: Assign a descriptive name to this database connection for easy identification.
- Database Type: Choose the appropriate database type from the available options. The database type determines how Infoveave communicates and interacts with the database engine. Select from options such as Microsoft SQL, Amazon Redshift, ClickHouse, MariaDB, MySQL, Oracle, Percona, or Postgres.
- User Name: Enter the username associated with the chosen database. This is the credential Infoveave will use to authenticate and access the database. Make sure the username is correct and has the necessary permissions to interact with the database.
- Server: Provide the server address or hostname where the database is located. This could be an IP address or a domain name. Ensure that you accurately input the server information to establish a successful connection.
- Password: Input the corresponding password for the provided username. The password is a crucial security element, so ensure that you input it correctly. Consider using strong, unique passwords for your database connections.
- Port: Specify the port number for the database connection. Each database type often has a default port assigned to it. However, you can customize this port as needed, based on your database configuration.
- To validate the Connection, click Validate.
- Click Save to save the connection created.
