• You are here:  
  • Home
  • Q&A
  • Q&A
  • SnapDevelop
  • Support for SAP Adaptive Server Enterprise with SnapDevelop

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

Resolved Support for SAP Adaptive Server Enterprise with SnapDevelop

  1. Misc
1
Votes
Undo
  1. Pieter Coene
    Pieter Coene
  2. SnapDevelop
  3. Thursday, 21 November 2019 11:06 AM UTC

We are experimenting with C# Model Generator and SnapDevelop in Powerbuilder 2019. We would like to use this to create ASP.Net WebApi C# code based on our existing Datawindows so we don’t have to write all the code from scratch.

According to the Appeon documentation there is currently no support for the SAP ASE database. I’ve tried to get this working with ODBC but it doesn’t work. Is it possible to generate C# model classes from a Datawindow without making a database connection?

Also, are there any future plans to support SAP Adaptive Server Enterprise so we can use SnapDevelop in combination with our databases?

Greetz
Pieter

  1. ASE
  2. SnapDevelop
No Access to Scaffolding Functionality
Asp.net DataStore.Retrieve(arg[]) method
Accepted Answer
Armeen Mazda @Appeon
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 21 November 2019 15:59 PM UTC
  2. SnapDevelop
  3. # Permalink

Hi Pieter,

One of the primary issues is that SAP is not providing appropriate .NET database drivers for ASE (needs to be compatible with the .NET Core framework).  In fact, they also didn't do this for SQL Anywhere.

We went ahead and supported ODBC as a workaround for SQL Anywhere.  The reason we did so is that SQL Anywhere has fairly significant market share among Appeon customers, and it didn't seem to us that a lot of important SQL Anywhere functionality would be lost through ODBC interface.

ASE is a different story from SQL Anywhere.  Among Appeon customers it has fairly small market share.  But the bigger issue is that through ODBC there would be significant ASE-specific functionality that would be lost.  So we are concerned if we put the effort to add this to SnapDevelop maybe many ASE customers still wouldn't accept this solution?

Anyway, we are carefully thinking and evaluating if/when SnapDevelop should support ASE.  It would make the decision a lot simpler if SAP would just provide appropriate database drivers in the footsteps of all the other leading database vendors.

Regards,

Armeen Mazda
CEO, Appeon

Comment
There are no comments made yet.
Responses (3)
Pieter Coene
Pieter Coene Accepted Answer Pending Moderation
  1. Tuesday, 26 November 2019 07:43 AM UTC
  2. SnapDevelop
  3. # 1

Hello Armeen,

Thanks for the response. We have the same struggle with the missing ASE ADO.Net Core providers from SAP. We hoped SAP would create new ASE providers but as far as we know there aren’t any plans nearby for a 2.0./3.0. provider. We are now experimenting with the open source ASE .Net Core module:

https://github.com/DataAction/AdoNetCore.AseClient

I don’t know if this module is an option for Appeon?

Another question: are there any plans to add support to “C# Model Generator” to create the model classes without requiring a database connection? I’ve created a datawinow with an “External” data source so I can manually add the fields without requiring a database. When I want to generate the C# models, I’m still required to assign a database connection to the tool. I don’t understand why a database connection is required when the datawindow doesn’t contain any SQL queries. Are there any plans to add this functionality in the future or is this already possible with the current client somehow?

Kind regards,

Pieter Coene

Comment
There are no comments made yet.
Julie Jiang @Appeon
Julie Jiang @Appeon Accepted Answer Pending Moderation
  1. Thursday, 28 November 2019 06:08 AM UTC
  2. SnapDevelop
  3. # 2

Hi Pieter,

 

Thanks for your suggestion.  We will start on studying the possibility of generating C# model classes from a Datawindow without making a database connection. If possible, this may be directly added in the 2019 R2 GA version.

As for supporting the ASE on .NET Core, we still need some to check for a more reliable solution, or make sure that this module you mentioned (https://github.com/DataAction/AdoNetCore.AseClient) is a well-accepted and stable solution for supporting ASE + .NET core. So, please give a little more time for our team to decide on the solution.

Best regards, Julie 

Comment
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.