TenneT is looking replacement of current ETL tool for a Data Warehouse Automation (DWA) tool, with the capability of handmade objects and features. The DWA solution should integrate the data warehouse to a big data store/data lake and scaling up to more source systems. TenneT focuses on the on-premise DWA tool and requests limited support at implementation and configuration of the tool as TenneT intends to do much itself; third line support and software maintenance is important. Important for the desired outcome: the DWA-tool must run on-premise due to data security policies and therefore no cloud solution is allowed; completely function on-premise at TenneT's location Arnhem; onsite third line support; use files, RDBMS-ses, web services and streams as a data-source; generate, deploy and load towards an Oracle database (and other RDBMS-ses)/Inmon 3NF/Kimball; can handle SAP S/4Hana as a source; multiple types of extraction techniques.
Goal of this tender is to contract a Data Warehouse Automation tool including licenses, software maintenance and third line support. Also some assistance in installation, configuration, advise on complex matters and training is contracted.