Sap hana data provisioning techniques – sap hana fast easy ways to make money tutorial

SAP HANA is a database and whenever it is used fast easy ways to make money for analytics, it might require data to be channeled to it from fast easy ways to make money all the systems where business transactions are going on. I used the word “might” in the previous sentence because with SAP’s new S4HANA application, analytics and transactions can now take place on the same fast easy ways to make money database. Check it out on this link on the SAP website fast easy ways to make money – it’s quite amazing. I will do a document on it once I have fast easy ways to make money created all the basic tutorials for the topics here. S4HANA is great but still not widely adopted. The more common techniques of data analysis involve data provisioning fast easy ways to make money from external systems into HANA for modeling. Let’s take a look into these methods one by one. 1. Flat file upload

Flat files are data files which are stored locally and fast easy ways to make money not coming in from a live server. The supported extensions are .Csv, .Xls and .Xlsx . So if you add a few columns of data in fast easy ways to make money excel and save as one of these formats, it is now a flat file ready for upload. This is the least used method in HANA as business fast easy ways to make money data should ideally come from live transactional database tables rather fast easy ways to make money than static files.

These type of files are usually used for custom table fast easy ways to make money data loads wherein sometimes the business wishes to maintain some fast easy ways to make money mappings or so. For example, let’s say that our client has 2 source systems – one for the US and one for germany and they fast easy ways to make money maintain different status values for the same status. In the US an open order in source system is fast easy ways to make money denoted by “OP” and in germany (DE is for deutschland which is how the true german fast easy ways to make money name for germany), the open orders are denoted by OF. In this case, if we are creating a global report, it’s not good to have two symbols for the same fast easy ways to make money meaning. Therefore, someone from the client team makes a target mapping saying fast easy ways to make money that “OP” will be the final target value for such ambiguities and fast easy ways to make money in HANA we use this mapping table to harmonize the fast easy ways to make money data. Such files are usually uploaded via flat files into HANA fast easy ways to make money into custom tables as source systems may not have them fast easy ways to make money maintained anywhere especially if each of these countries have a fast easy ways to make money different system. Country

SAP landscape transformation or SAP SLT is the most widely fast easy ways to make money used data provisioning technique for native SAP HANA projects with fast easy ways to make money SAP source systems. Most tutorial spread the misconception that developers manage the replication fast easy ways to make money but usually it will be an administrator who will take fast easy ways to make money up the request for table replication from a developer and fast easy ways to make money then make sure that table is replicated as there may fast easy ways to make money be security restrictions on the incoming data and it’s not difficult to mess up SAP SLT replication if fast easy ways to make money the entire control is given to a newbie developer. Thus from a developer perspective, let me keep the explanation simple for now.

As seen in the illustration, when a SLT server and its connections have been properly fast easy ways to make money set up between the SAP source system and HANA, there is a state of constant replication between source and fast easy ways to make money target HANA system. Every time there is a change in the table, a trigger from source pushes the data through the SLT fast easy ways to make money server to HANA. The initial load of tables might take some time as fast easy ways to make money there may be millions of records in most financial and fast easy ways to make money sales tables but after that has been done, the replication is done in near real-time speeds (most would refer to this as real-time as there’s only a few seconds of delay).

DataServices or BODS is an amazing tool which can take fast easy ways to make money data from any data source to any data target. It is one of the most powerful ETL tools out fast easy ways to make money there in the market and since it’s an SAP product now, the integration is really smooth. You have different options here for transforming data coming in fast easy ways to make money from source systems before it reaches the target HANA table. There are set of rules that can be created and fast easy ways to make money run by scheduled jobs to keep data updated in HANA. But although BODS does support real-time jobs, usually batch jobs (=scheduled background jobs) are run due to performance limitations. This means that this provisioning technique is not real-time. The newer versions of SAP BODS also support creating repositories fast easy ways to make money on SAP HANA this allowing many calculations to be performed fast easy ways to make money in the HANA database. But in most such implementations involving SAP BODS, data transformations are usually done in HANA data models rather fast easy ways to make money than data services to have all the logic at one fast easy ways to make money place. We will do a demo soon on this in a fast easy ways to make money separate tutorial. 4. Other certified ETL tools

Like BODS, there are other powerful ETL vendors in the market that fast easy ways to make money do similar jobs but they need to be certified with fast easy ways to make money SAP for your client to get any type of support fast easy ways to make money from them if something goes wrong. Why would you go for such options? Well, if your client was having an architecture that already had fast easy ways to make money licenses for these tools, then they would want to use it instead of shelling fast easy ways to make money out more money for SAP data provisioning licenses. But since these won’t be SAP tools, the integration would not have as many options to play fast easy ways to make money around with as the SAP ones. 5. SAP EIM (enterprise information management)

This combines the SLT and BODS approaches and is a fast easy ways to make money relatively new feature. SLT brings in new data at real-time and EIM has a subset of tools from BODS fast easy ways to make money for major data cleansing and transformations. This is a great option but still in a relatively fast easy ways to make money native stage and hence the usage is still not widespread fast easy ways to make money also since it might require extra licenses and hence additional fast easy ways to make money cost.

Smart data access may not be exactly a data provisioning fast easy ways to make money technique as there is no data being replicated as this fast easy ways to make money method involves replication of table meta-data only from the source and not its data. This means that you get the table structure on which fast easy ways to make money you can create a “virtual table” for your developments. This table looks and feels exactly like the source table fast easy ways to make money with the difference that the data that appears to be fast easy ways to make money inside it is actually not stored in HANA but remotely fast easy ways to make money in its source system. HANA supports SDA for the following sources: teradata database, SAP sybase ASE, SAP sybase IQ, intel distribution for apache hadoop and SAP HANA. SDA also does an automatic datatype conversion for fields coming fast easy ways to make money in from source system to HANA datatype formats. 7. DXC or direct extractor connection

You would need to have some SAP BW background to fast easy ways to make money fully understand this. Give it a read and don’t bother if you don’t get too much of it. This data provisioning technique involves leveraging the extractor logic in fast easy ways to make money SAP source systems and to process the incoming data through fast easy ways to make money that layer of logic in the SAP source before being fast easy ways to make money delivered to HANA. This of course involves execution of quite some logic in fast easy ways to make money ECC side and is not recommended. I personally am not a fan of this method and fast easy ways to make money haven’t seen any client be inclined towards it either. It is a waste of HANA’s potential in my honest opinion. You are better off spending time gathering raw requirements, and building the views from scratch than using this bad fast easy ways to make money shortcut.

RELATED POSTS