Edo.Connect – Streamlining import of data to Cognos Controller using a web based user interface.
During my first weeks at Addedo there were lots of things to absorb. One such thing included a Web interface for importing data, automating the importing of data, control over the data to be imported, monitoring status of imports, different source systems used for importing data and flexibility to change destination Cognos Controller database. To summarize it was Edo.Connect, Kelly Madill, Consultant at Addedo says.
What is Edo.Connect?
Edo.Connect is a web application built on top of Cognos Controller allowing the import of data into Cognos Controller from a data warehouse, ERP or another custom database.
Edo.Connect enables one or more data sources to be read, and data imported to Cognos Controller.
Requires no additional hardware or software installation.
Users retain control regarding the data imported, whilst the data import is automatic.
Edo.Connect is an uncomplicated interface with the possibility to
(i) define parameters such as period and companies to be imported, and start the import
(ii) view status of recent imports
(iii) review data of current and recent imports
(iv) switch between Cognos Controller databases
Windows Authentication is used for security by Edo.Connect, meaning a users’ security groups defined in Cognos Controller will be applied for the user when logged in to Edo.Connect.
Requires no additional maintenance, maintenance of Cognos Controller updates Edo.Connect.
What should be considered when implementing Edo.Connect?
- What and where are the source systems?
- What information regarding Cognos Controller exists in the source systems and what data does not exist?
- Are they local or in the cloud?
- How are the source systems hosted in relation to Cognos Controller?
- Mappings and transformation of source data to be valid for Cognos Controller.
How can you learn more?
If you are interested in finding out more, there is a breakfast seminar at Addedo in Stockholm on the 14th June 2018 from 8:30-9:30. Read more here http://bit.ly/2rtO65n