Skip to content
Iristrace Helpdesk
  • First steps
  • Checklists
  • Templates
  • Workflows
  • Users
  • Departments
  • Reports
  • Notifications
  • Data download
  • Dashboard
  • Recommendations for use
  • Integrations & BI
  • Glossary
Popular Search como

First steps

  • Add Additional Company Contact Fields
  • Accessing Iristrace’s web/desktop platform
  • Accessing Iristrace on mobile
  • Customizing Iristrace with your corporate image or logo
  • Customize your Iristrace environment
  • Changing the language of your account in Iristrace
  • Iristrace Menu Interface
  • Creating and answering a checklist in the web version of Iristrace

Checklists

  • How to View Checklists in the Kanban View
  • Creating and answering a checklist in the web version of Iristrace
  • How to answer a checklist from the Iristrace mobile app
  • How to create and answer a checklist from the web version of Iristrace
  • What additional options are available to the user when answering a checklist?
  • How to answer a checklist without connectivity (offline mode)
  • How to browse checklists in web version
  • How to filter the list of checklists in the web version
  • How to create an action plan in a checklist
  • How to set up a dynamic title per checklist
  • How to mass import checklists into Iristrace
  • How to manage incidents recorded in Iristrace
  • How to download an Excel file of incidents
  • Create and download checklist reports
  • How to assign a checklist to a user
  • How to change the department of a checklists

Templates

  • How to configure the visibility of a category of questions in a checklist based on its status
  • Archive Templates
  • How to create templates in Iristrace
  • What types of questions can be configured
  • What additional options can be configured in questions Excerpt
  • How to create default responses and reuse response structures
  • How to configure default responses
  • How to create statuses and status groups
  • How to create templates for action plans
  • How to examine the metadata in your templates
  • What are the additional functionalities of the templates?
  • How to customize a template
  • How to set basic scoring in templates
  • How to set up conditional questions
  • How to set up an advanced scorecard
  • How to Create a Random Question Template
  • How to set score thresholds for multiple choice questions

Workflows

  • How to create a Workflow to send notifications by email
  • How to create a Workflow to create checklists

Users

  • Checklist Access Control: Restrict Checklist Visibility by User and Template
  • “View Users” Permission
  • How to create a user
  • Managing Custom Permissions
  • How to mass customize user permissions

Departments

  • How to create a department
  • What are departments in Iristrace
  • How to create subdivisions
  • How to assign users to departments
  • How to customize the title “Departments”.

Reports

  • Exporting a report in Word format
  • How to customize PDF reports

Notifications

  • Creating a Notification Based on an Automatic Event
  • How to Generate a Notification According to a Time Periodicity
  • How to set up an automatic instant message (notifications)
  • How to download the requested reports

Data download

  • How to download an Excel file of incidents

Dashboard

  • How to create a dashboard

Recommendations for use

  • How to solve the most common web application stability issues
  • How to solve the most common problems with Iristrace access
  • How to resolve text mismatches in the calendar

Integrations & BI

  • Intermediate Database Iristrace
  • Data model
  • Connecting MariaDB with Microsoft Power BI
  • Conectar MariaDB con JDBC
  • ODBC data source
  • Connecting MariaDB with Google Looker Studio
  • Direct connection to MySQL Workbench
  • Connecting MariaDB to SAP Datasphere
  • Connection between MariaDB and Tableau
  • Connecting from Azure Synapse via local connection
View Categories
  • Home
  • Iristrace Help Desk
  • Integrations & BI
  • Direct connection to MySQL Workbench

Direct connection to MySQL Workbench

MySQL Workbench is a powerful tool for the administration and design of MySQL databases. It is a visual and user-friendly application that allows you to design, model, create and manage MySQL databases effectively.

1. Connection to Intermediate Database #

Once MySQL Workbench is installed you will see on the main screen of the application the ‘+’ icon to add a new connection.

A new window will appear where you will have to enter the data previously provided in the email.

Remember in the SSL tab to have SSL encryption enabled, otherwise the connection to the database will fail.

Once the data has been entered, click on Ok and the connection will be added to the main screen and to access the editor simply click on it. If you get some kind of connection error you can try using the command “telnet XXXX.iristrace.com 3xxxx” to verify that you reach our server.

BI, integrations, intermediate database
Was this helpful ?
Do you still need help?

How can we help?

Updated on September 25, 2023
Connecting MariaDB with Google Looker StudioConnecting MariaDB to SAP Datasphere

Powered by BetterDocs

Table of Contents
  • 1. Connection to Intermediate Database
  • English
    • EspaƱol
    • Deutsch
  • English
  • Spanish
  • German