OLAP Connection Middleware: Select SAP › SAP HANA INA as OLAP middleware driver. You can read from the following types of SAP HANA database modelling views:For more information on SAP HANA database users, see Managing SAP HANA Database Users in the SAP HANA Cloud, SAP HANA Database Administration Guide. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it. It is still possible to use the old approach to DirectQuery over SAP HANA. 4 (i. Select SAP>SAP HANA database 2. SAP HANA combines the benefits of an OLTP and an OLAP database in one database. The SAP HANA Cloud, data lake helps further extend data capacity with managed access. NET Connector 3. 1 version, skip to Step 2B. Select the relational object or objects you want to import. This site uses cookies and related technologies, as described in our privacy statement , for purposes that may include site operation, analytics, enhanced user experience, or advertising. Just updated Client BI 4. You can create a direct connection to SAP HANA using JDBC or ODBC drivers. The SAP HANA database CREATE VIRTUAL TALBE. Labels: Labels: Need Help; Message 1 of 6 9,049 Views 2 Reply. SAP BI support many. " I only see "Treat SAP HANA as a relational source. This. Now Power BI visuals can fall back to a previous version compatible with the current version of the server API (if available). With SAP haha connector, power bi will treat SAP HANA as a multi-dimensional source or relational source in direct query mode. How many ways you can update a relational source definition? Depending upon the changes, we can update a relational source definition in 2 ways :Our new SAP HANA database monitoring extension allows you to: Easily understand the health and performance of your HANA databases. Set the type of authentication to use when users create new workspaces or log on to existing workspaces. All new connections to SAP HANA use this connection method by default, treating SAP HANA as a multi-dimensional source. 4. When visuals are created in Power BI, the aggregate data will always be retrieved on the fly from SAP HANA. csv file from this GitHub repository. This option pulls data from SAP HANA database to. Create a relational container in the data lake Relational Engine container group. Authentication type. Then click Connect. Open a SQL console to the HANA DB instance and create the following table. 0. I start Webi and try to create a new report based on "SAP HANA" data source. If that doesn't suit you, our users have ranked more than 25 alternatives to SAP HANA and many of them are available for Windows so hopefully you. WITH REMOTE statement supports transactional DDL. ini. Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. hdbsql is a text-based tool that can be used to query an SAP HANA database. Entity Framework Core is a modern object-database mapper for . It needs less disk space than some of its competitors and is highly scalable. SQL Query Override. This site uses cookies and related technologies, as described in our privacy statement , for purposes that may include site operation, analytics, enhanced user experience, or advertising. 391861. It includes the relational container structure and all SAP HANA database virtual tables and data lake Relational Engine tables that are stored and managed on behalf of SAP HANA database. CREATE DATABASE SCOPED CREDENTIAL sql_creds. In this role, it can serve as either the data provider for classical transactional applications. Starts replicating data between the services in the source tenant database. 1/5 stars with 451 reviews. This article aims to provide a video demonstration of how to: Connect to an SAP HANA database using ODBC drivers. SAP HANA is an in-memory, column-oriented, relational database management system. I am using Implementation 2. Elastically in an HTAP (hybrid transactional analytical platform) environment. They expand the SAP HANA platform with native support for hierarchy attribute calculation and navigation, and allow the execution of typical hierarchy operations directly on relational data, seamlessly integrated into the SQL query. NOTE: IDENTITY and SECRET correspond with the User and Password properties for SQL Server. Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. SAP HANA is a column-oriented, in-memory relational database that combines OLAP and OLTP operations into a single system. SAP HANA Cloud, Data Lake Administration Guide for Data Lake Relational Engine (SAP HANA DB-Managed) QRC 2/2023. Description. The Cloud Pak for Data JDBC Driver is available from the Maven repository. For more about SAP HANA relational source, please refer to: Treat SAP HANA as a relational source . That means HANA cloud is delivering scalability, flexibility and can also connect to data everywhere without need to replicate those data. SAP HANA is deployable on premises, in a public or private cloud, and in hybrid scenarios. outline the SAP HANA data platform capabilities according to the criteria volume, velocity, and variety. SAP HANA uses the ODBC connection. The SAP HANA connection requires a JAR file. Alternatively, we can also load this same parquet data into the HANA Cloud data lake relational engine. java:232)For the second issue, you can define variables on SAP HANA side, then you can enter desired values for these variables on Power BI side to filter data. A relational connection establishes when the user needs to access conventional data tables. Below a sample of how we can use Python + Diagrams with the SAP BTP icons to create your architecture diagrams. The idea behind this best practice approach is to push data processing to the data source server while working with a Power BI Report. Select New > Relational Connection in order to insert a new connection in your local project. Care must be taken with this approach to ensure that measures are aggregated as expected, and to avoid performance issues. Available Versions: QRC 3/2023 ; QRC 2/2023 ; This document. Adapters are made available by SAP HANA smart data access and SAP HANA smart data integration. CREATE VIRTUAL TABLE SYSHDL_CONTAINER1. Edges are always directed and there can be two or more edges connecting the same two vertices. Would this be because I have an old version of Power BI desktop? I currently use "2. at com. BI Experts, With BI 7. SAP HANA Is an RDBSM (Relational Database Management System) Databases store data about products, customers, orders and other aspects of business operations for use in transaction processing and analytics applications. I have synced data from SAP HANA database into a table. SAP HANA Cloud provides data virtualization – federation, caching and meta-data and persistence – in-memory, disk and relational data lake. When SAP first introduced the idea of the in-memory database SAP HANA in 2010, skeptics dismissed the idea as a “complete fantasy. NET Connector 3. HANA version (under HANA Studio) is 1. Working with SAP HANA Database Sources. SAP HANA uses the ODBC connection. Considerations: Attention must be paid to any further aggregation performed in visuals, whenever the measure in SAP HANA is non-additive (for example not a sum, min, or max)We want to manage permissions using our Microsoft 365 accounts, so I was expecting to be able to create Dataflows/Datamart in Power BI Web that connects to our SAP HANA source using DirectQuery, and manage permissions on those. 1 ACCEPTED. It’s based on on-premise SAP IQ and has been referred to as SAP HANA Cloud, data lake IQ. 1. Option 2:. It was commonly referred to as SAP HANA Cloud Relational Data Lake around the time of its inception but I’ve noticed that the term “Relational” has since been dropped – or at least much rarely encountered. Some tasks are performed at system level. Password: (Password you specified when you changed the default SYSTEM password) Ensure you click Multi server option. As the official document mentioned, we can connect to SAP HANA data sources directly using DirectQuery. Step 1 Connect from SAP HANA, express edition to SAP HANA Cloud database Step 2 Connect from SAP HANA Cloud to SAP HANA Cloud, data lake Relational Engine Step. SAP HANA alternatives are mainly Relational Databases but may also be Business Intelligence Tools or Cloud Computing Services. Of course if you want to operationalize this, you have to setup a Power BI gateway with current credentials (SSO) specified in the data source setting in Power BI. It does not work with any Cube I tested. The underlying system table for this view is ISYSSOURCE. {"payload":{"allShortcutsEnabled":false,"fileTree":{"powerbi-docs/connect-data":{"items":[{"name":"media","path":"powerbi-docs/connect-data/media","contentType. Updated: November 2023. 00. SAP HANA authorization is the process of granting access privileges to users using the SAP HANA database. Under Authentication by database user, enter: User Name: SYSTEM. Best Regards, Link . This site uses cookies and related technologies, as described in our privacy statement , for purposes that may include site operation, analytics, enhanced user experience, or advertising. In order to over come these two problems SAP HANA contains a third component Max DB database. Other great sites and apps similar to SAP HANA are PostgreSQL, MySQL Community Edition, MongoDB and Microsoft SQL Server. The idea of Hana SDI was to treat all three options as equal, decide at activation time which on. To create a data lake instances choose relational-data-lake. Securing a SAP HANA database requires applying standard best practices, including encryption, access control, and monitoring. "<NULL>". Click Add to create a new data source to connect to a data lake Relational Engine database. You’ve the CREATE VIRTUAL TABLE object privilege on the SAP HANA database remote source for data lake Relational Engine. Score 8. Treat SAP HANA as a multi-dimensional source (default) 2. Note: This blog post was edited to include the latest information on 2 June 2020. PUBLIC SAP HANA Cloud, Data Lake Document Version: 1. Transform the data extracted (in files) to use as a source data for Migration Cockpit. Create an SAP HANA Cloud, Data Lake. ENC. To enable this in Power BI. This site uses cookies and related technologies, as described in our privacy statement , for purposes that may include site operation, analytics, enhanced user experience, or advertising. There’s no need for standalone tooling as in the classic SQL DW. Host: the host name of the database; Port: the port to use for connecting to the database; Database name: the name of the database; Schema (optional): the database schema you want to use, leave empty to use the default schema. Gets and sets value that indicates whether the source column is nullable. This syntax is specific to refreshing an SAP HANA database virtual table's metadata in a data lake Relational Engine context. Again, to remove the Materialized view we need to wrap it up under the REMOTE_EXECUTE () call. Both are perceived as discrete units from the administration perspective. Enable the Davis® AI causation engine to automatically. Max DB: The draw backs with the In Memory are. NET supports Microsoft Windows; The example application in this tutorial was written in C#Smart Data Access. Issue - Power BI is not loading all the HANA Contents. Application Development Using SQL . Labels: Labels: Need Help; Message 1 of 6 9,049 Views 2 Reply. "HANA cloud has the same performance, speed & power, customers expect from SAP HANA but in cloud native database, fully managed multi cloud and also supporting seamless hybrid scenario. Page Not Found | SAP Help Portal. Open Power-BI, connect Database, choose SAP-HANA, 4)Choose to treat it a multi-dimensional source or relational source 5) done? Im basically just the guy who introduces Power BI and does Reports. power bi sap bw limitations, sap hana power bi gateway, power bi hana odbc driver, power bi treat sap hana as a relational source, direct query sap hana, power bi hana filter power bi treat hana as relational, power bi sap hana this connector requires one or more additional components. When you connect to SAP HANA data sources ，there are two options when connecting to SAP HANA，1. Contrary to the SAP HANA Online option, this one requires to specify data scope with the query panel, and the report calculations are not pushed down to SAP HANA DB. Prerequisite. User name: the login name of the HANA user you want to use for this connection; Password: the password of the HANA. Create a Remote Source Using the SAP HANA Database Explorer. When you upsert data into SAP HANA targets, you can configure the EnableArrayUpsert custom property to upsert data in bulk and improve the session performance. We performed a comparison between Oracle Database, SAP HANA, and SQL Server based on real PeerSpot user reviews. SAP HANA Cloud. PUBLIC SAP HANA Cloud, Data Lake Document Version: 1. Each object type can also contain associated objects. 2. I just installed the July 2018 release and under Options/DirectQuery, there is no longer an option for "Allow unrestricted measures in DirectQuery mode. But I can change variables in the transformation menu. Step 1) To create new user in SAP HANA Studio go to security tab as shown below and follow the following steps; Go to security node. SAP HANA Cloud, data lake is. The DBMS, which runs on SUSE Linux and Red Hat Enterprise Linux, enables real-time analytics on transactional systems on a large. {"payload":{"allShortcutsEnabled":false,"fileTree":{"powerbi-docs/connect-data":{"items":[{"name":"media","path":"powerbi-docs/connect-data/media","contentType. Community Support Team _ Cherie Chen If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Treat SAP HANA as a relational source Treat SAP HANA as a multi-dimensional source (default) with better performance, you can use this option. SAP HANA is deployable on premises, in a public or private cloud, and in hybrid scenarios. Search Scopes: All SAP products;Definitions of data lake Relational Engine (SAP HANA DB-Managed) and SAP HANA database technical terms used in this document. In a relational database, you would just add a table for the zookeepers and use a key to link the entries from the zoo area tables to the zookeeper table. One can check if the steps provided in the SAP HANA. You can configure the EnableArrayUpsert custom property at the session level or at the PowerCenter Integration Service level, and set its value to yes. One of the greatest is that the SAP HANA database is not a relational database. The next step to create a universe, is to create a “Data Foundation”. {"payload":{"allShortcutsEnabled":false,"fileTree":{"powerbi-docs/connect-data":{"items":[{"name":"media","path":"powerbi-docs/connect-data/media","contentType. The spatial data processing for location-based business app. Replication: Replicating tables from the remote source. A Relational connection is used to connect to the Database layer to import tables and joins. which lets you to migrate existing relational universes to SAP HANA. : SAP BW: SAP HANA; When you create a query based on an SAP HANA or SAP BW data source and, browse the repository for the connection to be used, the following icons are used to represent the possible connection types. There are two options when connecting to SAP HANA: Treat SAP HANA as a multi-dimensional source (default) Treat SAP HANA as a relational source. The SAP Database Migration Factory program helps simplify and accelerate adoption of SAP HANA, SAP HANA Cloud, and SAP Data Warehouse Cloud for customers running a legacy SAP HANA database or any third-party data platform on premise or in the cloud. Available Languages: English ; Japanese (日本語) This document. This is controlled by selecting File > Options and settings and then Options > DirectQuery, then selecting the option Treat SAP HANA as a relational source. In the Emarsys platform, go to Add-ons > Relational Data > Connections. To create a secured connection, in the Repository Resources View, open a session on the repository where you want to create the secured connection. In order to treat a connection to SAP HANA as a relational source, you must select File Options and settings Options, then check the box under Direct Query Treat SAP HANA. {"payload":{"allShortcutsEnabled":false,"fileTree":{"powerbi-docs/connect-data":{"items":[{"name":"media","path":"powerbi-docs/connect-data/media","contentType. With SAP haha connector, power bi will treat SAP HANA as a multi-dimensional source or relational source in direct query mode. Connect from SAP HANA, express edition to SAP HANA Cloud database. For example, you have two teams, Finance and Sales. Execute the following SQL command to create credentials for the external data source connected to SQL Server data. which can be queried and processed jointly with. capabilities of the SAP HANA database. dbisql is a tool that can be used to query a data lake Relational Engine. Relational connections can only create via IDT or UDT created semantic layers. The connection name cannot be changed later. The role is created when you create the relational container and is specific to the container. Treat SAP HANA as a multi-dimensional source (default) 2. An OLAP connection is used to connect to the multidimensional model like an Information View in SAP HANA. GeneratedMethodAccessor433. Step 2: Create Table in HANA and Import the Data. If I use direct query without "Treat HANA as relational database" all date fields are treated as text and the data type is greyed out. For DirectQuery connections to your SAP BW and SAP HANA systems, you must have an on-premises data gateway installed and the data source. For additional details see Use Clients to Query an SAP HANA Database. Step 4: Running Webi Query. SAP HANA is an in-memory data platform that can be deployed on premise or on demand. 3 SP01 to connect to HANA cloud using OLAP connection and we are experiencing issues regarding the input. Community Support Team _ Cherie Chen If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. The HDI Deployer assumes that for newer versions of SAP HANA, a corresponding version of the SAP HANA Service Broker is used to create the CF/XSA service bindings. After you create Power BI report with this option, you can make a copy of PBIX file and change connection to views. Loading/importing works fine. 1 to SP 5. Open the Information Design Tool on your Windows server, and create a new project. 06-23-2021 02:29 AM Hi, Power BI desktop not fetching all the HANA calculation views I successfully connected to the SAP HANA database from Power BI Desktop application,. For more information, see DirectQuery and SAP BW. SAP HANA is the new in-memory calculation engine in-memory database. The key to the above HANA DB statements is that the HDLFS enpoint that is. For the second issue, you can define variables on SAP HANA side, then you can enter desired values for these variables on Power BI side to filter data. To set up a connection to HANA database, select SAP HANA database 1. Instance Number. Hierarchy functions are an integral part of SAP HANA core functionality. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. NET applications to query SAP HANA data lake Relational Engine instances; Eclipse must be used to debug a . If the column list is omitted, then the database performs the insert using all the columns in the virtual table. Although HANA is a relational database, it has supported storing of nonrelational data. Connecting Webi to HANA - In older versions of SAP BusinessObjects (4. This is the recommended approach, and is the default for new DirectQuery reports over SAP HANA. Community Support Team _ Jimmy Tao If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. A list of SQL statements in SAP HANA database in the context of data lake Relational Engine. That’s where SAP enterprise threat detection comes in, including important new capabilities delivered. For more information, see Integrating Data to and From SAP. Right-click the Project name → New → Relational Connection. Message 3 of 9 1,130 Views 0 Reply. We use cookies and similar technologies to give you a better experience, improve performance, analyze traffic, and to personalize content. , synonyms,. It aims at enhancing application performance, reducing cost of ownership, and finding. It needs less disk space than some of its competitors and is highly scalable. For linked database. The SAP HANA database is a component of the overall SAP HANA Appliance that provides the data management foundation for renovated and newly devel-oped SAP applications (see Section 4). This is controlled by selecting File > Options and settings and then Options > DirectQuery, then selecting the option Treat SAP HANA as a relational source. Type the name of the server. Vertices and edges can have an arbitrary number of attributes. This site uses cookies and related technologies, as described in our privacy statement, for purposes that may include site operation, analytics, enhanced user experience, or advertising. Follow the steps in the New Relational Connection. Understood. trusted_certificates= <certificate_string>. Type the instance number for the connection. {"payload":{"allShortcutsEnabled":false,"fileTree":{"powerbi-docs/connect-data":{"items":[{"name":"media","path":"powerbi-docs/connect-data/media","contentType. Type the instance number for the connection. One place to access data. The upgrade to the object storage for your instance is a two step process. CDI-PC Integration Service. 0). Universes on SAP HANA are based on relational connections. in Power BI Desktop connect to an SAP HANA or SAP BW data source. The host and port values can be copied from the SAP BTP Cockpit or SAP HANA Cloud Central via the copy SQL endpoint option. Yes. To enable this in Power BI Desktop, in the DirectQuery menu under Options, check the “Treat SAP HANA as a relational source” and click OK. Customer-organized groups that meet online and in-person. The Select a data source dialog will appear. Reporting in SAP BI (Business Intelligence) Overview. As visuals are created, the correct aggregate data will always be retrieved from SAP HANA. The following code will create a TPCH schema in the HANA DB. Best Regards, Link . We would like to show you a description here but the site won’t allow us. In the list of connectors, click SAP HANA. You have assigned quota to the subaccount in the SAP HANA Cloud section on the. Creating and using the connection in the first instance works perfectly - I can connect to Calculation Views stored on our HANA databases, design dashboards and publish them. So SAP HANA 2 is definitely what you want to go for. To connect to this instance, use your Open SQL schema in the space which you have selected to access the data lake. 0 (with SAP . Select SAP BW as the data source. In the dialog, enter a name and description for your connection. Oracle. #1: Integration of All DW Functions on the SAP HANA Platform. However, we haven't been able to find how to setup that connections as DirectQuery, as it works in import mode by. Within your new project, create a new Relational Connection. SAP HANA Cloud, data lake is composed of two key components: the data lake Relational Engine component, and the default data lake Files component. Search Scopes: All SAP products; This product;SAP HANA is an open platform. Good afternoon, I have a question about the Direct Query mode of the SAP HANA Database connection. 0. I am using Implementation 2. >hostname –fqdn (This command gives the FQDN of the DB server. Column names. The CREATE VIRTUAL TABLE provides a way to access an existing table or view data lake Relational Engine. When you create a CAP application with HANA as the database, it is not very intuitive to find how to explore tables/views of the application (being a developer). {"payload":{"allShortcutsEnabled":false,"fileTree":{"powerbi-docs/connect-data":{"items":[{"name":"media","path":"powerbi-docs/connect-data/media","contentType. sdk. V_T1 AT "SYSHDL_CONTAINER1_SOURCE ". To connect to SAP HANA data from Power Query Online: From the Data sources page, select SAP HANA database. 4. All new connections to SAP HANA use this connection method by default, treating SAP HANA as a multi-dimensional source. Data resides in memory (RAM) and not in the hard disk. Contain the definition of a table in a relational database. On the other hand, when using the relational source setting, Power. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. You can define how the Integration Service marks each row using the Treat Source Rows As property in the General Options settings on the Properties tab. Here comes SAP HANA – a robust and flexible database that addresses platform, technology and database challenges. I have been trying different options and I have not been able to connect porperly to the data. Use SAP HANA database REMOTE_EXECUTE_QUERY when a procedure returns a result set. SAP HANA is a column-oriented, in-memory relational database that combines OLAP and OLTP operations into a single system. Select SAP HANA > JDBC Dirver. 1 or earlier), the only option to connect Webi with HANA is with the use of the Universe. Dr. {"payload":{"allShortcutsEnabled":false,"fileTree":{"powerbi-docs/connect-data":{"items":[{"name":"media","path":"powerbi-docs/connect-data/media","contentType. 0 Back Next Working with SAP HANA Database Sources You need an SAP HANA license to read data from SAP HANA sources and write data to SAP HANA. Enable Column Binding. Right-click the Connections folder or subfolder in the repository, and select Insert Relational Connection. This site uses cookies and related technologies, as described in our privacy statement , for purposes that may include site operation, analytics, enhanced user. ”. An interesting exception is SAP HANA, which is “in-memory-centric,” focusing on in-memory-type transaction schemes and leaving users to link HANA with their relational databases if they wish. The top reviewer of MySQL writes "A great open-source product that offers great scalability and compatibility". SAP HANA Cloud is composed of multiple components. The check box "treat SAP HANA as a relational source" does not have any affect. HANA is an in-memory database. Learn about options for connecting to SAP HANA using DirectQuery in Power BI Desktop, as a multi-dimensional source or a relational source. The file must be uploaded to Cloud Pak for Data by an administrator with the Administer platform permission. ) databases (whether on-premise or cloud) web services (Google analytics, Github,. SAP HANA is deployable on premises, in a public or private cloud, and in hybrid scenarios. Power BI with SAP HANA as a data source | SAP HANA Power BI connector. Markus Kohler, Development Manager, SAP AI CTO Office. only database user with ROLE ADMIN privileges can create user and role in SAP HANA. Connecting BI to an SAP HANA Database. It can be a single source or multi-source universe. Follow the below steps to import if the source is available in the same SAP HANA database that is imported into the table. SAP HANA is deployable on premises, in a public or private cloud, and in hybrid scenarios. You need an SAP HANA license to read data from SAP HANA sources and write data to SAP HANA targets. The SAP HANA database in SAP HANA Cloud supports a variety of remote sources based on different adapter types. Once a reporting tool is connected to the SAP HANA database via a relational connection, it is saved in the repository for further use. The HDI Deployer supports SAP HANA 1 SPS11/SPS12 and SAP HANA 2. For additional non- data lake Relational Engine. For additional details see Use Clients to Query. You may choose to manage your own preferences. Source table name. 1. DBMSs (Database Management Systems) support the development,. Data is isolated between containers unless access is explicitly granted. The primary step over here is to directly Import the TPCH data. Hi Amit, 1. Just updated Client BI 4. This site uses cookies and related technologies, as described in our privacy statement , for purposes that may include site operation, analytics, enhanced user experience, or advertising. Zili Zhou, Strategic Project Manager, SAP HANA Database & Analytics. And Treat SAP HANA as a relational source offers. 0 supports HANA, using a relational universe to access HANA. Treat SAP HANA. Note: The HDI Deployer assumes ownership of the src/, cfg/, and lib/ folders in the bound target HDI. Hadoop grew out of, and specializes in, the need to apply looser standards to data management (e. The universe can be based on views and tables in HANA. And Treat SAP HANA as a relational source offers. The tables and columns that make up this view are provided in the SQL statement below. 3/5 stars with 498 reviews. As I will come on to explain, the solution is based on a relational storage platform but it can hold non-relational data e. The SAP HANA is most definitely a relational database design. The SAP HANA data lake client provides a . Open the Workspace. This cannot contain spaces and should. One of the greatest is that the SAP HANA database is not a relational database. Treat SAP HANA as a relational source Treat SAP HANA as a multi-dimensional source (default) with better performance, you can use this option. Available Versions: QRC 3/2023 ; QRC 2/2023 ; This document. 0 64-bit (August 2020)". Darwin Wijaya Tonny, IT. When provisioning an SAP HANA database instance, you. Create a CAP application and read data from HANA IQ store using virtual tables. SAP also stated that HANA was 100% column in design, when not only was this not true but would have made it impossible to support a transaction processing application. The API version shipped with this release is 1. Approach 1: SAC SQL Data source live connectivity using HANA SDA / SDI. Yes. By continuing to browse this website you agree to the use of cookies. SAP HANA uses Smart Data Integration (SDI) to retrieve data from and send data to the SCP Blockchain service. When connecting to SAP HANA as a multi-dimensional source, the following considerations apply: Please go to File > Options and settings ->Options > DirectQuery, then select the option "Treat SAP HANA as a relational source". You can treat SAP HANA as a multi-dimensional source or a relational source. On the contrary, if we need to access multi-dimensional data cubes, then we need an OLAP connection. Configure your connection as follows: Connection Name: the reference you want to give to your connection, can be the same as the DB name.