Template Type: Non-Graphical

Data Source Connection

The DataSourceConnection template is used to connect to a data source, and can be used to e.g. reverse engineer a database.

The main tab on the template specifies the connection to the database.

The most important thing to understand about setting up the database connections is the connecting string. Details about connection string formats can be found here:

https://www.connectionstrings.com/

Connection Type

  • Driver => The connection string is complete inside the DataSourceConnector
  • DataSource => The connection data is installed in a QDBC Driver
  • Addons => Uses the data connections available in QIS/RA under Addons

Driver

The installed driver must be selected and the connection string should be given in the “Complement” field.

The credentials can be added in the Security Information or added in the Complement field.

Note that login credentials written in the Complement field will be readable for all users.

It is possible to test the Connection on the Catalog tab.

DataSource

A prerequisite is that the ODBC driver has been created with e.g. the ODBC Administrator tool available at the server.

It MUST be a 64-bit driver as the QIS Server is 64-bit. The QLM is 32-bit, and because of this the 64 bit must entered manual. The dropdown simply will not show the 64-bit, only 32 bit.

Select the relevant provider and credentials as well in terms of “Complement”.

Addons

The addons refer to the databases set up under addons in this specific installation under the QIS/ Repository Adminstrator.

Catalog

On the Catalog tag, you should select the QISServer_Diver.

Test Connection

In the Test Connection it is possible to test if the connection works. If it works, a list of available Catalogs will be displayed.

In case of error, please look at the Message window. There will the error code be available. This will help finding the problem and to fix the problem.

Video

The DataSourceConnection can together with the DataModellingStructure be used to reverse engineering of databases.

Reverse engineering of SQL Server database

Data Processing Agreement

This template can be used to document Data Processing Agreements.

The DPAs can be enriched and described with a whole set of properties and relations.

Course Participation

This template is used to document a persons participation to a course, and associate related content to the course (diploma)

Contract

The contract template is used to describe and capture relevant meta data about relevant contracts.

The main tab contains data about the contractual period, and the external part.

In addition a set of sub-tabs are available.

Responsibilities

Detail the relevant organisations entities (positions, persons, organizationunits, ..) that are related to the contract from a RASCI point of view.

Parties

Parties contain standard fields to link to external and internal parties associated to the contract.

Cost

Extension

As any other objects contracts can be associated to a GovernanceWorkflow, there is a standard workflow available for Contracts that can be imported and enabled.

In QualiWare 10.10 there is a standard desktop dedicated to Contract Management.

Complaint

This template can be used to describe complaints, e.g. from customers or other external parties.

There is a standard Governance Workflow for Complaint management.

Competence Level

CompentenceLevel are used to capture different levels of a competence and the level is given to a person, and can be approved by a competence approver.

A competence level can be managed in a governance workflow. There is a standard competence level management governance workflow a part of the person management flow.

Comment

This template is used to capture and describe comments to other objects.

It is part of the standard GovernanceWorkflow for change mangement, where it is possible to add comments to content as part of the review governance flow.

 

Check Result

Description of this template will be available soon.