SAP SQL Anywhere 17 on Windows 10

SAP SQL Anywhere 17 was announced in June 2015. It is a nice database and I always liked it, because it just works! I have written a number of articles on the earlier versions and of course I wanted to try this latest version.

This version comes with a lot of enhancements. I recommend this site where you can read lot more and focus on installing it on a Windows 10 machine.

Here is an excerpt from that site on developer related features of Version 17:

Developer Enhancements

• OData Enhancements - The SQL Anywhere database server can act as an OData server.  This functionality replaces the OData Server utility.  In addition, the The OData producer now supports a greater subset of the OData Service Definition Language (OSDL). 
• JavaScript external environment - SQL Anywhere now includes support for JavaScript stored procedures and functions.
• Node.JS and Python drivers - The SQL Anywhere Node.js driver allows users to connect and perform queries on the database using JavaScript on Joyent’s Node.js Software platform.   In addition, the three SQL Anywhere python drivers are now available through PyPI, the official Python package index.
• Consolidated db – MobiLink has support for SAP ( ASE, IQ, SQLA), Oracle, Microsoft, IBM, MySQL back-end databases.  We continue to add support for newer versions of these databases.  In v17, we added support for Oracle 12.1, ASE 16, SS 2014,MySQL 5.6.20, IBM DB2 10.5. 
• HANA Integration – with our SAP HANA Remote Data Sync product, MobiLink becomes more tightly integrated into the HANA platform infrastructure (assigned port numbers, lifecycle management, name server integration, license management, monitoring integration).
• SAP Passport support and NCSLib logging

You need to download the installation file from here after registering here:

https://go.sap.com/cmp/syb/crm-xu15-int-sqldevft/index.html

You can download both SAP SQL Anywhere 16 which requires a key that you get after registering or SAP SQL Anywhere 17 which does not require a key. The product you get is a developer edition good for developing on your machine and not for production.

If you do not know about SAP SQL Anywhere may be this is a good place to start:



It is available for Linux as well as Windows. I downloaded the Windows version (x64 bit).
As the ad says, it just Works.

After installation you should be seeing these on your Windows 10 computer.

There are a number of built-in tools that you can use.

Get dozens of tutorial articles on Sybase/SAP SQL Anywhere from here.

It has a nice management interface called Sybase Central shown here:

PowerBI Preview reporting from SQL Anywhere 16 - Part 2

Connection problem mentioned  in the previous post:
PowerBI Preview reporting from SQL Anywhere 16 - Part 1
was resolved.

This post describes the correct way of making a connection to SQL Anywhere 16 from Power BI and generating a report from a View on the server.

If this is the first time you land on this page, please review the following post that describes the step-by-step process:
 http://hodentekmsss.blogspot.com/2015/02/authoring-report-with-power-bi-using.html

Make sure the SQL Anywhere 16 network server has started. After launching PowerBI and hitting the Get Data link the following screen will be displayed:

sybase3

Click connect to connect to the SQL Anywhere 16 server running on your laptop. The following screen is displayed.

Sybase17

Enter Server and Database name as shown. You can read this from the server startup screen superimposed.

Click OK on this screen. The following screen is displayed. If instead of this you may get an authentication window. In which case choose 'Database' login and use the sql/dba pair for authentication.

Sybase18

You may recognize these as the tables on the 'Demo' database on the samples provided by Sybase (SAP).

By default only the tables are displayed. In order to display views you may have to search for them. Review this screen from Sybase Central connected to the same server.

Sybase19

There is a  View called ViewSalesOrders. Insert this in the search box and click search. The ViewSearchOrders data will be displayed as shown.

Sybase20

Clock Load and load the data to the BI Designer. Perhaps this data may not be the greatest data ti mine, but let us go ahead and see. The data gets loaded to the mode as shown.

As shown in my previous post choose the items to be included in your report as shown on the right extreme of the next image which shows all the fields contained in the View. The report gets generated in no time at all. All that was done was to choose the fields. it cannot get any dumber!

 

Sybase21

 

That is all folks! Namaste

 

 

Microsoft Products with other software

Enterprises use products from disparate vendors based on their business needs; chronological evolution of their business; plain necessity and for any number of other reasons. Hence there are always occasions that they will be looking beyond a single vendor or product. I have been looking at how Microsoft products mesh with other vendor products with the view of helping to provide some help by writing about my experiences which I list here. It is possible that the list is not complete.

Visual Studio 2008 and SQL Anywhere 11 Integration

On Installing the SQL Anywhere 11

Visual Studio 2008 Integration

Breaking news!!

On Installing the SQL Anywhere 11

Register as a developer and get Panorama_windows_Beta (263 MB) from Sybase web site.

This one is pretty easy to install. I am sure the release edition will be as easy. Double click the downloaded file to kick off the installer. You see the Welcome Screen.

Click Next and get to see the License (Better read it). It looks like this is software has international exposure and widely used.

Accept the license and click Next. Verify Server licensing information and click Next.

Check out how much resource you have and accept the complete. Click Next.

Click on Install on Ready to Install Screen.

Installing SQL Anywhere 11 Progress screen shows up.

Hang around for a while till the process gets completed.

You are done!!







Nothing can be easier than this.

Now the fun begins. Go to Start |All Programs |SQL Anywhere 11 and you can see all the goodies you got.

Visual Studio 2008 Integration Features

If you have Microsoft Visual Studio Installed you can open and verify that hooks to integrate VS with SQL Anywhere is ready to go. You can get to Sybase Central (Management interface for the SQL Anywhere products you downloaded) as well as Interactive SQL where you can test your SQL skills. You need authentication which is Username: dba and Password: sql

You can also Browse using the SQL Anywhere Explorer from within VS 2005 (also VS2008).

If you are used to ODBC and adept at it go ahead and open the ODBC Manager and verify you have the correct driver.

You can learn a number of things about this database products following articles at this link:

http://hodentek.blogspot.com/2007/06/sql-anywhere-10-related-articles.html

Happy learning!

Breaking news!!

PS: As of this writing you can download a Developer's edition by registering at the Sybase site.

Soap Web Service with SQL Anywhere

Enabling interoperability is one of the greatest benefits of using web services. In the business world, applications work on different platforms with different operating systems running applications whose programming languages vary wildly. For applications to interact
with each other there should be a common method to transparently talk to all the different systems. In fact, the charter of the WS-I, an open industry organization source, is to promote this idea of interoperability across platforms, operating systems, and programming languages.

Read this article ...

Consuming a SQL Anywhere native web service using a .NET client
By Jayaram Krishnaswamy
International Sybase Users Group Technical Journal, May / June 2008, Pages 14 - 19

Join ISUG and get a load of benefits.

Must read article on VB.NET Integration

Microsoft Visual Studio has attracted a lot of attention from many vendors and you can find add-ins that give direct access to third party programs. This is a much needed synergy as businesses grow and embrace a multiplicity of products.

This article shows how you can develop a VB.NET 2.0 application using the integration features provided by the SQL Anywhere database. The SQL Anywhere tools are directly accessible without going out of the Visual Studio 2.0 IDE. The article describes a window application with two examples developed with this easy to use integration interface.

VB.NET Application with SQL Anywhere 10 database

Links to my articles on Web Services

Here is a collection of my articles on web services that you may want to review:

Web Services and SOA will be future trends in business IT get a Jump start on them !!!

Web Service Calling with VB 6.0:

Calling a Web Service using VB6 with SOAP 3.0

Cold Fusion related:

Creating a VB.NET Client for a ColdFusion Web Service

Creating a Web Service with ColdFusion: the Basics

ColdFusion WS Consumer for a WS Created in VS2003

Using Web Matrix:

Creating a Web Service with Web Matrix

Consuming a Service Created with Web Matrix


On Web Services Enhancements 2.0:

Exploring the Pipeline Class Using Web Services Enhancements SP2

Exploring the Header in the WSE 2.0 SoapEnvelope Class

Exploring the SoapEnvelope Class in WSE2.0


Visual Studio .NET Client / Server:

Encoding/Decoding Web Service: Service Consumer

Encoding/Decoding Web Service: Web Service Provider

Client calling with Sun Java Studio Creator:

JSP Consumer for a Visual Studio Created Web Service Using Sun Java Studio Creator

Crystal Report as a service with VS 2003:

Publishing Crystal Report as a Web Service

Using Sybase Central:

Using SQL Anywhere Database with a Web Services Server

Using the Oracle 10G XE IDE:

Creating an Oracle Web Service Client for a Web Service Created in VS 2005

Using Microsoft Access 2003

MS Access Project Using Multiple Web Services