18.3.16

Analytical Transaction Database Platform(ATDP)


우리는 IDSC에서 '디지털 전환' - 우리의 삶, 특히, 비지니스를 수행하는 방식이 디지틀 데이터, 미디어, 컨테츠의 증가로 변화된다는 개념 -에 대해 많은 이야기를 합니다.
비록, 이러한 변화의 초기 단계 ? 수동 작업의 자동화, 콘텐츠의 디지털화로부터 비즈니스 인텔리전스, 고급 분석에 기반한 의사 결정으로 이동 ? 이 증가했지만, 우리는 이전보다 훨씬 빠른 속도로 많은 양의 다양한 데이터를 수집하고 분류하고 준비하고 이용하는 기술 덕분에 중요한 디지털 매스(홍수) 단계에 도달해 있습니다.
과거 비즈니스 데이터 뿐만 아니라 현재 운영 데이터, 스트리밍 센서 데이터, 스마트 모바일 디바이스에서 양방향 데이터 및 다양한 컨텐츠를 사용하여, 우리는 기업의 비지니스 컨텍스트에 관한 뷰를 만들고, 매우 빠르게 심지어 자동으로 뷰의 내용에 따른 행위(조치)를 취할 수 있습니다.
실시간 운영 데이터와 함께 비즈니스 상황에 대한 전체적인 뷰를 통하여, 우리는 "순간적인" 의사 결정을 내릴 수 있는 위치에 있습니다.

그러나, 이렇게 하는 것은 단일 처리 작업에서 운영의 조정과 모든 관련 데이터의 이용이 필요합니다.
대부분의 기업의 IT 구성은 정형 데이터만을 위해서 이렇게 작업을 수행하도록 설정되어 있지 않습니다.
우리는 또한 운영 데이터로부터 분리된 분석 데이터를 가지고 있습니다. 왜냐하면,
두 가지 유형은 디스크 기반 데이터베이스를 관리 할 때 매우 다른 구조와 처리를 요구하고,
분석 질의들이 단일 시스템에 함께 있을 때 트랜잭션 처리가 느려지기 때문입니다.
이런 이유로 운영 데이터는 트랜잭션 데이터베이스에서 관리되며, 분석을 위해서 대개 ETL 프로세스를 사용하여 DW와 같은 분석 데이터베이스로 복제됩니다.
분명히, 이것은 분석 데이터가 조회되기 전 항상 몇 시간 또는 심지어 D-1일이 지난 데이터를 가지는 것을 의미합니다.

이렇게 하는 이유는 데이터 관리에 대한 전통적인 방식이 디스크 기반 데이터베이스 기술이였기 때문입니다.
디스크 최적화된 접근 방식은 데이터가 디스크에 상주하고 디스크 I/O를 최소화하기 위해 최적화되어야 한다는 것을 가정합니다.
디스크 최적화 데이터베이스를 사용할 때, 주의 깊고 전략적으로 스키마의 파티션과 인덱스를 적용하고 주기적으로 검토하고 수정하기 위해,
최적의 방식으로 디스크 볼륨에서 데이터를 배열하는 것이 중요합니다.
트랜잭션 데이터와 분석 데이터의 최적화가 완전히 다르기 때문에, 양자는 혼합될 수 없습니다.
데이터 구조가 어떤 이유로 변경하는 경우, 스키마 최적화 구성 작업이 필요하며, 일반적으로 데이터베이스는 변경을 반영하기 전에 몇 주간의 재구성 작업을 필요로 합니다.
비지니스 민첩성이 떨어지는 상황에서, 응용 프로그램이나 분석에서 매번 변경에 대한 오버 헤드는 단순히 받아들일 수 없습니다.
또한, 분명히, 시간 또는 몇일을 기다리는 것은 "순간적인" 의사 결정에 전혀 도움이 되지 못합니다.

다행히도, 우리는 데이터베이스의 기술 혁명의 중간에 있습니다; 한가지는 DBMS의 이전 세대의 디스크 최적화 접근을 메모리에 최적화 된 접근 방식으로 대체한다는 것입니다.
현재의 인메모리 데이터베이스는 데이터 복제 및 대기 시간을 제거하면서 "순간적인" 의사 결정을 가능하게 하는 단일 데이터로 메모리에서 트랜잭션 및 분석 모두를 수행합니다.
메모리 최적화 방법은 메인 메모리에 상주하는 데이터를 고려하고, (데이터가 어떤 종류의 오류가 발생하는 경우 손실되지 않도록 하기 위해서) 복구용 디스크를 사용합니다.
데이터 구조의 변경을 즉시 수행 될 수 있고, 시스템은 주로 자체 조정하고, 모든 작업이 메모리에서 수행되기 때문에, 처리는 훨씬 더 빠릅니다.
그러나, 장점은 속도와 민첩성을 뛰어 넘고, 또한 ETL 단계가 사잘지고 있기 때문에, 복잡한 질의에서 신속하게 라이브 트랜잭션 데이터와 함께 비지니스 인텔리전스 데이터를 통합하는 기능을 포함합니다.
분석과 트랜잭션 데이터가 단일 데이터베이스에서 함께 있습니다.
우리는 심지어 그들이 발생시키는 트랜잭션을 수행하여 질의 결과를 활용하여 우리의 응용 프로그램을 수정할 수 있습니다.
그 결과는 과거에 결코 실행할 수 없었던 것 - 트랜잭션 처리를 제어하는 복잡한 질의 사용 - 을 할 수 있게 하는 "스마트" 응용 프로그램입니다.
이 기능이 바로 "분석 트랜잭션 처리"(ATP)라고 하는 것입니다.

일부 공급 업체는 다양한 수준의 ATP 지원을 제공 할 수 있는 기술들을 개발했습니다.
그러나, 여러 소스의 데이터와 핵심 분석 트랜잭션 데이터의 통합으로 기업은 다음 단계 - "순간적인" 의사 결정 뿐만 아니라, 최고의 정보 이용을 기반한 의사 결정 - 으로 접근할 수 있습니다. IDC는 "분석 트랜잭션 데이터 플랫폼"(ATDP) 기능을 제공할 수 있는 시스템을 말했습니다.그런 플랫폼은 이상적으로 메모리에 모든 또는 대부분의 활성화된 데이터가 존재(즉, 인메모리 데이터베이스(IMDB)하고, 더 완전한 분석을 위해 필요에 따라 관련 지원 데이터를 가져올 수 있는 기능에 둘러싸인, 메모리 최적화 핵심 데이터베이스를 가질 것입니다. 그것은 데이터 센터 또는 클라우드에서 초석 기능으로 ATDP를 배포하여 시장에서 앞서나가기 위해 유지하고자 하는 모든 기업의 목표가 되어야 합니다.

10.3.16

What is the difference between SAP BW, Edition for HANA and SAP BW, powered by HANA?

최근 기업의 Digital Transformation의 핵심 core로서 S/4HANA가 출시되면서, Analytic에서도 많은 변화가 진행되고 있습니다. 그 중의 핵심은 Operational Analytic과 Data Warehouse 영역인 BW 변화라고 할 수 있습니다. HANA가 출시 되면서 BW도 HANA DB에 최적화하기 위해 많은 구성요소들이 변화하거나 없어지고 있는데, 특히, BW 7.5 에서 가장 많은 변화가 발생하고 있습니다.
- S/4HANA : 일반적인 Transaction 업무에 추가로 operational Analytic까지도 담당
- BW, Edition for HANA : 기업의 전사 DW로서 역할을 담당

그래서, 이번에는 기존 powered by HANA와 Edition for HANA의 차이에 대해서 알아보도록 합니다.

SAP BW, powered by HANA

1. Modeling
    SAPGUI에서 Data Warehousing Workbench

2. Supported Object
    전통적으로 사용되던 BW Objects - InfoObject, ADSO, CompositeProvider 등

3. Analytic Tool
    Business Explorer(BEx)

SAP BW, Edition for HANA

1. Modeling Tool
    Eclipse 기반의 BW Modeling Tool
    HANA DB에 최적화된 modeling 지원

2. Supported Object
    HANA DB에서 지원되는 Object Type만 지원
    SAGUI의 DW Workbench에서 Object 생성 불가능

3. Analytic Tool
    SAP BusinessObjects Analysis, Edition for Microsoft
    SAP BusinessObjects Design Studio





What is SAP API management?

최근 기업의 Digital Transformation을 더 가속화 시켜주는 API management에 대해서 알아보겠습니다.


GENERAL

1. What is an API?

APIs are Application Programming Interfaces. It is a set of routines, protocols and tools for building software applications. APIs are sets of requirements that govern how one application can talk to another. APIs are especially important because, they dictate how developers can create new apps that tap into big web services and social network. APIs facilitate interaction by selectively exposing certain functionalities, allowing different applications/websites/devices to communicate effectively with each other.



2. What is SAP API Management solution?


API Management is the process of publishing, promoting and overseeing APIs in a secure and scalable manner. SAP API Management has various capabilities to provide unified access and orchestration based on open standards like REST, OData, OAuth and many more with enterprise grade security and seamless connectivity to existing SAP back-ends. This simplifies the way developers go about integrating with their SAP and non-SAP applications, reducing cost, fostering innovation and participating in the larger API economy. SAP API Management is powered by the SAP HANA Cloud Platform, the powerful in-memory Platform-as-a-Service (PaaS) offering from SAP that enables customers and developers to build, extend, and run applications on SAP HANA in the cloud.



3. What does SAP API Management deliver?

With SAP API Management, you can:
  • Increase workforce productivity
  • Personalize consumer engagement
  • Provide enterprise grade security
  • Reduce IT complexity and total cost of ownership
  • Create custom apps quickly and easily
  • Co-innovation with partners and customers
  • Open up new business channels and revenue streams
  • Reduce initial infrastructure investment
  • Quickly modernize your business applications

4. What is the value customers should expect from SAP API Management?

With flexible subscription models and services for infrastructure, database and application development, it provides instant access to the full power of SAP HANA including best-in-business historical and predictive analytics. With robust services for integration, identity management, API management, mobile and collaboration, HCP makes all the complicated stuff simple, so you can quickly modernize your business applications. API management allows enterprises to selectively externalize their assets not just via the traditional browser-centric model but also over mobile devices and other channels. This flexibility allows for provided services to be consumed on any platform. The cloud allows this to be done securely, and with the scalability to meet demand as needed at low investment cost, amortized over a subscription model. SAP API Management provides enhanced collaboration and co-innovation with business partners / consumers / developers by rapid onboarding and easy data visibility. By allowing customers, partners, suppliers and all users of enterprise services to directly access relevant information, enterprises drive increased revenue since information flows on-demand, in real-time. Developer portal reduces internal developments costs, and frees up developer teams to tackle other projects.

5. Who is SAP API Management solution designed for?


Any customer can choose to incorporate this solution. Customers who don’t want to invest lot in infrastructure, but at the same time want to provide solution to the consumers in fast and effective manner, will go for this cloud offering. They can also deploy mixed mode, using cloud offering for B2C scenarios and On-Premise offering for B2E scenarios.

Solution is cross-industry, cross-LOB and supports B2B, B2C & B2E scenarios. However, following industries are leveraging API management type solutions in large scale
  • Retail
  • Telco
  • Financial
  • Healthcare
  • Utilities
  • Consumer industries

6. What are the technical benefits of using SAP API Management?

  • APIs are the core of “System of engagement” and are built on enabling efficient delivery and distribution of content and services. The SAP API Management capabilities enable business towards simplifying the way developers go about integrating with their SAP and non-SAP applications reducing cost, fostering innovations and improving participation in the API economy.(For details refer http://www.gartner.com/it-glossary/pace-layered-application-strategy/)
  • SAP API Management not only provides enterprise grade security that ensures optimized performance, but also helps monitor and manage APIs
  • Unlike SOA strategies, that typically assume that internal users are accessing the services; an API strategy targets engagement with a variety of business and software development partners that are as likely to be external as internal. SAP API Management delivers important additional capabilities: developer portal, key management and approval, metering and billing capabilities.
  • With robust services for integration, identity management, API management, mobile and collaboration, HCP makes all the complicated stuff simple, so you can quickly modernize your business applications.

7. What is the pricing model for SAP API Management?

Volume and functionality based pricing with minimum 12 months subscription:

  • SAP API Mgmt, standard cloud edition : up to 50 Million API calls per month
  • SAP API Mgmt, premier cloud edition : up to 80 Million API calls per month
  • SAP API Mgmt, enterprise cloud edition : up to 200 Million API calls per month

8. How is SAP API Management placed in SAP portfolio?

SAP has many API providers such as SAP Gateway, SAP HANA Platform, SuccessFactors and many more in the road map. There is a need of a solution to manage the numerous SAP and non-SAP APIs. SAP API Management helps unlock the value of digital assets, enabling in creating and delivering content and business services to consumers, partners and developers


9. Are there any business use cases?

Business to Consumer use case in Retail Industry –
Challenges
  • Real-time information
  • Consumable interface
Solution
  • Creation of an API Management platform to quickly expose the APIs.
  • API Management solution in a SaaS-based model, with gateway, analytics, and developer services all hosted in the cloud
Benefits
  • Onboard partners securely and efficiently.
  • Approach fits well with the online business model.
  • Out-of-the-box platform
  • Capabilities such as policies, key management, security, caching, and analytics

Business to Business use case in Cross Industry (Healthcare and Retail)
Challenges
  • Increasing competition in the fitness app arena for consumer mindshare
  • Need to connect consumers to their favorite devices and fitness equipment
  • Drive brand loyalty
Solution –
  • APIs offered to third parties on the partner and developer portal managed through the API Management platform.
Benefits –
  • Scalable, expanded reach to millions of users
  • Create developer relationships and foster co-innovation
  • Control over apps
  • Leveraging existing technology
  • Reducing re-engineering
Business to Employee use case in Healthcare Industry
Challenges
  • Real-time access to records across multiple devices and various locations
  • Maintaining data security
  • Ensuring patient privacy
Solution –
  • Creation of standardized APIs to provide an alternative access method to the back-end systems.
  • Development of new, intuitive user interfaces (or lightweight applications) that could be delivered, monitored, managed, and analyzed.
Benefits –
  • Efficiency and productivity gains in the patient care
  • Secure patient records
  • Employee satisfaction

10. Where can I learn more on SAP API Management?

We have great resources to get you started with SAP API Management for e.g.

11.  What are the system requirements for this solution?

There are no specific system requirements. There is no installation required on customer site.

12. How is the solution able to expose registered services to external parties?

The SAP API Management (provided as on-premise and cloud offering and running along with SAP Process Orchestration) provides capabilities to register and expose services as APIs and supports REST, OData, SOAP or any other HTTP based services.

13.  Does SAP API Management have the ability to monitor performance and utilization of all registered services?

The SAP API Management comes with comprehensive analytical capabilities to analyse the exposed APIs and backend service performance,  latency, error rate, average response times, moving average, anomalies, etc. to just name a few. These capabilities will let you inspect and troubleshoot any issues in the system.

14.  Is there a dashboard of who is consuming the APIs?

The management user interface that comes with SAP API Management comes with an intuitive dashboard that includes various views such as: API traffic, top executed APIs, top developers etc. These out of the box dashboards can be extended to include customer reports and add them to existing or new dashboard views.

15.  How is the governance managed in SAP API Management?

SAP API Management’s runtime engine is policy driven. This means that policies are decoupled from the service definition and can be dynamically linked to these APIs or services to enforce minimal or maximum levels of operation and Quality of Service. It is possible to use from an existing out of the box set of policies or create your own.

16.  Can this solution link to backend ESB services or additional data sources?

SAP API Management provides capabilities to connect to any set of ESB services running locally or remotely. In the same way it can expose APIs or services for consumption, it can also connect and integrate with a variety of backend systems as well.

17.  Does it have the ability to apply and change policies to APIs for security, throttling, prioritisation, rate limitations with no API downtime?

SAP API Management provides a high availability setup and configuration. In addition, the Comprehensive Provisioning and Deployment set of capabilities enables the quick association of policies to services through a single click and automatically switch to a new API or service behaviour.

18.  Does it have the ability for consumers to self-serve on specified APIs?

The Developer services of SAP API Management enables developers (the target audience for API management) to self-service themselves and use any published API or service. This is done through an intuitive web-based interface.

19.  Does it have the ability to insert or restrict certain behaviours?

The policy driven API runtime of SAP API Management enables API developers to define and modify the behaviour of the APIs or services de-coupled from the integrated target or backend service or system.

20.  What are the throttling capabilities of SAP API Management?

Among some of the most relevant capabilities offered by SAP API Management to manage access on API or services we find: quotas for a time period, concurrency access limits, and acceptable spike limits, configuration of caches to accelerate and boost performance.

21.  How can I request access to free trial version of SAP API Management cloud edition?

A trial version of the SAP API Management cloud edition is now available in the trial version of HANA Cloud Platform (HCP). A trial account of HANA Cloud Platform can be created at https://account.hanatrial.ondemand.com

22.  What features are included in trial version?

Full functionality of the Standard Cloud Edition is included in trial version, but it cannot be deployed on production. Please reach out to your Account Executive for test and evaluation license.

23.  What is SAP HANA Cloud Platform (HCP)?

SAP HANA Cloud Platform is an in-memory cloud platform based on open standards. It provides access to a feature-rich, easy-to-use development environment in the cloud. The platform includes a comprehensive set of services for integration, enterprise mobility, collaboration, and analytics. SAP HANA Cloud Platform enables customers and partners to rapidly build, deploy, and manage cloud-based enterprise applications that complement and extend your SAP or non-SAP solutions, either On-Premise or In-Cloud.

24. IS SAP API Management solution a public cloud offering?

SAP API Management solution runs in SAP HANA Cloud Platform. It is currently not available in other cloud offerings such as AWS (Amazon Web Services), Microsoft Azure etc.

25.  IS SAP API Management solution multi-tenant?

Yes it is multi-tenant solution.

26.  Where are the data centres located for SAP API Management solution?

SAP API Management solution runs from SAP data centres in Germany.

27.  How do I get the support for SAP API Management solution?

Support is provided through standard SAP support channels.

API SECURITY

1. What are the security capabilities of SAP API Management?

  • The security policies of SAP API Management provide XML Threat Protection, JSON Threat Protection in addition to Message Validation policy for XML Schemas (XSDs) and WSDL definitions.
  • HTTP header filtering and evaluation of content-level & regular expression validation:
The mediation policies that can be defined and associated to an API or Service enable extraction, filtering and manipulation of messages including headers, URI paths, payloads, and query parameters.
  • Enforcement of rules for identity, HTTP verbs and URI’s, etc.:
SAP API Management’s API runtime enables fine grained policy definition providing policy enforcement on API resources (URIs, HTTP verbs) level.
  • Identity & Access Management and Active Directory support:
SAP API Management provides capabilities to leverage any external identity provider for authentication and authorization including Active Directory.

2. What are the different authentication mechanisms supported by SAP API Management?

  • SAML 2.0
SAP API Management provides capabilities to generate and validate SAML assertions. The API platform can act as an identity provider and as a service provider as well.
  • OAUTH
SAP API Management provides capabilities to configure and enforce OAuth authorization using out of the box policies.
  • Client Certificate
SAP API Management provides Client SSL enabling authentication and encryption of all messages flowing over the network from SAP API Management to the backend services.
  • Key & Certificate repository/management
SAP API Management provides capabilities to create keystores and truststores that provide the necessary keys and X.509 digital certificates.

Architecture and Development


1. How scalable is SAP API Management?

SAP API Management enables provisioning, governance, scalability and security of enterprise information for digital assets. Customers can also scale up to billions of API calls per month.

2. What are the different subscription options?

Solution is offered in 3 tiers based on volume and functionality:

  1. SAP API Management, standard cloud edition: up to 50 Million API calls per month
  2. SAP API Management, premier cloud edition: up to 80 Million API calls per month
  3. SAP API Management, enterprise cloud edition: up to 200 Million API calls per month

3. What kind of application can we develop on SAP API Management?

The options on the kind of applications developed is boundless, but some of the common scenarios are

  • Innovative apps for end consumers/ employees – the abundant backend data can be securely accessed to create innovative apps to reach directly to consumers and provide relevant information to employees
  • Internet of Things – Developer tools provided, help in creating apps that can communicate with each other via multiple devices and channels.

To check the FAQs for SAP API Management- On Premise edition, please visit: SAP API Management by Apigee (on-premise offering) FAQ

5.3.16

How to update HANA Revision in HANA Studio

HANA Lifecycle Management(HLM) 기능을 사용하여 매우 간편하게 HANA Server, Client, Studio를 한번에 Upgrade하는 Upgrade 방범과 절차를 소개합니다.


1. SAP HANA 패치 다운로드하기




2. 운영중인 HANA 백업하기



3. 운영서버에서 HANA Binary File 추출하기




4. PC에서 HANA Studio을 사용해서 HANA Update