SAP

SAP- System Application & Product in Data Processing

SAP Cloud Platform-

·        Is an open platform-as-a-service

·        includes the in-memory SAP HANA database management system

·        connects to both on premises and cloud-based systems

SAP Cloud Platform is based on open source technology, developed & supported in partnership with SUSE .

[SUSE is a German-based, multinational, open-source Software Company that develops and sells Linux products to business customers. Founded in 1992, it was the first company to market Linux for the enterprise.]

What is the difference between cloud computing and Web hosting?

Web hosting is simply the process of offering remote location and maintenance for files and server space used to support Web projects.

Conventional kinds of Web hosting include services where individual users can build and store small websites with a Web hosting provider, and enterprise Web hosting, where businesses enter into contracts with third parties like Internet Service Providers to host their sites.

 Web hosting will involve a Web hosting company serving only one client on any given server. This provides more individual security and a more focused approach to serving an individual customer

Cloud computing can also support remote Web hosting. The definition of cloud computing services involves the connection of clients to vendors through wireless or IP connected networks. In cloud computing, a client sends data to a vendor through an abstract network trajectory called "the cloud." Data is then stored and maintained on remote servers owned and operated by the vendors.

Cloud computing services that include Web hosting are usually multi-tenant.

NetWeaver

SAP NetWeaver is called a central foundation for SAP software stack and provides a flexible platform for other NetWeaver components such as Process Integrator, Business Intelligence, Enterprise Portal, and for ABAP and Java applications.

SAP NetWeaver Application Server supports platform-independent web services, business applications, and standards-based development, enabling you to leverage existing technology assets for Web-services-oriented solutions.

All NetWeaver components are built on SAP Web Application Server and components are written in J2EE or ABAP.

SAP NetWeaver is one of central component of entire SAP software stack and provides a platform for the other components, as well as JAVA and ABAP applications.

Web services

Web services is a standardized way or medium to propagate communication between the client and server applications on the World Wide Web.

Various components of web services like SOAP, WSDL, and REST.

Web services provide a common platform that allows multiple applications built on various programming languages to have the ability to communicate with each other.

"HANA" mean High Performance Analytic Appliance is a combination of hardware and software platform.

There are two type of Relational data store in SAP HANA:

v  Row Store

v  Column Store

Redo log- Committed records

Undo log- un committed records

SAP has provided two solutions for Integration-

·         SAP PO

·          SAP HCI

SAP HANA Architecture :

SAP HANA database is developed in C++ and runs on SUSE Linux Enterprise Server .

SAP HANA database contain multiple server most important server is the Index server.

Index Sever:

·         Index server is the main SAP HANA database component

·         It contains actual data stores and the engine for processing the data.

• Index Server processes incoming SQL or MDX statement.

HCI-HANA Cloud Integration

HCI-

·         Middleware technology

·         HCI allow integration between on premise application and SAP cloud application

HCI-PS: Application Edition is intended to be used with pre-packaged integration content  from SAP for selected SAP cloud solution. Ex. Hybris

Ex-SAP cloud for customer.

HCI ADAPTERS

·         SOAP

·         HTTP

·         IDOC

·         SFTP

·         ODATA

·         SUCCESSFACTOR

·         MAIL

·         ARIBA

·         FACEBOOK

·         TWITTER

If you want to connect to an on-premise solution using a different adapter, which is not covered by SAP, then you need to use PI in between or you can develop custom adapter

Oracle PL/SQL Records

                Oracle PL/SQL Records

   PL/SQL Record is composite datatype  which means that it can hold more than one data type .

   

  PL/SQL have three type of records:

1.  Table Based Record
2.  Curser Based  Record
3.  User-defined Record

   

   

        Oracle PL/SQL

                                           TOPIC:-PL/SQL procedure

       Two type of Block:-

1. Named Block
2. Anonymous Block 

•  A PL/SQL procedure that accept zero or more parameter as input (IN),output (OUT) or both (INOUT) .
• PL/SQL does not return any value.
• PL/SQL can not used in SQL statement.
• They are invoked using Excute command or called inside a SQL block.

    CREATE OR REPLACE PROCEDURE  procedure name

    ( parameter ,parameter,parameter) 

    IS 

    local declaration ;

    BEGIN

    executable  statement

    [  EXCEPTION  

             exception handlers]

   END;

/

Let take an example we have table with name EMP.

    

          SELECT * FROM EMP;

 we created  a procedure-
create or replace procedure delete_emp(empid number) as
total_emp number;
begin
delete from emp where emp.empid=delete_emp.empid;
total_emp:=total_emp-1;
end;

/

execute delete_emp(2);

SELECT * FROM EMP;

             

                                                   

•    You can drop PL/SQL procedure using DROP PROCEDURE statement,

DROP PROCEDURE procedure_name;

      

       

Some Really Cool Google Features You Probably Don’t Know About :

Google is more than just a search engine. Yes, you already know Google owns Youtube, and all about Google Glass…but how many of Google’s interesting features do you know about?

* Set a timer:-

* How to pronounce long Numbers:

* Play Atari Breakout Game:

* Open a task manager specifically for chrome Press Shift+Esc