SAP-HANA

SAP-HANA

SAP HANA Modeling: Complete Tutorial

By : Mason Garcia

What is SAP HANA Modeling? SAP HANA Modelling is an activity by which we create information view. Information View is similar to dimension, cube or information provider of BW. This information view is used for creating the multi-dimensional data model. SAP HANA Modeling Overview Modelling is an activity in which user refine or slice data…

Read More SAP HANA Modeling: Complete Tutorial
SAP-HANA

SAP HANA Flat File Upload Tutorial: CSV, XLS & XLSX

By : Mason Garcia

SAP HANA support uploading data from a file without ETL tools (SLT, BODS, and DXC). It is a new feature of HANA Studio Revision 28 (SPS04). SAP HANA Support following type of files which will be available on client system as below – .CSV (Comma Separated value files) .XLS .XLSX Prior to this option, the…

Read More SAP HANA Flat File Upload Tutorial: CSV, XLS & XLSX
SAP-HANA

SAP HANA Direct Extractor Connection (DXC) Tutorial

By : Mason Garcia

What is SAP HANA DXC? SAP HANA DXC is batch driven data replication technique i.e. it can execute after a time interval. SAP HANA DXC uses existing ETL (Extract, Transform, and Load) method of SAP Business Suite Application via a HTTPS connection. In SAP Business suite application content Data Source Extractors have been available for…

Read More SAP HANA Direct Extractor Connection (DXC) Tutorial
SAP-HANA

SAP DS (Data Services) in HANA

By : Mason Garcia

What is SAP Data services? SAP Data services is an ETL tool which gives a single enterprises level solution for data integration, Transformation, Data quality, Data profiling and text data processing from the heterogeneous source into a target database or data warehouse. We can create applications (job) in which data mapping and transformation can be…

Read More SAP DS (Data Services) in HANA
SAP-HANA

SLT (SAP Landscape Transformation Replication Server) in SAP HANA

By : Mason Garcia

What is SLT (SAP Landscape Transformation Replication)? SLT is the an ETL tool that allows you to load and replicate data in real-time or schedule data from SAP source system or Non SAP System into SAP HANA Database. SAP SLT server uses a trigger-based replication approach to pass data from source system to target system….

Read More SLT (SAP Landscape Transformation Replication Server) in SAP HANA
SAP-HANA

DATA Provisioning & Replication in SAP HANA

By : Mason Garcia

What is DATA Provisioning? DATA Provisioning is a process of creating, preparing, and enabling a network to provide data to its user. Data needs to be loaded to SAP HANA before data reaches to the user via a front-end tool. All these processes are referred as ETL (Extract, Transform, and Load), and detail is as…

Read More DATA Provisioning & Replication in SAP HANA
SAP-HANA

SAP HANA Calculation View Tutorial

By : Mason Garcia

What is Calculation View? SAP HANA Calculation view is a powerful information view. SAP HANA Analytic view measure can be selected from only one fact table. When there is need of More Fact table in information view then calculation view come in the picture. Calculation view supports complex calculation. The data foundation of the calculation…

Read More SAP HANA Calculation View Tutorial
SAP-HANA

SQL Script Tutorial in SAP HANA

By : Mason Garcia

What is SQL Script? SQL Script is a collection of extensions to SQL. It can be used in stored procedure in place of plain SQL. It determines the functional and procedural extensions. In SQL Script user can define local variables for structure and tables that are primarily used for the creation of stored procedure. SQL…

Read More SQL Script Tutorial in SAP HANA
SAP-HANA

SAP HANA Tutorial: Create Sequence

By : Mason Garcia

What is Sequence? A sequence is a database object that automatically generates the incremented list of numeric values according to rule as specified in sequence specification. For example to insert employee number automatically in column (EMPLOYEE_NO) of Table, when a new record is inserted in the table, then we use sequence. Sequence values are generated…

Read More SAP HANA Tutorial: Create Sequence
SAP-HANA

SAP HANA SQL Stored Procedure Tutorial

By : Mason Garcia

What are SQL Stored Procedures? A procedure is a unit/module that perform a specific task. This procedure can be combined to form larger programs. This basically forms the ‘Modular Design’. A procedure can be invoked by another procedure which is called the calling program. Procedures are re-useable processing block with a specific sequence of data…

Read More SAP HANA SQL Stored Procedure Tutorial

End of content