Articles

MOURI Tech believes in keeping it’s associates busy in not just hands on projects, but also thinking and researching about the new trends and technologies towards which the market is heading. We encourage our associates to take lead, research and document their study in forms of White Papers that makes the company proud. We believe in contributing towards spreading the knowledge that we acquire through our valuable resources. Here are a few articles that we have published in recent times.

Database Migration from MSSQL to PostgreSQL

Data management and security is paramount in the IT industry. Migrating large amounts of data from one type of database to another requires extreme care and caution. It is a challenge to obtain a precise manual process about database migration from MSSQL to PostgreSQL due to a lack of much information on this subject over the internet. This article aims to provide a concise and collective information on this process.

Business Intelligence – A key component in Business Development

Efficiency and productivity are the two driving forces of an organization. With the ongoing technological development, there is a huge data overload. Business Intelligence is the best solution for this growing problem and to keep up with the current trends. This article speaks about how BI is useful to any business and how we can help our customers to achieve their goals.

Migrating Oracle Database from AWS RDS to Oracle Cloud Infrastructure

Nowadays, proper data management is crucial for any business. We have many cloud service providers for storage and securing databases. If our Oracle database is deployed in a cloud AWS environment, then a move to Oracle Cloud Infrastructure can be rewarding, as it offers unparalleled performance for cloud native and enterprise IT workloads.

ServiceNow - A smarter way to work

ServiceNow is a cloud-based ITSM software tool that enhances and automates the Enterprise Management. This article speaks about the key features of ServiceNow, which offers a range of products for low maintenance cost, ease of customization, real-time analysis and data integration.

SAP Security Authorization - Trace & Checks

Tracing the Missing Access

There are certain situations where the users encounter issues related to access or authorization and are unable to communicate the exact missing access. It is the responsibility of a security consultant to ensure that the missing access is traced and analysed through various SAP tracing tools such as SU53, ST01 and STAUTHTRACE, which is the essence of this article.

SAP HANA High-Performance Analytic Appliance

Digital dreams drive business success. SAP HANA outstands in the market by performing 10,000 times faster than every existing database.Enterprises often run into issues of multiple batch-run dependencies, to avoid SAP S/4HANA in-memory database technology that enables the centralizing of hardware and network resources.

Cloud Identity Access & Management

SAP Cloud Identity Access Management (IAM) has the functionalities to support an organization in restructuring users access and management in on-premise or cloud environments. By integrating this, users’ access can be handled centrally, reducing the risk across the enterprise and various business applications. Users can reset their passwords and improve access insights and compliance through Cloud IAM.

SSAUDIT and Cell Properties in Essbase

Analysts prefer to view multidimensional data in cubes, instead of relational tables. A data cube is a multidimensional matrix that facilitates analysis from various perspectives. This article essentially consists of two aspects - about SSAUDIT feature, which records each transaction detail and about Cell properties and Sandbox dimension types. These are useful in obtaining information on who submitted the data into Essbase cube and how it was loaded.

Technical Monitoring Cockpit - SAP Monitoring Tool

Technical Monitoring Cockpit is a new monitoring and analysis tool used for quick analysis to find issues in SAP application and database. It brings with it a new look and feel from an administrator’s point of view in terms of analysis to get new features, adapts Fiori Launchpad and gets full coverage of technology stack like SAP application, DB and host.

Let’s Wangle with Web Scraping!

Extracting data manually from web pages can be a tiresome and redundant process. The need for using highly advanced tools and techniques is in demand to get the data in desired formats. This is where web scraping comes to the rescue. In this article, we will discuss about various popular tools used for web scraping, how to pick the appropriate tool based on the project requirements and many other interesting aspects of web scraping.

Machine Learning for Algorithmic Trading

Algorithmic Trading is a complex process of automated programming to buy or sell financial securities on an exchange with high-speed data processing (sometimes known as - High Frequency Trading) and accuracy without human intervention. Machine learning algorithms can analyse thousands of data sources at the same time, something an ordinary human trader cannot accomplish. Read the article to know more on this.

Connectivity to Essbase Cube from On-premises and Cloud in Microsoft Power BI and Oracle Analytics Cloud

This article explains how to connect to Essbase cubes or applications from Microsoft Power BI and Oracle Data Visualization (DV) in on-premises and cloud environments. It also provides comparison between Power BI & Oracle Analytics Cloud, along with examples of dashboards for better understanding.

Creating custom Essbase application level backup in Oracle Analytics Cloud Classic (OAC Classic)

Essbase applications, when backed-up manually require effort depending on the number of applications. This is a time consuming process and is highly prone to manual errors. Having a script eliminates the manual intervention, giving the flexibility for scheduling to run the back-up at any desired time. This article explains how to write a custom shell script in Unix for Oracle Analytics Cloud.

Speed up your SAP data migration by choosing the right migration tool

The successful implementation of any ERP (SAP) software mostly depends on data migration i.e., how fast and securely we can migrate data to SAP system from a legacy system. We can reduce the cost, time and efforts to load and validate data by choosing the appropriate approach and tool to migrate data into the SAP system.

Modern Data Warehouse for Organizations

Have you ever thought of an organization completely gaining insights from a data residing in a database, further leading to be dependent on a data warehouse? This article focuses on the importance of modernizing the data warehouse and helping the organizations to take decisions by implementing this approach. It also gives the differences between a traditional data warehouse and modern data warehouse and on what cases a modern data warehouse could achieve certain things from an organization stand point when compared to a traditional data warehouse.

Informatica - Cloud Integration Hub

Informatica Cloud Integration Hub (CIH) is a cloud-based application integration solution which can be used to share and sync data between different applications within the organization. This article provides insights on Cloud Integration Hub, a product of Informatica Cloud. It basically explains what CIH is, how it can be used and why we need it.

Integration of BRFplus Objects in ABAP Web Dynpro Components

This article provides information about the integration of BRFplus object i.e., Expression Type Formula Builder into your Web Dynpro application. BRFplus Object Formula Builder gives access to the user in the Web Dynpro Application to change the values as per the required business process.

Autonomous Driving

Autonomous Vehicles are soon to be the redefinition of the automotive world. Many companies around the world are jockeying to bring this advanced technology to reality. Most of the discussion in this article is focused on self-driving cars, the technologies that are being used to achieve autonomous driving, the various levels of autonomous driving, as defined by SAE and its societal benefits. The article also helps us in understanding where we are now and still how far we are in achieving the dream of fully-automated driving.

Regression Testing Using Baseline Validation Tool

Unlike normal testing it is challenging in BI testing to validate the data from source system to target. In order to overcome this, Oracle has introduced a Baseline Validation Tool (BVT) from OBIEE 12C onwards. This tool will test your environment in six ways, you can run these tests either one at a time or all of it at once, providing us with a consolidated report for most of our concerns and clarifying our queries regarding regression testing or upgradation.

Managing Oracle Cloud Platform Services using PSM-CLI

Oracle Cloud Platform services are generally managed on console. Oracle offers a hidden option of using PaaS Service Manager’s Command Line Interface (PSM-CLI) commands to manage admin operations in a more efficient way compared to the usage of console. It also provides a chance to automate the recurring tasks performed on Oracle Cloud.

Why BigQuery?

Did you know that Google uses a technology which can scan around billions of rows in tens of seconds? A major point to consider here is that, this scan is done without using any indexing. Sounds amazing, right? Let us understand a bit about this amazing technology called “Dremel”, which can execute SQL-like queries over large datasets (around 20 TB) and produce results accurately within seconds. So, it is safe to say that if someone has a basic knowledge of SQL, they can easily handle large data sets efficiently.

Six Sigma’s Strategies and Secrets for Success

We experiment and innovate to develop new products, processes, and practices. The key ‘X’ factor which drives an organization to come up with new kindling ideas is ‘CUSTOMER’. We deliver products and dedicate services to the customer which are accessible and affordable. So, to be in the game we need to acquire a few tools, technologies and methodologies in providing better services and products to our customers.

New Features and Removals in Hyperion EPM 11.2

Oracle continuously releases new versions in Hyperion, with the latest being the release of Cloudera. Everyone assumed that 11.1.2.x is the last release on On-Premise, but Oracle announced that they will be releasing 11.2.x On-Premise which is the latest along with the functionalities of cloud applications. Let’s have a look at the details of the new additions and also the old features that were replaced by the newer version.

Multi Occurrence and Double Multi Occurrence Integration

Master Data Management Solutions

Multi-occurrence is a metadata type of attribute in the MDM data model. If we want any attribute to appear multiple times for ERP records, we must declare that attribute as a multi-occurrence attribute. Double multi-occurrence is a concept of declaring one attribute as multi-occurrence under multi occurrence attribute.

Near Line Storage with Sybase IQ 16.1

This article is all about setting up Near Line Storage for BW on HANA or non-HANA systems using Sybase IQ Database. It clearly explains about installation and post set up options available with Sybase IQ 16.2. The data classification is deeply articulated and methods of checking archived data, most common issues with resolutions and how to restore the archived data back to HANA DB have been included.

Release management for AWS Lambda Function With API Gateway

Lambdas are simple and easy to use but the problem arises when you want to work with the same Lambda on multiple environments with different versions. This is where AWS Lambda Versioning and Aliases comes to our rescue. With the help of AWS Lambda Versioning and Aliases, the problem of the different environments can be eliminated effectively.

Build and run Continuous Ingestion flows by Streaming Ingestion feature of Data Ingestion

In today’s real world, there is huge volume of data generated continuously at high speeds from various sources which needs to be processed immediately and incrementally without manual intervention. This article is about one of the new features of Informatica Intelligent Cloud Services, which is capable of capturing streaming data that can be integrated to on-premises and to cloud for further future analysis.

Storytelling with Data using Oracle Data Visualization

Oracle Data Visualization (DV) is a part of Oracle Analytics. This article explains capabilities of Oracle DV, which is a business analytics service for connecting, preparing, visualizing and sharing insights or stories from data.

Digital Signature for SAP Notes

There is a fair possibility for the SAP Notes to get maliciously modified and customers might unknowingly upload those maliciously modified SAP Notes files into their ABAP systems. In order to avoid such situations, SAP has come up with the concept of ‘digital signing’ of SAP Notes.

Data flow among Microservices

With the help of RabbitMQ

In order to choose the best approach for data flow among microservices, we first need to understand the requirements clearly. In this article, we will see how can data be shared between multiple microservices with the help of RabbitMQ, along with various features of other message-oriented middleware.

Comparison between Chatbots Development With Dialogflow and Tensorflow

There are numerous platforms available in the market for the developing a chatbot. This article throws light on the various approaches/platforms employed to develop a chatbot, and the pros and cons of each approach along with the industry trends.

SAP Gateway User Provisioning Service

Simple ODATA service is employed to handle SAP Gateway accounts from any ticketing tools. This will help SAP Security team to create/update/terminate accounts in bulk in a single request. This is also easy to integrate with ticketing tools like ServiceNow and Jira.

Handling Case-Sensitive data

This article mainly focusses on how to fetch the case-sensitive data using Native SQL statements, Open SQL statements and CDS views in the different SAP versions, with the help of suitable examples.

Exception Handling In Mule Batch Processing

Handling exceptions in batch processing can be very complicated sometimes taking into consideration the huge amount of data. This article will give you an easy and effective way to handle exceptions in a batch with a primary focus on identifying failure records and catching exceptions in batch processing.

Connecting OACS to On-Prem Data Sources using Remote Data Gateway

There are multiple connectives in Oracle Analytics Cloud to connect On-Premise database. This article provides information in detail regarding Remote Data Gateway (RDG), which is the latest version 105.3 in Oracle Analytics Cloud Service (OACS).

Docking Your Applications to Dockers

Have you ever felt the pain when your application which worked in the DEV environment failed in either QA or STAG? This problem is commonly seen in software development. However, we can finally get over it with dockers. Let’s see how dockers make the software deployment among various environments hassle-free.

Managing Microservices Traffic with Istio

Deploying modules of a microservices architecture rather than monolithic gives the flexibility to select different languages and technologies. Maintaining multiple microservices operations is complex and users might face many problems over services like monitoring, traffic routing, service discovery, and security between services. We can overcome these problems by having “Istio” installed on our platform.

Bot User Accounts Governance through SailPoint IdentityIQ 7.3

Most of the modern day organizations are implementing Robotic Process Automation to eliminate the involvement of their employees in repetitive manual tasks. This article provides knowledge on the necessity of governance for bot user accounts and how we can govern bot user accounts

Why Microservices over Monolithic?

In today’s fast growing and emerging world, applications need to be designed, developed and deployed on the fly rather than waiting for one phase to be completed as a whole. Microservice architecture provides all the benefits to develop a full-fledged application and deploy individually instead of getting the whole application down.

Near-Line Storage with Straggler Management

Data archiving is simplified with Read & Write access via Straggler Management. Data records violating the archiving condition will be updated via separate Delta Request overcoming the back-posting issues during archiving.

Automation Of Objects Migration in Informatica Intelligent Cloud Services (IICS)

Migrating the Objects from one environment to another environment is a manual and time consuming process in Informatica Intelligent Cloud Services. As this is a manual process, it poses a risk of human errors during the migration. To overcome this, we at MOURI Tech implemented an out of the box process to automate this manual process, thereby avoiding a number of manual errors.

ABAP Core Data Services

Core Data Service (CDS) is a data definition language created by SAP. We can define and consume data models on the database rather than on application server by using CDS views, which is a platform used to create data models by which data can be transferred to outside applications using ODATA services.

How Artificial Intelligence is changing the way we sell things

Artificial Intelligence is changing our lives. From mobile camera to self-driving cars, we see how AI is penetrating into our lifestyle. But how is it changing the industry? This article gives, in a simple to understand language, an idea about how it is poised to change the retail industry.

Monitoring business applications with AppDynamics

Do not be left behind in the competitive market - Monitor your business applications with AppDynamics, which is one of the best application performance monitoring solutions available.

Implementing Private Data Collections in Hyperledger Fabric

Private collections provide additional layer of privacy to Blockchain data. However, many parties will be involved in blockchain and authorized parties only will have ledger copy based on the collection profile (Endorsement policy).

SAP LaMa

SAP’s LaMa is a landscape management tool that helps Basis administrators avoid manual repetitive tasks. It centralizes the landscape which is hassle free to perform operations. LaMa not only helps in cost reduction but also saves ample amount of time.

Upgrades in UX

This article is about the journey of the roots of the front end technologies. We will explore the journey from the beginning, where it started with HTML and CSS. As the user's requirements and scope have increased over time, the technology has updated from HTML to Bootstrap, CSS to LESS/SCSS and JavaScript to jQuery.

SAP EHSM - Incident Management & Email Notifications

SAP EHSM mitigates environment, health, and safety (EHS) risks by implementing comprehensive risk assessment for safe work practices. The EHSM software from SAP mainly comprises of details about the management of employees’ safety, health, industrial hygiene, and occupational health processes at different work locations such as site, factory and so on.

Technical Challenges in Business Logic Enhancement of SAP TM

This article explains briefly about SAP Transportation Management and challenges in the SAP TM business logic enhancing to the standard behaviour of the system. In this article you will know about all possible options provided by SAP to enhance standard behaviour of the system and how you can tune up SAP TM system as per business requirement.

SAP Smart Business

SAP Smart Business is a business framework for visualizing analytic content of Key Performance indicator (KPI) or Operational Performance Indicator (OPI) in the form of analytical Fiori tiles and interactive full-screen dashboards providing quick insights to take an effective decision.

Agent Intelligence

Automation using Agent Intelligence module has been made available in ServiceNow which involves auto-populating values of the fields while creating tickets. This helps a great deal in improving the efficiency of a business. The entire article depicts how to utilize and execute Agent Intelligence in ServiceNow.

OFFERBOT

Offer bot is a machine learning concept that can be developed and integrated into mobile and web application to save time. It automates recurring offers and special offers to customers based on certain pre-defined rules. A wide base of customers for offer bots include banking, retail and telecom industries.

AMDP’s alternative to READ_TEXT Function Module

This article primarily focuses on how to use ABAP Managed Database Procedure (AMDP), one of the code push-down techniques in S/4 HANA to overcome the performance problems while using traditional READ_TEXT function module for retrieving mass amount of long texts.

SAP Advanced Track and Trace for Pharmaceuticals

In a world of ever changing legislations, SAP ATTP appears to be a boon to pharmaceutical companies. However, the success of SAP ATTP, or for that matter any SAP product depends to a large extent on the correct master data. Ensuring correct master data ensures high data quality, consistency and reliability of business process. To sum up, a successfully implemented SAP ATTP ensures patient safety and curbs falsified drugs.

AVI Address validation.

The article essentially provides knowledge on Address Verification Interface (AVI) service, which validates the address provided by a user in the Master Data Governance tool. The validation is done in the back end and the results are delivered to the user in the form accuracy code, determining whether the data entered by the user is valid or not and enabling the user to know about it before the form submission.

Actionable Insights with the help of Augmented Analytics using SAC BI capabilities

Augmented analytics is the next generation in data science and analytics paradigm. We can automate data insights with the help of smart data discovery using machine learning algorithms and natural language processing to augment human intelligence.

IBM WebSphere Transformation Extender

The IBM WebSphere Transformation Extender is a powerful data transformation engine that can speak directly to native interfaces and APIs. The article provides knowledge on its components, the formats supported and how it is different from other transformation tools.

S/4HANA Conversion

Are you planning to convert your legacy ECC to S/4HANA? Do you want to experience the benefits with S/4HANA? This article helps to understand the differences between legacy ECC and S/4HANA and also gives an overview of Converting an ECC system to SAP S/4HANA followed by MOURI Tech’s Strategies for converting to SAP S/4HANA.

Choosing your iOS Application Architecture

This document offers guidance on selection criteria, helping to choose the right type of software architecture while developing an application on iOS. It details on defining Model, View and Controller Jargons and Anatomy of Presenter.

SAP NLS with HADOOP

Worrying about huge data growth? Think about SAP NLS HADOOP!! Know about the temperature-based concept that stores the cold and warm (less used) data in HADOOP with a provision to access it whenever it is required directly by queries. This article explains how SAP NLS is useful for data management in any organization.

Overview on ServiceNow

The article gives a thorough overview on ServiceNow - how it is useful to users as compared with other tools, its features and benefits, various modules that are present in ServiceNow and a detailed note on each module.

An Overview on Octopus Deploy

The article explains about functionalities and key features of Octopus, which is the deployment automation tool designed for releases and deployment of applications. It ensures that releases are properly tested before deploying it to production.

Impact of Hybrid & Reactive Applications on Web UI

This article talks about the journey of web user interface from static HTML UI to attractive mobile devices UI. It gives information on how the things have moved from static UI to dynamic UI, how the hybrid application created on web can possibly be deployed on mobile devices and how it changes the whole dynamics.

Continuous Deployment to Azure with Team Foundation Server (Azure DevOps Server)

This article describes how Team Foundation Server/Azure DevOps Server has grown up into a complete DevOps platform and how Microsoft has loaded it with features to deploy the applications continuously into the cloud, with options that are aligned with Azure Cloud.

Can we utilize the power of HANA with different reporting tools?

We can utilize the power of HANA with ABAP CDS Views in HANA and expose data for reporting to meet diverse use cases and add business value using prevalent reporting tools such as Microsoft Power BI, SAP Fiori, Qlik Sense and SAP BO.

UX - Why, What and How

MOURI Tech realises that a good experience will bring back customers to your product and that is why, pays special attention to User Experience(UX) design. This article discusses the UX process we follow to makes sure that good UX is an integral part of every product that we create.

Need for Application Retirement

This article gives you an overview of application retirement and states its importance on how effective would it be to maintain all the legacy data of any application and also briefs us on what leads for any application to be retired.

Identity Access Management (IAM) and its benefits

In the process of on-boarding a new employee in an organization or relieving an existing employee, there is a lot of manual work involved in terms of provision or de-provision of access. This might lead to typographical errors and or delays or even security threats if they do not remove the access on time for a terminated resource. This article gives information on what is Identity Access Management, the necessity to implement it in an enterprise and various benefits associated with it.

Hierarchical Stage in DataStage.

The Hierarchical stage has been added in DataStage - Version 11.3. It used to work with XML and JSON data, the stage itself has its own pallet to do transformations. This article details on how Extensible Markup Language can be read by hierarchical data stage, providing examples and its advantages over XML packs.

Automation of Oracle Hyperion Migrations

This article discusses about how to automate manual process for Migrating Hyperion objects from one environment to another environment. This automation process is built by different scripting languages and Microsoft Excel. Using this process we can reduce the time of migration and minimize or nullify errors.

Data Connections in SAP Analytics Cloud

This article explains the benefits of SAP Analytics Cloud (SAC) and types of connections to import data to SAC from on-premise and cloud data sources with a pictorial representation. It also gives information on the features and highlights of SAC.

Road map for migrating On Premises OBIEE to Oracle Analytics Cloud (OAC)

This article discusses about Road map for Migrating On-Premises Oracle BI Content to Oracle Analytics Cloud (OAC) to leverage the benefits that are offered by Oracle Cloud along with different Cloud BI Models that are practiced by MOURI Tech.

Sentiment Analysis On Twitter Using Hadoop.

This article gives information on how the organisations can collect a product review based on the feedback given by the people in social networking platforms. The technology used for testing is Hadoop, which helps to process the unstructured data (Example: Twitter data) in a very less time.

Implementation Of Access Control Using Guides In Informatica Cloud Application Integration.

Guides are used to build user interactive integration applications for users with no or less access to code. With use of informatica integrated design environment guides can be implemented as set of screens to automate several processes and interfaces of applications such as Salesforce.

Summary of DevOps

DevOps is a set of tools and practices used to automate the processes of Developers, Testers and operations teams, in order to build, test, and release software faster and more reliable and error free.

Single Sign-On Based on SNC Kerberos method for SAP ABAP Application servers.

SAP Single sign-on (SSO) is a SAP software product and it provides a secure authentication and encryption when the users are accessed to SAP and Non-SAP applications with single password. It is intended to improve enterprise security and simplicity by providing access to applications across all systems.

Active directory integration with Informatica Intelligent Cloud Services(IICS)

In this article we will discuss about Active directory integration with other applications by using Informatica Intelligent Cloud Services(IICS). The aim of this article is to explain how we are going to capture the data changes from Active directory and integrate with other systems.

Moving to SAP HANA – Consider Archiving

The goal of the whitepaper it to walk through a brief perspective on SAP data, how and where to start with archiving when migrating to SAP HANA. Some simple key lessons learnt and how MOURITECH can help an organization ride this journey.

new functionalities with GRC 12.0

SAP has come up with newer version of GRC which is 12.0 right after Version 10.1 in March 2018. New functionalities ranges from Fiori look like screens to IAG (Identity Access Governance), S/4 Hana Rule set to Hana EAM and so on covered in the this article.