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 !