1. Heiko Betzler
  2. PowerBuilder
  3. Friday, 19 January 2024 09:36 AM UTC

Hello everyone,

we have been using PowerBuilder together with SQL Anyhwere for over 20 years. For some years now in version 17.

Unfortunately, we cannot find any information about the further development of SQL Anywhere by SAP and when a possible version 18 could be released.

 

1. Are we part of a minority who still use PowerBuilder with SQL Anywhere? Are there any other companies that use PowerBuilder with SQL Anywhere?

2. Does anyone (or Appeon) have any information about the future of SQL Anywhere and what SAP is planning in this direction?

 

That would be very interesting for us to know.

 

Have a nice weekend everyone.

Best regards

Heiko

Glenn Barber Accepted Answer Pending Moderation
  1. Tuesday, 22 October 2024 22:43 PM UTC
  2. PowerBuilder
  3. # 1

Today we were notified that as of Dec 2028 there will no longer be a OEM program and all support will expire. (see below)

Whatever transition to the cloud means (we are already in the Cloud running from our own servers)???

I have emailed them for more clarity - but there have been suggestions that something like this was going to happen for some time (reassignment of personnel, etc)   Maybe they will only offer it as a Service from some cloud platform.   Given that we have been running with Windows Remote Apps from Windows Server, and the licensing got more and more expensive and constrained - it was clear that we should have been working to move off SQL anywhere for some time.

Recently we have been converting apps and code to Postgresql - sometimes with surprising improvements in performance.  While we love SA's implementation of the Scalar List Statement and the ability to use computed fields in the where clause, we are finding acceptable getarounds and found some tools that do a really good job of converting the database.

I had hoped perhaps that Appeon could take over support for it,  like they had with PowerBuilder - but just don't think that is happening.

We'd  been interested in other's experiences and successes in transitioning away from SQL Anywhere.

Glenn Barber

 

"Dear Valued Partner,
With the fast transition of SAP customers and partners to the cloud and the market requesting cloud-based solutions, SAP has decided to scale down its on-premise offering under the OEM program. We will offer to extend your current OEM agreement to allow you sufficient time transitioning your business to the cloud.  
To minimize disruption, we are offering to extend your current OEM agreement to December 31st, 2028. Commercial and other terms will remain unchanged during the extended term. After December 31st, 2028 your OEM agreement with SAP will terminate. Support services will not be renewed after the end of the respective support terms.
Please find attached your OEM Term Extension Offer. Should you decide not to extend, your OEM agreement will expire as per its current term. If you choose to accept the offer to extend your OEM agreement, please sign the extension addendum via DocuSign within 60 days. Once signed by both parties, DocuSign will automatically send you the fully executed version for your records.
Your company has the choice to accept the term extension offer or let your current OEM agreement run until its expiration date (by not signing the extension addendum). However, no further renewal options will be offered in the future.
If you have questions, please read the OEM Term Extension FAQ https://partneredge.sap.com/en/library/assets/partnership/dgl/44/40/SAP934440.html (S-user required).

Comment
  1. Glenn Barber
  2. Wednesday, 23 October 2024 00:08 AM UTC
Maybe we need to create some cooperative PB Group for this conversion activity...
  1. Helpful 3
  1. David Peace (Powersoft)
  2. Wednesday, 23 October 2024 15:26 PM UTC
Migrating to SQL Server Express version may be an easier job. The syntax is quite similar from my experience.
  1. Helpful
  1. Glenn Barber
  2. Wednesday, 23 October 2024 15:54 PM UTC
As far as I know referencing computed fields in where clauses and the Scalar List statement do not exist in SQL Server - and of course upsizing becomes very-very expensive. Not an Option for an OEM with a SAS solution.
  1. Helpful
There are no comments made yet.
Chris Keating Accepted Answer Pending Moderation
  1. Wednesday, 21 February 2024 01:45 AM UTC
  2. PowerBuilder
  3. # 2

SQL Anywhere development was not let go 5 years ago. SQL Anywhere development remains in Waterloo- I am still working in Waterloo. SQLA is used in a number of SAP products - including legacy Sybase products as well as SAP products.

SQLA plays a key part in SAP IQ and SAP IQ development has had resources in Waterloo for a long time. There was an office closed about 5 years ago that impacted IQ development. That development was transferred to Waterloo.  There is also an ASE footprint in Waterloo. 

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 21 February 2024 02:45 AM UTC
Hi Chris;

Thanks for chiming in ... It's nice to hear from you again!

However, after 5 years ... where is ASE V17? Where is SA V18?

Can you share an ASE & SA release schedule? How about a confirmed road map for each DBMS? I think that you need to bolster these customers confidence after this long silence. ASE & SA customers need to be confident that these products "are" really moving forward (IMHO).

Regards ... Chris
  1. Helpful 4
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Monday, 22 January 2024 17:34 PM UTC
  2. PowerBuilder
  3. # 3

I can't give you exact metrics because SQL Anywhere is not Appeon's product, but we have many PB customers that are using SQL Anywhere as their database.  I would say after SQL Server and Oracle, SQL Anywhere is 3rd most common database among Appeon customers.  Perhaps this is why SAP has not made an discontinuation announcement... way too many people using it currently to pull the rug out from underneath them?

Comment
There are no comments made yet.
Steve Sagodi Accepted Answer Pending Moderation
  1. Monday, 22 January 2024 16:56 PM UTC
  2. PowerBuilder
  3. # 4

We bundle SQLAnywhere with our software and are an OEM partner with SAP.  We haven't received any notification from them, but haven't been able to get any clear answers either from SAP on their plans for SQLAnywhere.

cheers,

Steve

Comment
There are no comments made yet.
Kevin Ridley Accepted Answer Pending Moderation
  1. Monday, 22 January 2024 16:21 PM UTC
  2. PowerBuilder
  3. # 5

It's a shame, one of the best lightweight db's ever IMO.  I've already converted most of my older SQLAnywhere apps to Postgres.  The ones I converted were small business apps though.

Comment
  1. Chris Pollach @Appeon
  2. Monday, 22 January 2024 16:44 PM UTC
Hi Kevin... A smart move IMHO. ;-)
  1. Helpful
There are no comments made yet.
Simone Olianti Accepted Answer Pending Moderation
  1. Monday, 22 January 2024 15:09 PM UTC
  2. PowerBuilder
  3. # 6

We are in the same situation. Using Sql Anywhere in our ERP software and now we are a little worried about this news

Comment
There are no comments made yet.
Heiko Betzler Accepted Answer Pending Moderation
  1. Monday, 22 January 2024 06:46 AM UTC
  2. PowerBuilder
  3. # 7

Hello André,

thanks for your answer and the interesting link to the SAP forum.

We are in the same situation as you: we are also OEM-Partner (of SQL Anywhere) located in Germany. In recent months, we have increasingly tried to contact SAP. We have not yet received any news from SAP.

We hope that SAP will take a path that makes sense for all of us.

Best regards

Heiko

 

 

Comment
There are no comments made yet.
André Monz Accepted Answer Pending Moderation
  1. Friday, 19 January 2024 12:01 PM UTC
  2. PowerBuilder
  3. # 8

Hi Heiko,

we use SQL Anywhere in our ERP Software, we are SAP "Oempartner".
A few days ago we received an email from SAP (OEMPARTNER@sap.com) announcing the end of SQL Anwyhere.
See also https://sqlanywhere-forum.sap.com/questions/39190/migration-tool-sql-anywhere-to-postgres

Gruß
André

Comment
  1. Chris Pollach @Appeon
  2. Monday, 22 January 2024 15:56 PM UTC
Hi Heiko;

Yes, the writing has been on the wall for the past 5 years. SA DBMS was designed & supported here in Waterloo, Ontario, Canada. All the engineering team was let go 5 years ago ( I knew some of them) and only barebones technical support staff were left at that point. SAP's focus is Hana since they bought out Sybase. I would even wonder where the ASE roadmap is? It's a real shame as ASE & SA were "top notch" DBMS in there day but no longer being developed <sad>.
  1. Helpful
  1. Roland Smith
  2. Monday, 22 January 2024 18:33 PM UTC
You have to wonder why SAP bought Sybase in the first place. It certainly wasn't PowerBuilder and ASE sales are so small they don't even get onto the charts. Perhaps the messaging network Sybase 365?
  1. Helpful 2
  1. Tobias Roth
  2. Wednesday, 31 January 2024 03:24 AM UTC
I think I heard that it was primarily about the synchronization/Mobilink technology. But that could just be rumors.

The fact is that since the release of SA17, there has been no significant further feature development and only maintenance of the software.

Until this is clarified, all customers will unfortunately remain uncertain, and for me personally, SAP has now lost a lot of trust for the time being.
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.