IDL Konsis Connector 
This article explains how to set up the IDL Konsis Connector.
IDL Konsis connector enhances the integration and reporting capabilities for the consolidation and group reporting solutions of the IDL Konsis users. This connector aims to streamline data flow and improve the efficiency of financial consolidation and reporting processes.
Setup IDL Konsis Connector
The connector uses the Hybrid Data Pipeline (HDP) to connect to the IDL Konsis system.
For more information on how to set up HDP connections using Microsoft SQL Server, refer Setup Connections to On-Premises and Direct Data Sources, before you continue.
Note: Contact our technical support for any questions.
To setup an IDL Konsis connector:
Navigate to Connections and select Create Connection.
Select IDL Konsis from the Data Sources drop down.
-
Enter information in the following required fields:
Field
Description
Version
Select a version from the list. For example, Current
Name
Enter a name for the data source. You can refer to this name while creating business views.
JDBC URL
Specify JDBC URL to connect to IDL Konsis via HDP.
User name
Specify the HDP username .
Password
Specify the HDP password.
-
Click Save. The connection will be validated automatically before saving.
After the connection is saved, associated Business Views would be imported automatically.
Pre-built Content
Business Views |
Description |
|---|---|
Account-GL-S-KNS |
This is a view for Konsis' master data of all accounts in all chart of accounts.\nThe account decription is available in all languages that are recorded in Konsis |
AccountBalance-GL-S-KNS |
This is a view on all Konsis' account balances (b/s, p&L and statistical accounts) of all companies in all periods and data facts. |
Business Unit-GL-S-KNS |
This is a view on Konsis' master data of all existing Business Units. |
Chart of Accounts-GL-S-KNS |
This is a view on Konsis' master data of all chart of accounts. A chart of account is either related to one or more companies (in case of a local chart of accounts) or to one or more data facts (in case of a group chart of accounts) |
Closing Date Period-GL-S-KNS |
This is a view on Konsis’ master data of all closing date periods. The period description is available in all languages that are recorded in Konsis. |
Company-MF-S-KNS |
This is a view on Konsis’ master data of all existing companies regardless of an assignment to a group. |
Consolidation Posting GL-S-KNS |
Konsis’ report data of all consolidation postings of all groups and all companies in all periods and data facts. The figures are shown ytd. The consolidation posting’s description is only available in one single language. |
Consolidation Voucher GL-S-KNS |
This is a view on Konsis’ report data of all consolidation vouchers of all groups and all companies in all periods and data facts. The consolidation voucher’s description is only available in one single language. |
Controlling Balance GL-S-KNS |
This is a view on all Konsis' controlling balances (b/s, p&L and statistical accounts) of all companies in all periods and data facts. The figures are shown ytd. |
Development Transaction GL-S-KNS |
This is a view on Konsis’ report data of all development transactions except for fixed assets in all companies, in all periods and data facts. |
Fact-MD-S-KNS |
This is a view for Konsis' master data of all data facts. The fact’s description is available in all languages that are recorded in Konsis. |
Fixed Assets Transaction FA-S-KNS |
This is a view on Konsis’ report data of all fixed assets development transactions in all companies, in all periods and data facts. |
Ic Account Balance GL-S-KNS |
This is a view on all Konsis' account balances (b/s, p&L and statistical accounts) of all companies in all periods and data facts. |
Posting GL-S-KN |
This is a view on Konsis’ report data of all postings of all companies in all periods and data facts. The figures are shown ytd. The posting’s description is only available in one single language. |
Voucher GL-S-KNS |
This is a view on Konsis’s report data of all vouchers of all companies in all periods and data facts. The voucher’s description is only available in one single language. |