1 / 34

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

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.

arleen
Download Presentation

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

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

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

  2. The Enterprise. Unwired.

  3. The Enterprise. Unwired. 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

  4. Connectivity Products • SDK • Open Server

  5. SDK • Open Client (CTLib, DBLib) • ESQL/C • ESQL/Cobol • XA • jConnect • ODBC • OLEDB • ADO.NET

  6. Platforms • 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

  7. SDK, Open Server Releases • 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

  8. Release 12.5.1 • 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)

  9. SDK/Open Server Feature Roadmap • 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

  10. jConnect Feature Roadmap • 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

  11. DBLibrary • 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!!!

  12. CTLibrary • All new feature development and is well supported. • Has threaded and non-threaded versions

  13. ESQL/C • All new feature development and is well supported • Available on all 32bit platforms

  14. ESQL/Cobol • All new feature development and is well supported. • ESQL/Cobol available on following platforms Solaris 32HPUX 32AIX 32NT/Windows 32Tru64

  15. XA • All new features and is well supported. • Available on Solaris 32, 64HPUX 32AIX 32NT/Windows 32

  16. jConnect • 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 )

  17. Open Server • All new features and is well supported. • Available on all platforms in threaded, non-threaded and smp/pre-empt modes.

  18. Open Server Example • 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

  19. Open Server Example 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’

  20. Open Server Example: (Contd) • 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

  21. Open Server Example: (Contd) • 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.

  22. Open Server 12.5.1 Performance Test • 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.

  23. Open Server 12.5.1 Performance Chart

  24. Open Server 12.5.1 Performance Chart

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

  26. Progress from last year • 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

  27. ADO.NET Data Provider • 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

  28. ADO.NET Data Provider – ASE Features • 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

  29. ADO.NET Feature Roadmap • 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

  30. ODBC driver • 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

  31. ODBC Feature Roadmap • 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

  32. OLEDB Data Provider • 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

  33. OLEDB Feature Roadmap • 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

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

More Related