Question Re: Creating PostgreSQL OData in BAS. in Technology Q&A

Creating PostgreSQL OData in BAS.

venkata_dirisinala48 — Fri, 17 Mar 2023 11:56:08 GMT

How to create PostgreSQL OData in SAP Mobile Development Kit through BAS and How to get as a service in Cloud Foundry.

Re: Creating PostgreSQL OData in BAS.

Hai-lin_Wei — Mon, 20 Mar 2023 03:58:33 GMT

Hello Dirisinala,
Here we can input a PostgreSQL instance name which is existing in Cloud Foundry, if it hasn't been created yet. Please try to create one in CF.

Please note:

1. if can't find 'PostgreSQL, hyperscaler option' in Service Marketplace of subaccount, Then global account administrator should assign 'PostgreSQL, hyperscaler option | postgresql-db' service firstly in BTP Control Center(https://controlcenter.ondemand.com/index.html), then configure entitlement in BTP cockpit page.

2. service 'PostgreSQL' in Service Marketplace is deprecated now. (avoid using it.)

3. you can find "-bind", "pgsql:<your pgsql instance name>", in the created tasks.json. see more details, please refer https://help.sap.com/doc/f53c64b93e5140918d676b927a3cd65b/Cloud/en-US/docs-en/guides/getting-started/mbt/service-generator.html

4. run csdl-to-war task in BAS will deploy the metadata as odata service finally.

Thanks
Hai-lin.wei

Re: Creating PostgreSQL OData in BAS.

venkata_dirisinala48 — Mon, 03 Apr 2023 05:42:57 GMT

Hi Hai-lin Wei,

I am facing this below error after running Csdl-to-war:

Re: Creating PostgreSQL OData in BAS.

Hai-lin_Wei — Mon, 03 Apr 2023 08:45:37 GMT

can you please use Terminal -> Run Task -> "download - logs" to download CF logs.
you may need "cf enable-ssh <appName>" to enable ssh if not enabled yet. the "download - logs" will check if ssh enabled or not.

Re: Creating PostgreSQL OData in BAS.

venkata_dirisinala48 — Mon, 03 Apr 2023 10:05:23 GMT

I am not able to see to download -logs in Terminal -> Run Task and then i tried that Cf enable-ssh but same issue after using that command also.

Re: Creating PostgreSQL OData in BAS.

Hai-lin_Wei — Tue, 04 Apr 2023 06:41:41 GMT

Hello Dirisinala,

please upgrade the MBT extension to the latest 1.13.4 version. the download-logs task can be found in that version.

And please feel free to mail at hai-lin.wei@sap.com for further question. Thanks a lot!

Re: Creating PostgreSQL OData in BAS.

venkata_dirisinala48 — Tue, 04 Apr 2023 07:11:32 GMT

Hi Hai-lin Wei,

Whether this option is available for Trail version. If available please let me know.

Re: Creating PostgreSQL OData in BAS.

Hai-lin_Wei — Thu, 06 Apr 2023 02:51:33 GMT

Hi venkata_dirisinala,

An OData service can be deployed successfully with my trial account at API Endpoint: https://api.cf.us10-001.hana.ondemand.com (postgresql instance is used.)

"Executing task: /extbin/local/openvscode-server/extensions/vsc-extension-mbt-1.13.1/resources/server-odata-sdk/bin/csdl-to-war.sh /home/user/projects/MBT/example.SimpleSchema.csdl.xml /home/user/projects/MBT -workspace /home/user/projects -application testTrial -version 1.0.0 -bind postgresql:postgreSql-instance -cf:push -sap:cf -cf:logs -console:log -log:trace"

Please note, if encounter the issue in below screenshot, please uncomment the service in manifest.yml file.