Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Azure Cosmos DB

  1. Misc
2
Votes
Undo
  1. Marcin Jurkowski
    Marcin Jurkowski
  2. PowerBuilder
  3. Monday, 10 February 2020 15:48 PM UTC

Hi,

Does anyone know if there is or will be a Powerbuilder support for Azure Cosmos DB?

https://azure.microsoft.com/en-us/services/cosmos-db/
https://docs.microsoft.com/en-us/azure/cosmos-db/introduction

Regards,
Marcin

 

Good build, bad deployment
Pictures and images won't be displayed in developm...
Accepted Answer
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 11 February 2020 04:02 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Marcin,

Microsoft is providing various database technologies on Azure.  There is Azure SQL (which is basically SQL Server) and there is also the Azure Cosmo (which is a relatively new NoSQL database from Microsoft).

The DataWindow is designed for a relational database, and does not fit how NoSQL databases work.  So there will never be a "DataWindow" supporting Azure Cosmo or any other NoSQL database for that matter.

Depending on customer demand, we may develop an entirely new database object that is designed for a NoSQL database, such as Azure Cosmo.  But there wouldn't be any automated migration of your application to this new database object and NoSQL architecture.

On the other hand, if you want to use Azure SQL (a relational database solution in Azure).  Support for this is tentatively planned in PowerBuilder 2019 R3, and in the meantime you can consider to use SQL Server.

Regards,

Armeen Mazda
CEO, Appeon

Comment
Marcin Jurkowski
  1. Marcin Jurkowski
  2. Tuesday, 11 February 2020 09:06 AM UTC
Thank you Armeen. It explains everything.
  1. Helpful
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 11 February 2020 23:31 PM UTC
You're very welcome.
  1. Helpful
There are no comments made yet.
Responses (2)
Michael Kramer
Michael Kramer Accepted Answer Pending Moderation
  1. Monday, 10 February 2020 16:52 PM UTC
  2. PowerBuilder
  3. # 1

Hi Marcin,

Server-side it is already supported - since server-side is C#.

The issue at hand is: How to relate the tabular resultset approach of DataWindow objects to the dynamic data structure of non-relational databases like Cosmos DB?" No easy feat.

I remember chat with Armeen sometime back on this topic - and I'm sure Appeon in general has discussed this with more internal and external people. I see part of current roadmap at steps toward solving that issue, like:

  • Access to Azure SQL and Amazon Aurora
    (read: web-accessed databases)
  • Enhance RESTClient to retrieve into composite DW or structure.
    (read: non-relational databases)

HTH /Michael

Comment
mike S
  1. mike S
  2. Monday, 10 February 2020 20:18 PM UTC
the roadmap database comments are specific to c#. note, azure sql is basically just sql server. this can already be accessed / used in most versions of PB.







  1. Helpful
Michael Kramer
  1. Michael Kramer
  2. Monday, 10 February 2020 21:08 PM UTC
You're right!

Enhanced RESTClient is part of PowerScript App Integration.

Access to Azure SQL + Aurora is part of Enhanced C# Development.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.