Database strategy and consulting services

Customer Case Study: Leading US Bank Company Moves SAP ASE to AWS for High Availability, Scalability and Cost Savings

By | Case Studies
Overview Business Situation: Outdated platform lacked high availability and scalability needed. Required frequent oversight and dedicated team to manage. Solution: Migrate from AIX to AWS and upgrade to latest Sybase version (ASE 16). Benefits: Cost Savings, Increased Availability, Performance Improvement. Business Challenge This company is one of the largest US banks with 755 branches and multiple financial products. Such a large organization needs an efficient, scalable computing platform. At the time, they were managing their workload with an older version of Sybase on AIX. This required constant management with a dedicated in house data center, and infrastructure team. Updates, patches, and hardware overhauls were becoming costly and time consuming. The company recognized that a cloud platform could increase their team’s productivity and better support the high demands of the financial services business. After careful consideration, they decided to upgrade to the latest version of Sybase (ASE 16) and migrate from AIX to Amazon Web Services (AWS). Solution With such a large-scale critical workload to migrate, fidelity and security were key considerations. The company’s team knew a Sybase expert would help ensure a smooth transition. They selected Dobler Consulting for this role. Dobler’s team devised an IT strategy that increased high (more…)
Database strategy and consulting services

Customer Case Study: Major US Airline Migrates Mission-Critical Systems to Increase Stability and Performance

By | Case Studies
Overview Business Situation: Old Sybase version needed upgrades but potential downtime was a big problem. Needed strategy to upgrade without downtime. Solution: Upgrade Sybase to latest version (ASE 16) and migrate to newest Linux platform. Benefits: Cost Savings, Increased Availability, Increased Stability, More Scalabillity. Business Challenge The airline industry is fast paced and relies on incredible computing power to maintain performance. This major US airline manages massive workloads on a 24/7 basis. The company had been operating Sybase ASE on Linux for years, but was in need of a system upgrade. In 2016, performance challenges and high overhead reinforced this need. The decision was made to upgrade to ASE 16 to improve high availability rates and system stability. In order to maintain services throughout the process, downtime needed to be minimized, so they needed help to devise a specialized upgrade strategy and implementation plan. Solution Their Director of IT knew the major challenge would be avoiding downtime throughout the process. They needed a Sybase expert to help plan and manage the project. The company’s team reached out to SAP so that they could identify the best person for this critical job. They were referred to Peter Dobler and his company, (more…)

Expanding the Market: MS SQL Server 2017 and Linux

By | Blog, Database Technology Trends, SQL Server
Microsoft’s exciting cross-platform product, SQL Server 2017, is poised to reach a whole new audience. Recently this industry leader has joined the growing trend of support for open source solutions.  Our team is continually investigating new innovations for our clients, and we wanted to share what we have discovered about new features and performance. Why Now? Linux is becoming increasingly popular thanks to its security, stability, and efficiency.  Its design protects against virus and malware attacks with a complex architecture and secure user account structure.  With more and more businesses choosing Linux, Microsoft realized they were forcing clients to manage multiple environments by keeping SQL Server only on Windows.  Rohan Kumar, then General Manager of Microsoft Database Systems, discussed the decision with Frederic Lardinois for Tech Crunch.  “We had a couple of discussions in the past where it wasn’t approved,” he told Lardinois, but four years ago his team recognized the value of expanding, so they pitched the idea once again. “The biggest surprising part was that we were expecting a whole lot of back and forth. It was really surprising to see how quickly the decisions got made,” recalls Kumar. How? With the company’s support in place, Kumar’s team needed (more…)

SAP ASE Edge Edition

By | Preserved Content Pages | No Comments
This might be the biggest announcement from SAP you never heard of. After dropping the name Sybase from its product names last year, SAP is quietly reshaping its database platform offerings. And I mean this in a good way. Under the Sybase name there were 2 ASE products; Sybase ASE Enterprise Edition (EE) and Sybase ASE Small Business Edition (SBE). The Sybase ASE EE product was and still is the flagship and the most commonly known edition of Sybase. But it came with a hefty price ticket. To offer a Sybase ASE database server to the SMB market space, Sybase created ASE SBE, limited to 2 CPU sockets and 8 engines on a physical server, at a very low price. The server virtualization revolution has dramatically changed the server landscape and database servers made their transitions to the new world. The majority of newly deployed database servers are virtualized, either on premise or in the cloud. The Sybase ASE EE 15.7 database server enabled Sybase clients to make the move to the virtual servers with the introduction of the threaded kernel model. SAP ASE EE 16 continued the optimization for virtual servers and offers one of the most advanced database (more…)

Creating Sybase IQ Connections to Sybase ASE to Import Data

By | Sybase Tips, Technology Tips & Tricks | No Comments

These Examples assume your using Linux (2.6.32-220.el6.x86_64 GNU/Linux) and Sybase IQ 15.4

Sybase IQ can create CIS connections to ASE, for example to access ASE data through an Sybase IQ-to-ASE proxy table.
This can be done in two ways: through JDBC and ODBC. JDBC is easier to set up, but ODBC tends to be significantly faster. In addition, the JDBC connectivity class has been deprecated (If you try to use CLASS ‘asejdbc’, You will receive a message box error via ISQL “asejdbc has been deprecated”)   in Sybase IQ 15.4 on Linux. Read More