Welcome to Sulekha IT Training.

Unlock your academic potential here.

“Let’s start the learning journey together”

Do you have a minute to answer few questions about your learning objective

We appreciate your interest, you will receive a call from course advisor shortly
* fields are mandatory

Verification code has been sent to your
Mobile Number: Change number

  • Please Enter valid OTP.
Resend OTP in Seconds Resend now
please fill the mandatory fields including otp.

Tips and Techniques to integrate SAP BO with HP Vertica

  • Link Copied

It is almost inevitable for the business world to move towards an era of Business Intelligence. Everywhere data and information are organized and analyzed for various kinds of logical analysis. In fact, the BI platforms have become an integral part of every business determined to progress and grow. SAP BO, being powerful BO business intelligence software satisfied the thirst of businesses by facilitating them to integrate and carry out excellent Business intelligence task in a single platform.  The SAP BO suite had become a high-end tool for businesses for viewing, sorting, analyzing and storing business intelligence data effectively. And the platform is extremely flexible that it even supports an integration of some necessary third-party products with its platform. There are several benefits the business could achieve by integrating third-party software with SAP BO. Here, in this blog, we’re going to discuss tips and techniques of integrating one such third-party software, HP Vertica.




Analytics with HP Vertica




HP Vertica is an advanced database analytics tool that is specialized to manipulate SQL databases. The software is excellently designed to suite analytics needs existing in Big Data technologies and synchronize with popular big data mediums. Whether it was an on-demand big data system or cloud big data systems like SAP BO or an open-source big data framework like Hadoop, HP Vertica is a perfect companion where its every line of code is written to perform faster and fluent.




Tips and Techniques while integrating with SAP BO




Following are the tips and best practices recommended by HP Vertica while integrating it with SAP Business Objects platform,




Choose the HP Vertica driver certified by SAP BO




SAP Business Objects have certified certain HP Vertica versions that are compatible with certain versions of Business Objects. The HP Vertica 6.1 and its later versions are certified for compatibility and these versions can be effectively integrated with SAP Business Objects 4.1 sp02 or later. The following table lists the HP Vertica versions with its compatible driver versions and its type.



















































Version of HP Vertica Tool




Driver Type




Driver Version




Support Type




6.1




JDBC Driver




HP Vertica 6.1 sp2




Direct




6.1




ODBC Driver




HP Vertica 6.01.02.00




Direct




7.0




JDBC Driver




HP Vertica 6.1 sp2




Compatible




7.0




ODBC Driver




HP Vertica 6.01.02.00




Compatible




7.1




JDBC Driver




HP Vertica 6.1 sp2




Compatible




7.1




ODBC Driver




HP Vertica 6.01.02.00




Compatible





Connectors for HP Vertica connection




SAP BO contains an exclusive metadata framework that enables the user to connect to the database contained in the HP Vertica platform. There are five ways to connect with the database. They are,







    • Connection using Out-of-the-box with HP Vertica configuration for SAP Business Objects 4.1 sp02







    • Connection using Out-of-the-box generic ODBC or JDBC drivers (Note: using ODBC driver is the most commonly used connection method.)







    • Connection with the help of Custom configuration









Interested in learning more tips and techniques about SAP BO? Planning to create a career with SAP BO platform? Get free course-counseling here…


Take the next step toward your professional goals

Talk to Training Provider

Don't hesitate to talk to the course advisor right now

Take the next step towards your professional goals in SAP BO

Don't hesitate to talk with our course advisor right now

Receive a call

Contact Now

Make a call

+1-732-338-7323

Enroll for the next batch

Related blogs on SAP BO to learn more

Latest blogs on technology to explore

X

Take the next step towards your professional goals

Contact now