1 2 3 Previous Next

Database

44 Posts

Date: January 29, 2014

Time: 1:00 p.m. EST/10:00 a.m. PST

 

Featured Speakers:

Paul Medaille

Director, Solutions Management, Enterprise Information Management, SAP

 

Ina Felsheim

Director, Solutions Management, Enterprise Information Management, SAP

 

Many companies have invested heavily in mission-critical business software initiatives. Yet too often these worthy but expensive initiatives fail to deliver anticipated benefits because of poor data. What’s needed is an integrated software solution that improves collaboration between data analysts and data stewards with the tools for understanding and analyzing the trustworthiness of enterprise information.

 

SAP Information Steward software provides continuous insight into the quality of your data, giving you the power to improve the effectiveness of your operational, analytical, and governance initiatives.

 

Join us on Wednesday, January 29, 2014, for an insightful Webinar, Gain Data Quality Insights with SAP Information Steward, to learn how this SAP solution can help your organization:

  • Analyze, monitor, and report on the quality of your data
  • Adopt one solution for data stewardship
  • Create a collaborative environment for your IT and business users
  • Turn data quality into a competitive advantage

 

Don't miss this webinar event!

 

REGISTER TODAY

Logo


TECHCAST  — SAP Sybase Replication Server: Future and Roadmap

December 11, 2013  1pm EDT / 10am PDT


Register now!

 

Join our next ISUG-TECHcast as guest Speaker Chris Brown joins us for an informative discussion about the future and roadmap of SAP Sybase Replication Server.

 

We’ll discuss how the latest version of SAP Sybase Replication Server replicates transactional data for non-SAP applications in real time directly into SAP HANA – without slowing or disrupting the systems that are running the business – to create a real-time analytics solution. And you’ll learn about new high availability and disaster recovery functionality for customers running SAP Business Suite on SAP Sybase ASE to ensure continuous availability during planned and unplanned downtime.

 

Learn about these new capabilities and functionalities, including:

  • Storage optimization
  • Operational scalability capabilities
  • Performance enhancements for handling very large data volumes
  • Latency monitoring and alerting capabilities as part of an essential, value-added solution
Emma Capron

Going to extremes

Posted by Emma Capron Nov 4, 2013

In today's ultracompetitive business environments, it is critical to have the ability to collect, store, manage, protect, query, and generate reports from larger and larger volumes of complex data. From retail stores to hospital emergency rooms, immediate access to accurate, relevant data is a basic business requirement.

 

To create and sustain a competitive advantage in the face of exponential data growth and increasing customer expectations for superior service, your data management system must deliver extremely high performance, unconstrained scalability, rich functionality, bulletproof security, and cost-effectiveness.

 

For more than 30,000 customers around the world, the solution is SAP Sybase Adaptive Server Enterprise (ASE).1

 

For example, Globe Telecom in the Philippines turned their business upside down with the help of SAP Sybase ASE. They replaced industry-standard calling cards with air-loading, enabling them to build a data management infrastructure that lets them market aggressively and closely manage costs. Rodell Garcia, CIO, explains why: “In terms of ROI, our SAP Sybase ASE system is a critical enabler of revenue generation; the payback period is certainly very short.”2

 

Meanwhile, electronic medical records specialist, MIQS, used SAP Sybase ASE to present doctors with the critical combination of information they need when treating kidney dialysis patients. The result was a 40% reduction in mortality rates.2

 

Finally, India is famous for its huge railway network, but also for its congested stations, as passengers queue to buy tickets for trains departing the same day. Working with SAP technology, Indian Railways and the Center for Railway Information Systems built a ticketing system so passengers without reservations can buy tickets at any station, at any time, from dedicated terminals and automatic machines. The result is no more long queues – and lots of valuable data for the company to analyze and act on.2

 

You can learn more at www.sap.com/realtime_data/transactional_data. Or join the conversation #redefinedata

 

1Video: Top 5 Reasons to Choose SAP Sybase Adaptive Server Enterprise

2Customer ebook: Going to Extremes

In its first Magic Quadrant for Operational Database Management Systems[1], Gartner has positioned SAP operational databases – SAP HANA, SAP Sybase ASE, and SAP Sybase SQL Anywhere – in the Leaders quadrant!

According to Gartner, the Leaders quadrant contains the vendors that demonstrate the greatest degree of support for a broad range of operational applications based on a broad range of data types and large numbers of concurrent users. These vendors have the greatest longevity in the market have built a wide partner ecosystem for their products. Consequently, the Leaders generally have the lowest risk for their customers in the areas of performance, scalability, reliability and support. And as market demands change, the Leaders generally demonstrate strong vision in support of not only the needs of the current market but also of new and emerging trends. Indeed, in completeness of vision, SAP was rated higher than Microsoft and IBM for its ability to understand the functional requirements needed to support transactional environments, develop a product strategy that meets the market’s requirements, comprehend overall market trends and influence or lead the market when necessary.

Gartner cited the following strengths for the SAP portfolio of products:

  • Vision leadership — Moving into DBMS technology, SAP has introduced SAP HANA as an in-memory platform for hybrid transaction/analytical processing (HTAP) and acquired Sybase to add to the DBMS product line.
  • Strong DBMS offerings — In addition to SAP HANA, SAP Sybase ASE continues to support global-scale applications and was first to introduce an in-memory DBMS (IMDBMS) version.
  • Performance — References cited performance (scalability and reliability) as a major strength (one of the highest scores reported), mostly for SAP Sybase ASE.

 

Learn about the evaluation criteria and how other vendors fared, read the full Gartner MQ here: http://www.gartner.com/technology/reprints.do?id=1-1MNA5V2&ct=131105&st=sb

   GARTNER 2013 Operational DBMS Magic Quadrant_graphic.pptx.png

Figure 1: Magic Quadrant for Operational Database Management Systems*

 

* This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available at http://www.gartner.com/technology/reprints.do?id=1-1MNA5V2&ct=131105&st=sb Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

 


[1] Gartner, Magic Quadrant for Operational Database Management Systems by Donald Feinberg, Merv Adrian and Nick Heudecker, October 21, 2013.

During TechEd Las Vegas last week, two SAP partners with expertise in SAP Sybase ASE and SAP HANA discussed the value of running SAP databases. Oxya has completed several Oracle to SAP Sybase ASE on SAP Business Suite migrations over the last 18 months and described the migration process as straightforward, even easy. Migrations were typically accomplished over a 2-3 month project and Oxya’s customers have benefited from much lower licensing, maintenance, and administrative costs, sometimes achieving ROI much earlier than expected.

 

Beyond Technologies, a partner and SAP Mentor, described how business transformations can be achieved with SAP Business Suite on SAP HANA. It expects that many innovations in the functionality of SAP Business Suite will result by leveraging SAP HANA technology.

 

Watch the full discussion here: http://events.sap.com/teched/en/session/8465

Provide Continuous, Real-Time Data to SAP Data Services with for Smarter, More Accurate Business Intelligence

Join us for a Webcast on November 7, 2013, to learn how SAP Sybase Replication Server, change data capture edition, now supports SAP Data Services for real-time data updates to your data warehouse.

 

To seize opportunities and gain a competitive edge in today’s 24/7 world, you need to know what’s going on in your business in the moment—not two hours ago.

 

With SAP Sybase Replication Server, change data capture edition, now providing continuous, up-to-the-second data combined with complex data extractions, transformation, and data quality capabilities from SAP Data Services, you can create a data warehouse that supports more accurate and actionable business intelligence than ever before.


Learn how real-time change data capture from SAP Sybase Replication Server, supports smarter, timelier decision making during our Webcast on Tuesday, November 7, 2013 at 2:00 p.m. EDT.

 

We’ll show you how SAP Sybase Replication Server, change data capture edition delivers: a 360-degree view of your business in real time.

Any data - Get real-time data from all your databases (Oracle, SAP Sybase Adaptive Server Enterprise, IBM DB2, and Microsoft SQL Server), including unstructured data, through SAP Data Services into your choice of data warehouse platform.

Anywhere - SAP Sybase Replication Server delivers data from anywhere—regardless of distance—over existing networks.

Anytime - Data changes are continuously captured from all databases and loaded in real time to SAP Data Services, significantly lowering the total cost of ownership (TCO) by reducing manual IT resource requirements.


Take advantage of this opportunity to learn how your organization can build a better data warehouse solution to provide better business intelligence than ever before. We hope to see you online!

 

REGISTER HERE

pastedImage_5.jpg

Is your SAP application environment built on an inflexible legacy architecture that is complex to manage and expensive to maintain? Would you like to free up IT resources to focus on driving new business objectives instead?

 

Join us for this special webinar to learn how deploying a database optimized for SAP applications on a high-performance converged infrastructure platform can simplify management and maintenance, increase agility and resource utilization, and scale seamlessly as your needs grow. And you can test your new solution before you migrate to make sure performance and functionality requirements are met, and then migrate without disrupting business operations.

 

Transform your SAP application environment with a modern approach - we’ll show you how.

 

REGISTER HERE

Date: Wednesday, October 30, 2013 at 2pm EDT

 

To seize opportunities and gain a competitive edge in today’s 24/7 world, you need to know what’s going on in your business in the moment – not two hours ago.


With SAP Sybase Replication Server now providing up-to-the-second data from any transactional system to SAP HANA for enterprise-wide analysis, you gain the data management power necessary to glean insights when they matter most.


Learn how SAP Sybase Replication Server provides up-to-the-second, continuous data for smarter, timelier decision making during our Webcast on Wednesday, October 16, 2013.


We’ll show you how SAP Sybase Replication Server delivers:

  • Any data – Get real-time replication from all your databases into SAP HANA, including Oracle, SAP Sybase Adaptive Server Enterprise, IBM DB2, Microsoft SQL Server, and unstructured data.
  • Anywhere - Real-time transactional replication delivers data from anywhere – regardless of distance – over existing networks.
  • Anytime – Data is continuously loaded in real time.

 

Take advantage of this opportunity to learn how your organization can build a better real-time analytics solution. Register Today for our upcoming Webcast for an inside look.

 

REGISTER HERE

Winnie Li

EDW Webinar Series

Posted by Winnie Li Sep 10, 2013

Big data represents a significant paradigm shift in today’s enterprise technology. Big data has fundamentally changed the nature of data management, introducing new challenges with the volume, velocity and variety of corporate data. This change is driving organizations to adjust their enterprise data warehousing technologies and strategies in order to turn the massive amounts of data into valuable and actionable information. Big data enables companies to gain new insight into business opportunities, transforming enterprises for the new real-time world.

Join us in this webinar series as we discuss how to implement data management strategies for a Big Data-enabled Enterprise Data Warehouse.

  • Session One: Enabling a Big Data-enabled EDW with SAP’s Data Management
    October 15th 12:00PM -1:00 PM (ET)
    Presented by: Tom Traubitz, Director Product Marketing
           

SAP understands the importance of Big Data but we also understand that you can’t take of advantage of it without a data-management platform to help find relevancies within your data to turn them into business processes - essentially turning your big data into a key enterprise asset. See how by tying together your organization’s data assets – from operational data to external feeds and Big Data – SAP dramatically simplifies data management landscapes for both current and next-generation business applications, delivering information at unprecedented speeds and empowering a Big Data-enabled Enterprise Data Warehouse.

Register HERE

  • Session Two: Integrating Hadoop with SAP HANA and SAP Sybase IQ
    November 12th 12:00PM -1:00 PM (ET)
    Presented by: Courtney Claussen, Director Product Management

SAP recognizes that not all data in your enterprise will exist in your SAP data warehouse, and that there are also different processing environments for handling big data that the SAP data-management platform needs to interact with. In this session learn how to utilize Big Data for interesting insights into your business, using the SAP data platform and Hadoop.  We will show how these solutions have been engineered to work together through data federation and data integration methods for a Big Data-enabled enterprise data warehouse.

Register HERE

  • Session Three: Integrating Data Streams into your Big Data Architecture
    December 12th 12:00PM -1:00 PM (ET)
    Presented by Jeff Wooton, Product Management

Increasingly, data sources are able to deliver data in real-time. How do you collect data that is arriving continuously at very high speeds, and in a way that it is most useful? Even more importantly, how can you extract insight from that data and respond as things happen, rather than only being able to respond much later, once you’ve had a chance to analyze the historical data?  See how event stream processing adds critical capabilities to your big data architecture.

Register HERE

272261_l_srgb_s_gl.jpg

Join us for the “SAP Sybase Replication Server Technical Workshop” on Thursday, October 3, 2013 to learn about new options and features for existing SAP Sybase Replication Server customers. We’ll show you how the new version of SAP Sybase Replication Server replicates transactional data for non-SAP applications in real time, directly into SAP HANA– without slowing or disrupting the systems that are running the business – to create a real-time analytics solution.


New for SAP Sybase Replication Server – we now offer support for:

  • Real-time transactional replication into SAP HANA for non-SAP applications
  • Real-time change data capture (CDC) for SAP Data Services
  • Disaster recovery for SAP Business Suite applications running on SAP Sybase Adaptive Server Enterprise (SAP Sybase ASE) including:
    • Multiple replication agents from a single SAP Sybase ASE database
    • Direct load capability for subscription creation reducing or eliminating bulk materialization
    • Replication definition elimination for standby (Web services or multi-site availability) environments
  • Plus, great new features for current customers!

 

And for customers running SAP Business Suite on SAP Sybase ASE, we now have a solution that reduces both planned and unplanned downtime using SAP Sybase Replication Server.


To find out more, Register today and join us in New York!


Don’t forget to follow us on Twitter @SAPNorthAmerica for updates around events!

A question I get with some regularity is this: does the SAP Sybase ASE In-Memory database (IMDB) do the same thing as SAP HANA?
A formal answer is "yes": they both use RAM to deliver better  performance.

However, the more practical answer is "no" since the goals these databases are trying to achieve by optimal use of memory, are quite different.

 

Let me explain.

 

It is well known that SAP HANA is an in-memory database (if this is news to you, I recommend going to www.saphana.com and start reading). Independently, Sybase ASE has supported an "in-memory database" (IMDB) feature since the release of ASE version 15.5 in 2009. The striking similarity here is the use of the words "in-memory" in both cases, which may suggest that these databases are identical. However, they are not.

 

First, SAP HANA is entirely based on the notion of caching all data in main memory. Combined with its columnar compression this allows very large databases to be fully cached. In addition, HANA is optimized for a particular family of Intel processors, which gives it these lightning-fast response times we have all witnessed. Due to its ability to access large amounts of memory very rapidly, HANA can dramatically accelerate response times for read operations and aggregations (e.g. SELECT statements), which are the most common types of workload in an analytics environment.

 

SAP Sybase ASE's IMDB feature can also be used to fully cache ASE databases in main memory (of the multiple ASE databases in an ASE server you can choose to cache one or more as you like, and as your available memory permits). However, ASE IMDB was designed to speed up throughput of concurrent transactional OLTP workload (see this whitepaper for more background), which works best on an uncompressed row-oriented storage model.  ASE IMDB never aimed to speed up the performance or response time of read operations (e.g. SELECT statements), and no improvements should be expected here.

 

In fact, it is unlikely that better performance will be observed for a single ASE user doing a transaction in an ASE IMDB. The ASE IMDB starts to pay off when multiple users are busy doing small OLTP database transactions concurrently. Technically, this works by cutting some corners in the area of the ASE transaction log: since an ASE IMDB database is not recovered after an ASE shutdown, this knowledge can be used to provide faster concurrent transactional performance and better scalability. Depending on the workload profile, improvements of up to a factor 5-6 have been measured, compared to a classic ASE database (see here for more details).

 

This also brings us to the price you pay for the improved transactional performance in the ASE IMDB (apart from spending the money to buy the ASE IMDB license option): transactions in an ASE IMDB database are not 'durable' (i.e. we lose the 'D' in 'ACID'), since nothing is ever written to disk for an ASE IMDB (transactions in SAP HANA are fully ACID).
At the same time, this allowed the ASE engineers to further streamline ASE's already advanced buffer management algorithms (like relaxing the strict MRU-LRU chain). It also paved the way for implementing various novel low-level transaction logging optimizations (technical details are described here, should you be interested).

 

I have not yet mentioned the most attractive aspect  of the ASE IMDB – namely, that it is easy to use in an existing system. To an application, there is no difference between a SQL executed in ASE IMDB database or in a classic  ASE database. In-memory features from competing database vendors (like Oracle's TimesTen) could (and can) not offer such application transparency.

 

Lastly, in case you'd ask: ASE's #1 SD Benchmark results for 2-, 4- and 8-socket configurations on Intel/Linux do no utilize  the ASE IMDB feature. As a result of the non-durable transactions that are implied, the ASE IMDB feature is not supported with SAP Business Suite.

273668_l_srgb_s_gl.jpg

@Computerworld tech experts and enthusiasts state that large enterprise data volume will increase by 60% in 2013. Learn how to leverage this real-time data as SAP partners with TDWI at the “Insight at Light Speed: A Vision for Seamless Provision of Real-Time Information” thought leadership series.

 

Join us for six briefings packed with actionable solutions for big data and algorithmic analysis. You can enjoy a complimentary hot buffet breakfast with peers as we explore information delivery to your employees and customers, in real time.

 

You will learn about:

  • Historical aspects of data warehousing that have bifurcated the information environment
  • The growing community of business intelligence and analytics users
  • How big data and algorithmic analysis are changing the game
  • How to eliminate data fragmentation
  • Delivering real-time data that is synchronized and consistent
  • Leveraging in-memory computing and high-performance analytical architectures
  • Instituting the right amount of data governance

 

Take a peak to view details in a city near you!

 

Locations:

 

4/2 – San Francisco, CA

4/4 – New York City, NY

4/9 – Washington DC

4/17 – Chicago, IL

4/18 – Toronto, ON
4/23 – Raleigh, NC

 

Don’t forget to follow us on Twitter @SAPNorthAmerica for updates around the event!

Are You Ready to Take Your Architecture Efforts to the Next Level?

 

Join us on March 26, 2013, for a Webcast on the features and benefits of SAP Sybase PowerDesigner

 

274697_l_srgb_s_gl.jpg

 

Register Now

 

SAP Sybase PowerDesigner software can help you eliminate information silos and understand the impact of change before it happens. This powerful modeling tool for data, information, and enterprise architecture offers stakeholders access to key information assets to enhance business agility through better communication and data governance.

Please join us on Tuesday, March 26, 2013, for a presentation and demonstration of the most recent release of SAP Sybase PowerDesigner. During the Webcast, Matt Creason, director of Global Enterprise Information Management and Architecture at SAP, and David Dichmann, product manager at SAP, will explore:

  • New what-you-see-is-what-you-get (WYSIWYG) reporting that makes using SAP Sybase PowerDesigner intuitive and easy
  • A new Extensible Markup Language (XML) generic import for getting metadata anywhere, anytime
  • Updated XML modeling for improved messaging and message format definitions
  • New workflow change management for better team collaboration
  • Business Process Modeling Notation (BPMN) XML import/export for business process model exchange, including support for SAP NetWeaver Business Process Management (SAP NetWeaver BPM)
  • Direct integration with SAP HANA repository to improve easier deployment of your SAP HANA platform and include SAP HANA as part of your enterprise landscape
  • Using SAP BusinessObjects BW Universe Builder to support accurate analytics initiatives

 

Webcast: Take your Architecture Efforts to the next level with SAP Sybase PowerDesigner

Date:
March 26, 2013

Time:
1:00 p.m. EDT

Speakers:
Matt Creason
Director, Global Enterprise Information Management and Architecture
SAP

David Dichmann
Product Manager
SAP

 

Register Now

 

 

 

 

Did you know SAP attended the TDWI conference last week, Thursday 18th to 20th? And that the new release of Sybase IQ was launched throughout the event? I want to travel back in time with you today and show you some impressions from the show floor.

 

The show started for us with the BI Executive reception on Monday evening. We had a table set up to show the concept behind SAP's database strategy, how Sybase IQ and HANA play together and what people can expect with the new release of Sybase IQ.

 

IMG_0453.JPGIMG_0451.JPG

 

On the first official day of the conference, there was a lot of booth traffic from people walking by and listening to our sessions. The HANA pod and presentation was full with many interested attendees. The HANA Academy.

 

IMG_0498.JPGIMG_0487.JPG

 

One of the highlights for me was an executive speaking panel, lead by Philip Russom. The key question was: How do I select the right technology to fit my company's data strategy? Dan Lahl from SAP highlighted several customer use-cases, which helped to understand the issues customers really want to solve as part of their data strategy.

 

Top Tweets from the panel:

  • @eric_kavanagh: Dan Lahl, SAP » Could #HANA change the way companies manage data? Well, yes! @SAP http://t.co/0FZ7gHfrCB #SybaseIQ
  • @BIReporting: SAP Sybase IQ 16 Helps Enterprises Reveal Big Data Insights #BI http://t.co/7qmQMwH1Cw
  • @sDataManagement: @BILeadership: @SybaseIQ pushing "Real-time Data Platform" that combines DBMS assets of Sybase and SAP. One platform, multiple capabilities. @jcjaks @TDWI
  • @BigDataGeeks: SAP goes extreme in Big Data Insights - SAP Sybase IQ 16 Delivers Unprecedented Power & Insight at the Rt. Price http://t.co/QiMBVyDP #TDWI
  • @prussom: Up next at #TDWI = panel of vendor reps from @IBM, @SAP, @Teradata & @Vitra talkin bout fitting tech to data strategy.

 

 

In addition, I was lucky to catch David Parker, Vice President for Database & Technology at SAP, in front of the camera. He did a great job explaining what's new with Sybase IQ.


 

As a little extra, we gave away Sybase IQ hats to conference attendees.

IMG_0468.JPG

 

Bill Rojas and Philip On from the Information Management Team explained Information Steward to attendees in a very comprehensive way. It is a key tool to clean-up data within a company and improve its quality. It is a great tool and I had fun learning more about it while listening to demos.

 

IMG_0496.JPG

 

If you want to know more about the new Sybase release, read the official press release.

 

For news related to database & technology innovation, follow @SAPDataTech.

I went to a Hadoop Users Group meeting in the Valley recently and got into a long and interesting discussion with a Hadoop contributor about what it means to be an enterprise app developer (at least from a big picture perspective) with the rapid growth of Big Data, and widespread adoption of Cloud Computing and other technology trends. One of the things we spent quite a bit of time on is discussing the implications of "moving app to the data" vs "moving data to the app" as defined by the current enterprise software development paradigms.

 

Our discussion got me thinking about what a data application platform is and the current state. Since SAP announced the availability of its Flagship Business Suite on HANA couple of weeks ago, I've been doing some research and hope to share my learnings and thoughts via a series of blogs on the data platform topic in the coming days/weeks.

 

For starters:

 

  • Rapid development and adoption of Hadoop-based solution ecosystem is enabling this "app-to-data" transition. See attached image below from The Register. Hadoop has come long way in 6 years from an Apache project to an enterprise-scale Big Data solution.
  • This new development paradigm will finally break the data processing bottlenecks in a typical enterprise by freeing app developers to develop many "micro" apps that process/present data in various ways with direct access to data. Think iphone apps vs traditional, menu/navigation driven enterprise apps!
  • Convergence of Cloud, Big Data, Mobility trends with rise of "hacking" development culture will lead to many new types of apps, frameworks, and a lot of rip-and-replacing of apps (esp. in the early stages when software doesn't work as expected and since licensing costs for these new pieces of software is low-to-zero). H/T to Krishnan Subramaniam for his excellent insights on this convergence of these trends. Image below are screengrabs from his slideshare presentation.
  • Implementing and Developing Hadoop-based applications requires an understanding of Java, using Javascript, knowledge of MapReduce, etc. putting it beyond the capabilities of a typical data scientist/programmer. However, there are companies such as Continuuity and other major vendors that are developing integrated dev tools and packages that reduce the complexity. These are still in early stages but the general trend is very encouraging.
  • Thanks to the sharing culture, there are many great examples of building enterprise-scale apps and data marts using Hadoop.

 

More in the next blog..

 

http://regmedia.co.uk/2011/11/09/hadoop_kernel_distro.jpg

Screen Shot 2013-01-29 at 3.50.46 PM.jpg

Actions

Filter Blog

By author: By date:
By tag: