Skip to content
Infoveave Help

Database Connections

Database Connections helps you effectively manage and configure your database connections within Infoveave Control Center. This ensures that your data retrieval and analysis processes are optimized and aligned with your requirements. New Database Connection

  1. To establish a new database connection, click on New.
  2. 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.
  3. To add the Database Connection, click Save.
  4. To edit any Database connection, select the required Database connection and click on Edit icon.
  5. To delete any Database connection, select the required Database connection and click on Delete icon.
  6. To view any Database connection, select the required Database connection and click on View icon.
  7. To define the default database connection for your Datasource creation select Database Connection in Use, from the available list of database connections.
  8. To clear cache, select the Datasource from the drop-down list whose cache you want to delete. After selecting the Datasource, click on to delete all cache memory.
    • To clear cache action will clear the cached values in the Datasource through frequently executed queries.
  9. To remove workflow instances created before a particular date, you can set a date as a reference point in the option Delete Workflow Instances Before a Specific Date. Infoveave Database Connections
  10. Click Delete to remove all workflow instances (Workflow Execution Status) before the selected date.