SAP CX & SQL Server & Docker on Ubuntu 18.04

In this article, I am going to show you how to set up SAP CX with a Docker instance of SQL Server in Ubuntu 18.04

Step 1 : Install docker

Recently, I switched to Ubuntu 18.04 from Windows 10 because it’s pretty much easy to handle all DevOps stack ( see a long discussion here).

so to install docker it’s so easy, just run the following commands :

sudo add-apt-repository "deb [arch=amd64] https://download.docker.com/linux/ubuntu bionic stable"
sudo apt update
sudo apt install docker-ce -y

tape “sudo docker version” to check that everything is well !

Step 2: Install Microsoft SQL Server

All that you need to achieve this is to run the following command :

sudo docker run --name 'mssql_sapcx' -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=sapCxStrongP@ssword' -p 1433:1433 -d microsoft/mssql-server-linux:2017-latest

Check that your image is running by taping

sudo docker ps

   I recommend to use the mssql-server-linux:2017-latest image, I am using it in my daily work and it’s stable and working!

Step 3: configure SAP CX to use the new docker instance

set the following properties under ${Hybris_home}/config/local.properties

db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
db.url=jdbc:sqlserver://localhost:1433;databaseName=my_sap_project
db.username=sa
db.password=sapCxStrongP@ssword

 Step 4: start the SAP CX server and enjoy your life !