Create SAP Fiori App with Mysql in SAP Cloud Foundry using (SAP Open connector + SAP API Management) PART I

[SilasCosta]

I’ve been searching for a long time trying to find a document that could help me find out how to use other databases (not SAP) in conjunction with SAP Cloud Platform Applications. I even found some, but they were related to Redis, Postgree and other databases, but here’s the problem: this year all of these services will be permanently removed from the SAP Cloud Platform.
When I finally got to know SAP Open Connector Service, a world opened up for me and here I would like to share a little bit of how Open Connector should be used in conjunction with API Management to enable data usage by an SAP Fiori application.

Here we are going to know how to create an Mysql Database and prepare to connect with SAP Open Connector. If you have any doubt about the process, follow the steps in the document

https://docs.microsoft.com/en-us/azure/mysql/tutorial-design-database-using-portal

Create an Azure account and create a new “Azure Database for Mysql” service.

In this next page search for mysql an select the item like shown in the image:

In the next page click in create

To do the next step you need to create a new Resource Group, here I’m naming (TrialAccount), fill all the other fields and press create.

1.2 Firewall configurations

Go to you created resource page and access the connection security option on the left menu.

Add the information like bellow and then save it.

1.3 Creating Database and table

Click in this URL and then in the button as shown bellow:

https://docs.microsoft.com/en-us/azure/mysql/tutorial-design-database-using-portal#connect-to-the-se...

Paste your database connection there and put your password.

After connected with the database create a new database schema, and then create this table bellow that we are going to use in this document. And do insert of the tables bellow.

CREATE TABLE t_category (

  Id_Category VARCHAR(50) PRIMARY KEY, 

  Category_Name VARCHAR(50), 

  Begin_Date VARCHAR(50), 

  Control VARCHAR(50), 

  End_Date VARCHAR(50) 

);



INSERT INTO t_category (Id_Category, Category_Name, Begin_Date,Control,End_Date) 

VALUES ('CAT0001', 'Senior manager', '21.02.2020', 'High','30.12.2999');

INSERT INTO t_category (Id_Category, Category_Name, Begin_Date,Control,End_Date) 

VALUES ('CAT0002', 'Internal ', '21.02.2020', 'Low','30.12.2999');

INSERT INTO t_category (Id_Category, Category_Name, Begin_Date,Control,End_Date) 

VALUES ('CAT0003', 'Conflict of intetest', '21.02.2020', 'Medium','30.12.2999');

Your database table should look like this:

Now we have our Mysql Database created and avaliable to be externally accessed.

In the next post we will need some information from this database so keep the Azure Portal opened.