HDI

 What have been learned!

Overview:

Creating a new Datawarehouse database using the combined data at HanRe. 

This will be produced as an Oracle PDB database, based on an existing CDB. 

After this it will be copied to HDI using an Azure Blob container, as no direct connection is allowed due to firewall rules. 

Providing enough diskspace 7 Tb was allocated, a separate Oracle CDB and PDB will be created at HDI, which then will form the database which is to be copied over to T-Systems via a database link using the private VPN, where the final PDB will be created for Dev, Test and Production systems.

1. Findings after initial run
1. Conception
1. Database setup should have been started as initial task!
2. Contacts -- initial setup/koncept/discussion should have been made!
3. No discussion of alternatives
1. PDB 
2. Azure Blob
1. Obstacles
1. Firewall as an obstacle
1. HanRe => HDI
2. HDI => T-Systems
3. Azure Blob: 
1. No real knowledge of this!
2. HDI
1. Datenbases
1. "Has to be" 
1. Encryption -- Port 2484 as opposed to 1521
2. Certificate issues -----
2. DMZ
1. Could have been a solution!
3. Contacts
1. Taskforce for DBA's 
3. T-Systems
1. rigid
1. only one way solution... 
2. Db-Link 
1. Only solution offered
4. HanRe
1. Datenbank: CDB ==> PDB
1. Based on existing CDB; therefore dependent problems(Licenses)
2. Characterset
1. UTF8 -- is AL32UTF8
3. Installed Options
1. "not based on empty CDB" => Issues both at HDI and T-Systems