Setting up SAP BW Near-Line Storage with SAP Sybase IQ

It feels strange for me to make a post in the SAP BW section as I feel horribly un-qualified to do this.

Below is a video that Ethan Jewett and I co-created as part of the Diversified Semantic Layer video podcast series, The Visible Layer.

What we did was use the new and now native NLS functionality in BW 7.3 SP9 to archive data off into SAP Sybase IQ. This is something that I have been talking about for years (see this blog post dated 12 months ago) as I have had exposure to the PBS NLS add-on from my Sybase background.

You will be glad to know that the results were simply awesome and I feel that by implementing NLS now as part of your BW strategy could benefit customers in a few ways, namely:

  1. Get the immediate performance benefit of using SAP Sybase IQ ( ** spoiler alert ** SAP Sybase IQ was +- 300 % faster off the DSO level compared to BW running off an InfoCube)
  2. Shrink the size of the database under-lying your BW environment. This has many benefits:
    1. Smaller environment to query on = better performance
    2. Smaller environment to back up
    3. Etc etc
  3. Get customers ready for HANA and know that you have a seamless and slick archiving solution in place with no performance trade-offs. This also means that you do not have to panic about your HANA environment running away from you.

I would love to hear everyone’s thoughts/opinions on this and I hope I got all the BW terminology correct

Get the popcorn ready and enjoy the video!

Clint Vosloo

here and includes links to lots of other resources.The PDF that we referenced in the video, which includes pretty much all the (relatively minor) installation steps is here (click on the “View this document” button).

(Cross posted on SCNhere)

Example Deployment of an SAP Analytic Bundle Episode 2

I recently blogged and shared a video walkthrough of deploying an SAP Analytic Content Bundle, covering the Insurance vertical. If you haven’t had a chance to read it yet, you can take a look here. In that video, I promised to record a second episode which covered the Telco Analytic Content, which was more in-depth and based on an SAP PowerDesigner model.

Well, here for your viewing pleasure, is Episode 2 – Telco & Utilities Analytic Content.

The steps I undertook before the video were:

  • Install a trial of PowerDesigner (available here)
  • Install a trial Sybase IQ (available here)
  • Download the Telco Analytic Content (available here)

As a reminder, these Analytic Content bundles are pre-built industry content are free, and provide an excellent starting platform as a data warehouse.  Let me know what you think of the Analytic Content bundles in the comments, and any feedback on the video.

Big Data HANA vs. IQ

It is not easy to NOT lean hard on SAP HANA and its capabilities with big data, but we do our best to put together the puzzle of where HANA and IQ fit in the SAP database landscape.  Join our special guests Vijay Vijayasanka and Clint Vosloo as we discuss the finer points of SAP HANA and Sybase IQ and try to drive out where the better fit is for business analytics customers today.

Feel free to stop by iTunes to subscribe, or go for a direct download.

Play it now:

Clint Vosloo

Josh Fletcher took the opportunity to have a chat with new SAP Mentor Clint Vosloo, fresh from SAPPHIRE 2012.

Feel free to stop by iTunes to subscribe, or go for a direct download.

 

Play it now: