Setting up Mobile Foundation with Oracle database on IBM Cloud Private
Out of the box IBM Mobile Foundation - ICP PPA package supports the use of IBM DB2 server. This tutorial focuses on extending the Mobile Foundation deployed on IBM Cloud Private (ICP) to use a remote Oracle database for storing Mobile Foundation data.
Before proceeding with the tutorial, following assumptions are made:
- You have already set up IBM Cloud Private and loaded the IBM Mobile Foundation Passport Advantage Archive on ICP.
- Setup of Mobile Foundation database tables that are created manually on a remote Oracle database server (Download and refer to the db scripts for Oracle database for Mobile Foundation server).
- IBM Cloud Private CLI tooling is installed on the local computer (
Note: During the helm deploy for DB2 databases, the tables are created automatically. For Oracle, PostgreSQL, or MySQL you have to create the tables manually before deploying the helm chart.
Artifacts that needs to be customized
The docker image of Mobile Foundation server has certain artifacts that can be customized to enable the Oracle DB support. Following are the files within the docker image that needs to be modified in order to have the containers created with Oracle related artifacts and configs.
mfpfsqldb.xml- modified to support Oracle DB and related data sources.
- Include Oracle client JBDC driver.
Note: The above file names are to be kept same in order to customize the base docker image.
- From the ICP console Catalog, ensure that the
ibm-mfpf-*helm charts are loaded.
- Unzip the attachment (
mfp-icp-oracle.zip) to locate the
usr-mfpf-serverthat shows the directory structure and a sample
- Modify the
Dockerfilein such a way so as to use the image version correction on which the docker image has to be extended.
a.b.c.d is the image version which is available in the image registry.
- Follow the instructions in the blog for customizing the docker image and create the Mobile Foundation server pods.
- Once the docker image is extended with the above steps, the ICP console can be used to deploy the Helm chart for the Mobile Foundation server. Make sure the new image is supplied.
For customization or extending the docker image see how to customize the Mobile Foundation component deployed on IBM Cloud Private (ICP).
Note: For MySQL and PostgreSQL databases the appropriate JDBC drivers has to be used.