Create a Data Foundation (UNX) on a SAP HANA


Using SAP BusinessObjects BI Clients for SAP HANA



Creating the JDBC connection to the SAP In-Memory Database



To set up the JDBC connection to the IMDB:
1. Copy the ngdbc.jar in the appropriate folder under …/dataAccess/ConnectionServer/jd
bc/drivers/newdb
If this directory structure does not exist, you need to create this directory structure under ../dataAc
cess/connectionSrever/jdbc and then drop the jdbc jar file under this directory.
2. Launch the SAP BusinessObjects information design tool.
3. Create a new local project.
4. In this project, create a new Relational Connection.
5. Name it.
6. Select JDBC Drives as the data source.
7. Enter DB credentials and test.
8. Choose Finish.


Note:
for Explorer, you can also create a native connection from the IMDB to the Explorer application, by
configuring the Explorer application settings in the SAP BusinessObjects Central Management Console
(CMC). When this type of native connection is used for Explorer, a UNX file is not necessary.




Creating a Data Foundation (UNX file)
This procedure is not necessary if you want to use Explorer using a native connection (described below).

To create a Data Foundation on a SAP HANA data source:
1. Launch the information design tool.
2. In your local project, create a new Data Foundation.
3. Name it.
4. For now select Single Source.
5. Select the data source you just created.
6. Finally, choose Finish to create.


See also:

Universe on SAP HANA


Integrating SAP HANA with SAP Business Objects

Comments

  1. SAP HANA Online TrainingNovember 14, 2012 at 9:20 PM

    this is very analysis system for SAP HANA interdiction part. I am very happy about this article thank you. and one more thing for best sSAP HANA online and Class room Training at Arrowsol Training Institute provide SAP HANA
    please contact at info@arrowsoltraining.com

    ReplyDelete
  2. UnknownDecember 20, 2013 at 2:58 AM

    The information that you provided is great. I will recommend you site for freshers and starters, they will get brief information on hana. I am an sap hana professional and I give sap hana online training .there is plenty more that is covered by a sap training module. You could even choose areas of specialization depending on your requirement. Please make updates regularly

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo
Read more

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innovations in software has now made it possible for SAP to deliver on its vision of the
Read more

SAP BusinessObjects 4.0 - Suite Presentation

Image
The latest Business Objects Suite, B.O. 4.0,  is suitable for every kind of user from top managers to simple clerk. It has a new  styling and unified look and feel in every tool of the suite. It garantees common query design experience across all data sources. It allows interactivity with shared charting, alerting, and search options. B.O. 4.0  has a new information design tool for heterogeneous access over all sources that represents  abstraction layer for multi-dimensional data sources. Beside it allows: A simplified, Right-Scale Deployment Enhanced scalability with virtualization and native 64-bit support Comprehensive system diagnosis and monitoring New auditing for compliance and usage analysis. New User Experience SAP BusinessObjects Mobile BI  Interactive Reports & Dashboards Allows to: Make informed decisions with instant access to personalized information Leverage existing BI investments & skills to quickly reach mobile users E
Read more