ASE 138:  What is new in Sybase Adaptive Server Enterprise Connectivity
Download
1 / 34

ASE 138: What is new in Sybase Adaptive Server Enterprise Connectivity - PowerPoint PPT Presentation


  • 538 Views
  • Updated On :

ASE 138: What is new in Sybase Adaptive Server Enterprise Connectivity. Mani Reddy Development Manager Sybase Inc. Mani.Reddy@sybase.com Ashish Mahajan Development Manager Sybase Inc. Ashish.Mahajan@sybase.com August 15-19, 2004. The Enterprise. Unwired. The Enterprise. Unwired.

Related searches for ASE 138: What is new in Sybase Adaptive Server Enterprise Connectivity

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'ASE 138: What is new in Sybase Adaptive Server Enterprise Connectivity' - arleen


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Slide1 l.jpg

ASE 138: What is new in Sybase Adaptive Server Enterprise Connectivity

Mani Reddy

Development Manager

Sybase Inc.

Mani.Reddy@sybase.com

Ashish Mahajan

Development Manager

Sybase Inc.

Ashish.Mahajan@sybase.com

August 15-19, 2004



The enterprise unwired3 l.jpg
The Enterprise. Unwired. Connectivity

Industry and Cross Platform Solutions

Manage

Information

Unwire

Information

Unwire

People

  • Adaptive Server Enterprise

  • Adaptive Server Anywhere

  • Sybase IQ

  • Dynamic Archive

  • Dynamic ODS

  • Replication Server

  • OpenSwitch

  • Mirror Activator

  • PowerDesigner

  • Connectivity Options

  • EAServer

  • Industry Warehouse Studio

  • Unwired Accelerator

  • Unwired Orchestrator

  • Unwired Toolkit

  • Enterprise Portal

  • Real Time Data Services

  • SQL Anywhere Studio

  • M-Business Anywhere

  • Pylon Family (Mobile Email)

  • Mobile Sales

  • XcelleNet Frontline Solutions

  • PocketBuilder

  • PowerBuilder Family

  • AvantGo

Sybase Workspace


Connectivity products l.jpg
Connectivity Products Connectivity

  • SDK

  • Open Server


Slide5 l.jpg
SDK Connectivity

  • Open Client (CTLib, DBLib)

  • ESQL/C

  • ESQL/Cobol

  • XA

  • jConnect

  • ODBC

  • OLEDB

  • ADO.NET


Platforms l.jpg
Platforms Connectivity

  • Solaris 32,64

  • HPUX 32,64

  • HPUX Itanium 32,64

  • AIX 32,64

  • Linux 32

  • Linux Itanium 64

  • Tru64

  • NT/Windows 32

  • IRIX 32,64

  • MacOSX


Sdk open server releases l.jpg
SDK, Open Server Releases Connectivity

  • GA Release : SDK, Open Server

  • ESDs once every two monthsSDK ESDOpen Server ESDjConnect ESD

  • Current in-market releases: 12.0, 12.5.1

  • Next major release: 15.0


Release 12 5 1 l.jpg
Release 12.5.1 Connectivity

  • All features from previous releases (SSL, LDAP etc)

  • 12.5.1 GA released in Jan’04 with the following features:

    • Netlib optimization

    • Re-entrant Open Server shows significant performance gains

      • Lang server showing 116-196% performance improvement.

      • Smaller footprint and fewer threads created.

    • Date and Time data-types

    • MIT-Kerberos on Solaris 32,64 and Linux 32

    • HA-Failover support in ESQL

  • New features in 12.5.1 ESDsXA64 on Solaris64 (ESD#1)IPV6 on Solaris32,64 and NT/Windows (ESD#2)SSL+SBGSE support on Solaris 32,64 and NT/Windows (ESD#2)


Sdk open server feature roadmap l.jpg
SDK/Open Server Feature Roadmap Connectivity

  • OCS 12.5.1 ESD #4 – 7/2004

  • Dblib:Config variable for version

  • Added diagnostic ( tds tracing)

  • ASE 15.0 Beta 2, OCS 15.0 Beta - Q1,2005. All previous features plus

  • SDK and Open Server beta w/ install

  • Scrollable Cursors

  • BCP-Partitions (Phase 2)

  • BCP-Computed columns

  • Large identifiers

  • SSL upgrade to 4.x w/ FIPS 140-2

  • Latest Kerberos MIT libraries

  • ASE default packet size

  • Unilib character set conversion

  • Update COBOL compiler to latest

  • ASE 15.0/OCS 15.0 GA – Q2/2005.All previous features

  • XML datatype

  • XA64 on HP64, HPIA64,IBM64

  • OCS 12.5.1 ESD#6 for ASE 12.5.3 – Q4,/2004

  • BCP-Encrypted Columns

  • SSL Plus 3.1.10H

  • Korean char set enhancements

  • ASE 15x/OCS 15x , Q4,2005

  • Clusters: Login redirection

  • Clusters: Extended HA failover

  • Clusters: Context migration

  • Clusters: Connection migration

  • Clusters : XA

  • ASE 15.0 Beta 1, with OCS 15.0 – Q3, 2004

  • New datatypes

    • 64-bit integer /Big Int

    • Unsigned Int

    • Unitext datatype

  • BCP Partitions-phase1

  • Library renaming/streamlining

Q2/Q4,2005

Q2,2004

Q1,2005


Jconnect feature roadmap l.jpg
jConnect Feature Roadmap Connectivity

  • ASE 15.0 Beta 1, with jConnect 6x – Q3, 2004

  • Scrollable Cursors

  • Unitext datatype

  • ASE 15.0 Beta 2, SDK 15.0

  • (jConnect 6x) Beta Q1,2005. All previous features plus

  • SDK w/ install

  • Large identifiers

  • Latest Kerberos MIT libraries

  • LDAP 5.x

  • ASE default packet size

  • Big Int/64bit Integer

  • Unsigned int

  • Enhance Ribo for new features

  • JDBC 3.0 (partial: on-demand methods)

  • ASE 15.0/SDK 15.0 GA – Q2/2005.All previous features

  • XML datatype

  • ASE 15x/SDK 15x , Q4,2005

  • Clusters: Login redirection

  • Clusters: Extended HA failover

  • Clusters: Context migration

  • Clusters: Connection migration

Q2/Q4,2005

Q2,2004

Q1,2005


Dblibrary l.jpg
DBLibrary Connectivity

  • No new feature(s)/Enhancements after version 10.0 like CTLibrary.

  • Well supported.

  • Changes

    • Appropriate error messages for new features

    • API Call to get the hostname and port number.

    • DBLib on NT/Windows supports directory services-LDAP.

    • TDS 4.x or 5.0

  • Hint: Hint : Move to CTLibrary!!!


Ctlibrary l.jpg
CTLibrary Connectivity

  • All new feature development and is well supported.

  • Has threaded and non-threaded versions


Esql c l.jpg
ESQL/C Connectivity

  • All new feature development and is well supported

  • Available on all 32bit platforms


Esql cobol l.jpg
ESQL/Cobol Connectivity

  • All new feature development and is well supported.

  • ESQL/Cobol available on following platforms Solaris 32HPUX 32AIX 32NT/Windows 32Tru64


Slide15 l.jpg
XA Connectivity

  • All new features and is well supported.

  • Available on Solaris 32, 64HPUX 32AIX 32NT/Windows 32


Jconnect l.jpg
jConnect Connectivity

  • It consists of jConnect librariesjisqljTDSRibo

  • JDK Versions

    • jConnect 6.0 : JDK 1.4

    • jConnect 5.2/5.5 : JDK 1.2

    • jConnect 4.2/4.5 : JDK 1.1 (Eol’ed )


Open server l.jpg
Open Server Connectivity

  • All new features and is well supported.

  • Available on all platforms in threaded, non-threaded and smp/pre-empt modes.


Open server example l.jpg
Open Server Example Connectivity

  • This is an example of how Open Server can be used to read external data (e.g. a datafile, errorlog etc.) with a registered procedure and make the contents/info available in ASE.

  • In the meantime, Open Client application ‘ctwait’ is monitoring the execution of this registered procedure.

  • Example is based on the provided examples: regproc.c, ctwait.c and version.c


Slide19 l.jpg

Open Server Example Connectivity

ASE

isql

execute

MY_OPENSERVER…rp_readfile

rpc call

MY_OPENSERVER

ctwait

Monitors the execution of rp_readfile

and raises a message when this

procedure is being executed

read from ‘datafile’


Open server example contd l.jpg
Open Server Example: (Contd) Connectivity

  • Open Server program ‘regproc’ is started (‘MY_OPENSERVER’)

  • This Open Server application contains 2 registered procedures:

    • rp_version (returns the Open Server version string)

    • rp_readfile (reads data from a datafile)

  • Open Client program ‘ctwait’ connects to MY_OPENSERVER and monitors the execution of rp_readfile.

  • Open Client application isql connects to an ASE and executes a remote procedure call to the Open Server:

  • execute MY_OPENSERVER…rp_readfile


  • Open server example contd21 l.jpg
    Open Server Example: (Contd) Connectivity

    • Open Server executes this registered procedure, reads data from an external datafile and returns the requested content via ASE to the client.

    • Open Client program ‘ctwait’ is notified by Open Server that the procedure has been executed and raises a message.


    Open server 12 5 1 performance test l.jpg
    Open Server 12.5.1 Performance Test Connectivity

    • 4-CPU SPARC running Solaris 8

    • Server is lang sample server

    • Client is firstapp sample client

    • 100000 queries were executed divided equally between clients

    • All queries were short and simple.




    Slide25 l.jpg

    ASE 138 What is new in Sybase Adaptive Server Enterprise Connectivity

    Part II – ADO.NET / ODBC / OLEDB

    Ashish Mahajan

    Development Manager

    Sybase Inc.

    Ashish.Mahajan@sybase.com


    Progress from last year l.jpg
    Progress from last year Connectivity

    • Windows ODBC / OLEDB 12.5.1 beta

    • Mac ODBC beta

    • Linux ODBC beta

    • Linux ODBC 12.5.1 release

    • ADO.NET v 1.1 release

    • ADO.NET v 1.0 release

    • ADO.NET beta

    TechWave,2004

    TechWave,2003


    Ado net data provider l.jpg
    ADO.NET Data Provider Connectivity

    • Managed provider for .NET applications

    • Supports Microsoft ADO.NET version 1.1

    • Supported on Windows 2003, 2000, NT and XP

    • Ships with OCS SDK 12.5.1 and ASE PC Client 12.5.2

    • Version 1.0 released in Q4 2003

    • Version 1.1 released in Q2 2004


    Ado net data provider ase features l.jpg
    ADO.NET Data Provider – ASE Features Connectivity

    • Supports the new data types in ASE 12.5.1

      • DATE

      • TIME

    • Support for “SELECT FOR XML” by using AseCommand.ExecuteXmlReader()

    • LDAP support

    • Encrypted Passwords

    • SSL support

    • HA Failover


    Ado net feature roadmap l.jpg
    ADO.NET Feature Roadmap Connectivity

    • ASE 15.0/OCS SDK 15.0 GA – Q2/2005

    • ADO.NET 2.0 compliant

    • Kerberos

    • DTC

    • ASE default packet size

    • Big Int/64bit Integer

    • Unsigned int

    • XML datatype

    • ASE 15.0 Beta , SDK 15.0

    • All previous features plus

    • Unitext datatype

    • Large Identifiers

    • IPv6

    • ADO.NET 1.1

    • SSL

    • LDAP

    • HA Failover

    • Encrypted Passwords

    • All datatypes supported in ASE 12.5.2

    • ASE 15x/OCS SDK 15x , Q4,2005

    • Clusters: Login redirection

    • Clusters: Extended HA failover

    • Clusters: Context migration

    • Clusters: Connection migration

    Q2/Q4,2005

    Current

    Q4,2004


    Odbc driver l.jpg
    ODBC driver Connectivity

    • Currently shipping ODBC driver on Windows is an OEM Driver

    • Sybase is introducing an ODBC driver built in house

    • Version 12.5.1 is already shipping on Linux platform

    • Currently in Beta for Mac OS X 10.3 and Windows platforms

    • Applications will need to be migrated to use the Sybase driver

    • Migration:

      • DSN – will need to be reconfigured

      • Possibly Connect Strings will need to be modified

      • Migration as seamless as possible


    Odbc feature roadmap l.jpg
    ODBC Feature Roadmap Connectivity

    • ASE 15.0/OCS SDK 15.0 GA – Q2/2005

    • Bundle only in house driver

    • Kerberos

    • DTC

    • ASE default packet size

    • Big Int/64bit Integer

    • Unsigned int

    • XML datatype

    • Async

    • ASE 15.0 Beta , SDK 15.0

    • All previous features plus

    • Scrollable cursors

    • Unitext datatype

    • Large Identifiers

    • IPv6

    • OCS SDK 12.5.1 – ESD#5

    • SDK will include both OEM and in house driver

    • SSL

    • LDAP

    • HA Failover

    • Encrypted Passwords

    • All datatypes supported in ASE 12.5.2

    • ASE 15x/OCS SDK 15x , Q4,2005

    • Clusters: Login redirection

    • Clusters: Extended HA failover

    • Clusters: Context migration

    • Clusters: Connection migration

    Q2/Q4,2005

    Q3,2004

    Q4,2004


    Oledb data provider l.jpg
    OLEDB Data Provider Connectivity

    • Currently shipping OLEDB Provider is an OEM Provider

    • Sybase is introducing an OLEDB Provider built in house

    • Currently in Beta

    • Applications will need to be migrated to use the Sybase Provider

    • Migration:

      • Possibly Connect Strings will need to be modified

      • Migration as seamless as possible


    Oledb feature roadmap l.jpg
    OLEDB Feature Roadmap Connectivity

    • ASE 15.0/OCS SDK 15.0 GA – Q2/2005

    • Bundle only in house provider

    • Kerberos

    • DTC

    • ASE default packet size

    • Big Int/64bit Integer

    • Unsigned int

    • XML datatype

    • Async

    • ASE 15.0 Beta , SDK 15.0

    • All previous features plus

    • Scrollable cursors

    • Unitext datatype

    • Large Identifiers

    • IPv6

    • OCS SDK 12.5.1 – ESD#5

    • SDK will include both OEM and in house provider

    • SSL

    • LDAP

    • HA Failover

    • Encrypted Passwords

    • All datatypes supported in ASE 12.5.2

    • ASE 15x/OCS SDK 15x , Q4,2005

    • Clusters: Login redirection

    • Clusters: Extended HA failover

    • Clusters: Context migration

    • Clusters: Connection migration

    Q2/Q4,2005

    Q3,2004

    Q4,2004


    Slide34 l.jpg

    ASE 138 What is new in Sybase Adaptive Server Enterprise Connectivity

    Feed Back / Q&A

    Mani Reddy

    Development Manager

    Sybase Inc.

    Mani.Reddy@sybase.com

    Ashish Mahajan

    Development Manager

    Sybase Inc.

    Ashish.Mahajan@sybase.com

    August 15-19, 2004