Drop all tables in a given schema

sometimes you come into a situation where you have to drop all tables in a given schema. The easiest way is to delete the user and recreate him again but when lacking system privileges you will look for another way. I’ll find the following very handy and will delete all specified db objects…. BEGIN  FOR…

SAP HANA Express on CentOS 8

For Development and Testing purposes (Integrating SAP BO 4.3)  it was needed to install SAP HANA Express v2. SAP offers VMWARE images, but i’m using Hyper-V for all VM’s on my development system. So we had to install manually…. But why made the change when SAP is offering a free VMWARE image? Playing together? Why…

SAP BO Client Implementation

On of our customers has the requirement to migrate the actual OnPrem SAP BO 4.2 SP5 into a Cloud infrastructure (Government BIT Cloud). Furthermore one of the requirements is implementing a new SAP BO 4.2 SP 8. As prerequsite Oracle 19c client (64 Bit) and Teradata Client Tools have to be installed prior the implementation…

Oracle 19c client installation

On of our customers has the requirement to migrate the actual OnPrem versionof SAP BO 4.2 SP5 into a Cloud infrastructure (Government BIT Cloud). Furthermore one of the requirements is implementing a new SAP BO 4.2 SP 8 and using Oracle Exdata 19c as repositories for SAP BO CMS and auditing. In the following will…

SAP BO Implementation

One of our customers has the requirement to migrate the actual OnPrem SAP BO 4.2 SP5 into a Cloud infrastructure (Government BIT Cloud). Furthermore one of the requirements is implementing a new SAP BO 4.2 SP 8. As prerequsite Oracle 19c client (64 Bit) has to be installed prior the implementation of SAP BO. The…

Teradata Studio Express

On of our customers has the requirement to migrate the actual OnPrem into a Cloud infrastructure (Government BIT Cloud). Furthermore one of the requirements is implementing a new SAP BO 4.2 SP 8 and using Terdata (https://www.teradata.com/) as DWH. In the following we will describe how to install the needed Teradata client tools. The have…

Teradata Tools and utilities

On of our customers has the requirement to migrate the actual OnPrem into a Cloud infrastructure (Government BIT Cloud). Furthermore one of the requirements is implementing a new SAP BO 4.2 SP 8 and using Terdata (https://www.teradata.com/) as DWH . In the following we will describe how to install the needed Teradata client tools. They…

SAP BO Restful Web Services

SAP Business Objects 4.3 (https://www.sapanalytics.cloud/businessobjects-a-new-user-experience/) comes with a modified version of BI Launchpad for FIORI. In a Cloud based environment you have to deal with internal and external addresses. But SAP BO is installing by default on the local addresses (private cloud infastructure). In this environment it is not advised to install WACS (Web Application…

SAP BO Logos and Images

Es gibt zwei Wege wie man dynamische Logos in Webi Reports anziehen kann. BOIMG: Diese Variante kann die Logos/Images aus dem Verzeichnis …./images des BO Servers oder dem Wert vom WebiProcessingServers verwenden. Da wir dies für Fachbereiche reservieren, ist für Kanton Logos etc. ein anderer Weg zu bevorzugen. Weitere Variante ist, die Logos oder Images…

Ubiquiti UniFi Dream Machine routing to Azure VPN

For a number of years now Ubiquiti Networks has sold networking products for homelabbers, prosumers, and businesses in its UniFi line. In the midst of many businesses moving to the cloud, needing a direct and encrypted connection directly from their on-premise datacenter or back/home-office to the cloud is a very common use-case. Microsoft Azure has…