Business Intelligence Platform RESTful Web Service

Albert Alan

Restful API

RESTful Web Services are REST architecture based web services. Representational State Transfer (REST) is a style of software architecture for distributed systems such as the World Wide Web. In this architectural style, data and functionality is considered resources and are accessed using Uniform Resource Identifiers (URIs), typically links on the Web.

RESTful Web Service

REST has some advantages over SOAP (Simple Objects Access Protocol) but is similar in technology since it is also a function call via HTTP protocol. REST is easier to call from various platforms, transfers pure human-readable data in JSON or XML and is faster and saves resources.

In the basic idea of REST, an object is accessed via REST, not its methods. The state of the object can be changed by the REST access. The change is caused by the passed parameters. A frequent application is the connection of the SAP PI via the REST interface.

When to use Rest Services

  • You want to access BI platform repository objects or perform basic scheduling.
  • You want to use a programming language that is not supported by another BI platform SDK.
  • You want to extract all the query details and number of records per query for all the reports like Webi and Crystal, etc.
  • You want to extract folder path of all reports at once.

Process Flow

RESTful Web Service

RESTful Web Service Requests

To make a RESTful web service request, you need the following:

  • URL – The URL that hosts the RESTful web service.
  • Method – The type of HTTP method to use for sending the request, for example GET, PUT, POST, or DELETE.
  • Request header – The attributes that describe the request.
  • Request body – Additional information that is used to process the request.

Common RWS Error Messages

RESTful Web Service

Restful Web Service URIs Summary List

URLResponseComments
  /v1Service document that contains a link to the /infostore API.This is the root level of an infostore resource
  /v1/infostoreFeed contains all the objects in BOE system/v1/infostore
  /v1/infostore/ <object_id>Entry corresponding to the info object with SI_ID=./v1/infostore/99
      /v1/logon/longReturns the long form for logon, which contains the user and password authentication template.Used to logon to the BI system based on the authentication method.
  /v1/users/ <user_id>  XML feed of user details in BOE systemYou can Modify user using PUT method and DELETE user using DELETE method.
    /v1/usergroups/ <usergroup_id>    XML feed of user group details in BOE systemSupport GET and PUT and DELETE method. You can Modify user group using PUT method and DELETE user group using DELETE method.
  v1/folders/ <folder_id>XML feed displays the details of the folder, can be used to modify the details of the folder, and delete the folder.You modify the folder using PUT method and DELETE the folder using DELETE method
  /v1/publicationsXML feed of all publications created in BOE systemThis API supports GET method only.

Extended Workflow

 The workflow is as follows:

  • To Pass the Base URL

GET http:///localhost:6405/biprws/v1/users

  • To Pass the Headers

  • To Get the xml/json response

Automation of Rest Call

The Business Intelligence platform RESTful Web Service  (BI-REST-SDK) allows you to programmatically access the BI platform functionalities such as administration, security configuration and modification of the repository. In addition, to the Business Intelligence platform RESTful web service SDK, you can also use the SAP Crystal Reports RESTful Web Services  (CR REST SDK) and SAP Web Intelligence RESTful Web Services (WEBI REST SDK).

Implementation

An application has been designed and implemented using Java to automate the extraction of SQL query for all the webi reports from the server at once.

Tools used:

  • Postman (Third party application)
  • Eclipse IDE

The structure of the application is as below:

The application file comprises of the required java jar files, java class files, java properties files and logs. Java class files (SqlExtract) are the source code and will be compiled and executed using command prompt as:

Step 1

  • Javac -cp “.;java-json.jar;json-simple-1.1.jar;log4j-1.2.17.jar” SqlExtract.java

 The above command compiles the java code.

Step 2

  • Java -cp “.;java-json.jar;json-simple-1.1.jar;log4j-1.2.17.jar” SqlExtract.java

 The above command runs the compiled java file.

The java properties file (log4j) is used to set the configurations for the java code to run. Also, the path for the log file can be set in the properties file.

RESTful Web Service

The logs (SqlExtractLogger) consist of the required output file with all the extracted query for the webi reports along with the data source name, type and the row count for each query in the respective folder in the path set by the user in properties file.

RESTful Web Service

The application is standalone and can run in any windows platform or server which has java JRE (version greater than 1.6 – preferred) installed in it.

Note: All the above steps required to execute the application are consolidated in the (steps) file.

Conclusion

SAP BO provides Restful web service to traverse through its repository, to fetch structural info and to modify the metadata structure based on the user requirements. When integrated with programming languages like python, java, etc., extends the scope to a greater extent, allowing the user to automate the workflows and to solve the backtracking problems.

Handling Restful web service needs expertise in server administration and programming as changes made to the metadata are irreversible.

References

About the Author –

Alan is a SAP Business Intelligence consultant with a critical thinking and an analytical mind. He believes in ‘The more extensive a man’s knowledge of what has been done, the greater will be his power of knowing what to do’.

Center of Excellence – .Net

Best Cyber Security Services Companies

“Maximizing the quality, efficiency, and reusability by providing innovative technical solutions, creating intellectual capital, inculcating best practices and processes to instill greater trust and provide incremental value to the Stakeholders.”

With the above mission,we have embarked on our journey to establish and strengthen the .NET Center of excellence (CoE).

“The only way to do great work is to love what you do.” – Steve Jobs

Expertise in this CoE is drawn from top talent across all customer engagements within GAVS. Team engagement is maintained at a very high level with various connects such as regular technology sessions, advanced trainings for CoE members from MS, support and guidance for becoming a MS MVP. Members also socialize new trending articles, tools, whitepapers and blogs within the CoE team and MS Teams channels setup for collaboration. All communications from MS Premier Communications sent to Gold Partners is also shared within the group. The high-level roadmap as planned for this group is laid out below.

Best DCaas Providers in USA
<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>
Best DCaas Providers in USA<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>
Best DCaas Providers in USA

The .NET CoEfocused on assistingourcustomers in every stage of theengagement right from on-boarding, planning, execution, technical implementation and finally all the way to launching and growing. Our prescriptive approach is to leverage industry-proven best practices, solutions, reusable components and include robust resources, training, and making a vibrant partner community.

With the above as the primary goal in mind the CoE group is currently engaged inor planning the following initiatives.

Technology Maturity Assessment

One of the main objectivesof this group is to provide constant feedback to all .NET stack project for improvement and improvisation. The goal for this initiative is to build the technology maturity index for all projects for the below parameters.

Best Virtual Desktop Infrastructure Software

Using those approaches within a short span of time we were able to make a significant impact for some of our engagements.

Client – Online Chain Store: Identified cheaper cloud hosting option for application UI.

Benefits: Huge cost and time savings.

Client – Health care sector: Provided alternate solution for DB migrations from DEV to various environments.

Benefits: Huge cost savings due to licensing annually.

Competency Building

“Anyone who stops learning is old, whether at twenty or eighty.” – Henry Ford

Continuous learning and upskilling are the new norms in today’s fast changing technology landscape. This initiative is focused on providing learning and upskilling support to all technology teams in GAVS. Identifying code mentors, supporting team members to become full stack developers are some of the activities planned under this initiative.  Working along with the Learning & Development team,the .NET CoE isformulating different training tracks to upskill the team members and provide support for external assessments and MS certifications.

Solution Accelerators

“Good, better, best. Never let it rest. ‘Till your good is better and your better is best.” – St. Jerome

The primary determinants of CoE effectiveness are involvement in solutions and accelerators and in maintaining standard practices of the relevant technologies across customer engagements across the organization.

As part of this initiative we are focusing on building project templates, DevOps pipelines and automated testing templates for different technology stacks for both Serverless and Server Hosted scenarios. We also are planning similar activities for the Desktop/Mobile Stack with the Multi-Platform App UI (MAUI) framework which is planned to be released for Preview in Q4 2020.

Blockchain Solution and Services

Additionally, we are also adoptingless-code, no-code development platforms for accelerated development cycles for specific use-cases.

As we progress on our journey to strengthen the .NET CoE, we want to act as acatalyst in rapid and early adoption of new technology solutions and work as trusted partners with all our customer and stakeholders.

If you have any questions about the CoE, you may reach out to them at COE_DOTNET@gavstech.com

CoE Team Members

  • Bismillakhan Mohammed
  • Gokul Bose
  • Kirubakaran Girijanandan
  • Neeraj Kumar
  • Prasad D
  • Ramakrishnan S
  • SaphalMalol
  • Saravanan Swaminathan
  • SenthilkumarKamayaswami
  • Sethuraman Varadhan
  • Srinivasan Radhakrishnan
  • Thaufeeq Ahmed
  • Thomas T
  • Vijay Mahalingam

Center of Excellence – Server

Our Server CoE is a team of highly skilled individuals and experts in various server technologies who promote collaboration, standardization and best practices to drive business or customer-valued results.

The CoE is focused on providing expert level support in technologies like Windows / Linux Servers, Exchange / O365 Messaging solution, Virtualization with VMWare / Hyper-V / Citrix / Linux, Patch & Compliance Management, Application Availability & Performance Monitoring and Backup / Recovery solutions, etc.

The Server CoE also focuses on in-depth assessment of customer end server infrastructure components to study and analyze the existing design implementations, configurations, and operations to identify strengths and weaknesses to implement technical and economical improvements to businesses, wherever applicable, and perform upgrades, migrations and transformations as necessary.

IT Automation with AI

A wide range of server technologies comprise the Server CoE and not every business or customer can practically leverage all of them. And in the same way, not all the members can practically become an SME in all the server technologies.

Service Offerings

AI Devops Automation Service Tools

Current & Upcoming Engagements

A farm credit bank of US – Server Assessment – In Progress – July 2020

  • MS Active Directory Assessment
    • MS Exchange Assessment
    • VMWare Assessment
    • MS SCCM Assessment
    • MS SCOM Assessment
    • Storage
    • Backup Assessment

A global professional services firm – Hybrid Exchange 2016 Migration – July/August 2020

  • SOW Sign Off – Completed
    • Background verification process for 2 Technical Resources – Completed
    • Migration Environment Setup – In Progress
    • Assessment / Pre-requisites Review – Next Steps
    • Migration Test Phase – July 2020
    • Production Migration – July-August 2020

A Multinational Dairy Company – Active Directory & Exchange Server Migration / July – August 2020

  • Microsoft Active Directory Server Assessment
    • Microsoft Exchange Server Assessment
    • Migration of Active Directory from Windows Server 2008 R2 to Windows Server 2016.
    • Migration of Exchange from Exchange Server 2016 to Exchange Server 2019.

A Wellness Services Agency – Resolve Issues with Exchange Database / DDL – July – August 2020

  • Customer Call / Technical Solution / SOW – Completed
    • SOW Sign Off – In Progress by July 2020
    • Assessment / Migration – Next Steps

A Leading FMCG company of India – Digital Transformation to O365 – July – August 2020

  • Zimbra Mail to O365 Migration
    • Licensing Model Finalization – In Progress
    • Migration Plan & Execution – Next Steps

A Leading FMCG company of India – DNS Migration between Service Providers – July 2020

  • 30+ Domains are registered with Net4India
    • Availability & Support Issues with current provider
    • Assess current domain lists and Migrate to new Provider

A Diverse Hardware Group – Azure Cloud Integration & Support – July/August 2020

  • SOW – in Progress

Road Map

AIOps Artificial Intelligence for IT Operations

Contribution to Organization’s Growth

The Server CoE’s contribution is not limited to one activity with one customer at a time, but involved with multiple simultaneous activities in different server technologies in different customer requirements. Server CoE contributions:

  • Participating in RFPs / Proposals by providing technical solutions to prospects’ requirements
  • Participating in full time Infrastructure Assessment projects for various customers
  • Participating in full time Implementations & Migration projects for different customers
  • Providing Standard Operating Procedures, templates & best practice recommendations in various server technologies
  • Provide internal training to individuals to upskill and strengthen the team
  • Responding to requests and providing solutions to issues faced in various customer engagements

The members of our CoE are dedicated to in carrying out all CoE related activities in addition to their day to day activities in their assigned projects without any impact. We aim to contribute to the organization in terms of technological capability establishment and financial growth with new business opportunities.

If you have any questions about the CoE, you may reach out to them at COE_SERVER@gavstech.com

CoE Team Members

  • Balamurugan Rajamanickam
  • Dilipkumar Dhanasekaran
  • Dinesh Kumar
  • Karthick Mani
  • Karthickmanikandan G
  • Manoj Akula
  • Marimuthupandi Kalimuthu
  • Ramkumar Janakiraman
  • Sabari Nivas
  • Sathishkumar Jayaraman
  • Selvaganesh Kothandan
  • Sivakumar Duraisamy
  • Lakshmi Srikanth

Is the Future of White-Collared Workforce only Digital?

Hariharan Madhavan

COVID-19 taught all white-collared workers and their employers one thing for sure – “It is possible to work from home”. With the current advancements in technology – using a mobile app-based contact center solutions, using collaboration platforms to edit content together, hosting tech troubleshooting bridges where multiple engineers solve an issue, video conferencing meetings allowing people to see each other, from where work is delivered does not matter anymore.

Rpa in Infrastructure Management

Wearing what feels comfortable, sitting comfortably, eating homemade food, personalizing your room, life was never better balanced between work and personal life better than now. With nobody to micromanage, the only way to measure a worker is through outcomes. Attendance swipes are a thing of the past. People managers who have no idea of the work done by their team members will become redundant starting2020.
New digital companies will take over like a storm to embrace this opportunity, just like AGILE took over like a religion to manage software development projects.

Existing digital workforce companies are already providing opportunities for companies to hire talent who can work remotely on a need basis from around the world and save potential hiring costs and free from commitments. Just like Uber and Lyft transformed the taxi business, we could see a wave of disruption transforming and killing the traditional brick and mortar IT behemoths to more agile and digital workforce capabilities hiring top talent on the click of a mobile app, and being able to get talent requirements fulfilled in minutes instead of having to wait for weeks or months to get somebody to join. This will be like the DevOps of Hiring for managers who have new projects and budgets looking for people to get things done.

Every other aspect of the business has changed, reducing time to market, and hiring talent is the only area still very traditional and inefficient. It’s not too late for somebody to realize and use this uncertain economic environment as a cradle of opportunity to offer enterprises as a solution.

The next question that comes up is if the borders are removed, how do you secure and still be compliant with your compliance norms. This is completely dependent on the level of sensitivity of data to which an employee/contractor has access. From using privacy screens in the laptops to using technology like VDI, SaaS-based EDR, NGAV, unified agents, CASB’s, you have literally every control that you can think of on-premise that you can enforce in a laptop used by an employee.

When companies hire you in the future, they will ship you an asset to your home location and expect you to use that asset for work. When you have moved out, you will be sent return shipping on which you can put the asset and send it back.

Another main setback that prevented a revolution is that IT companies had to pay for bench talent to provide for the demand. This will also be disrupted by new entrants. New disruptors will be willing to share up to 70% of the revenue earned by somebody back to them, but if there is a loss of billable revenue, the same will be immediately passed on to the concerned employee. These measures will weed out people who are just not meant for the IT workforce that demands constant skill up-gradation, essentially leaving IT to only the high potential workers who are dynamic.

About the Author –

Hariharan is the global head of Cybersecurity at GAVS. He is responsible for strategic and tactical leadership around emerging technologies such as cloud transformation, cloud-native microservices development, software-defined networking, cloud security, DevOps Security, Security and Automation, Security & AI.

An unprecedented crisis and its unprecedented opportunities

Machine learning service provider

Bindu Vijayan

We will never forget these times, most of us, the regular, morning-news addicts, switch on our TVs, hoping to see declining numbers in the coronavirus infected list.  Country to country, we go feverishly through the good news that we are finally seeing, with the curve flattening. There is a lot of fear and trepidation as to how we will pick up and reintroduce our ways of living and working. Even as we are experiencing just how effective it is to be working from home, it is but natural that companies will resume regular ways of working – back to the office (do we really need to continue paying the real-estate gods as much?), resume travel (do we need to, when virtual meetings were working so perfect?) as soon as the travel embargoes are lifted, it would soon be back to business, all of us more determined than ever, the whole world is raring to go.

Clear communication, as often as it takes, would be the backbone of the new disruptive work practices as these practices will leave employees with some degree of confusion/unrest, particularly in the threat of the current recession. Our lives have been disrupted in every way under the COVID 19 threat, and it is very important that employee morale is high.  It is important for Managers to address employee concerns with sensitivity, everyone is going to have questions on the future of the company, the business, and if their roles are going to be seeing changes. Employees must be told about the changes that are going to be affected, the precautions that are being taken, and also taught/ guided how to function best under these circumstances. If someone has recovered from COVID 19, support him/her without stigma and discrimination. Maintaining employee morale through various activities during these times will bring the much-required boost – plan on virtual awards and recognitions, do as much online as possibly can. And let the communication and interaction be two way – find out the office sentiment, how employees are feeling and make adjustments and improvements accordingly, and communicate constantly.

Going back to our offices after this crisis requires renewed vigilance, given the nature of the coronavirus. Resuming work at the office premises would mean having the whole bunch of employees back, which in itself is a very tricky situation – from social distancing back to human density – it is very important that workplaces are maintained in high levels of hygiene. COVID 19 established the fact that there is definite risk in crowds, and for companies to plan to have employees back at their premises imply a deeper than ever responsibility to workplace hygiene and health. Managing the numbers at our workplace is going to be critical if we are to keep safe from the threat of another attack by COVID 19. Hygiene and cleaning processes need to be increased to its maximum capacity across the workplaces and common areas. Surfaces (e.g. desks and tables) and objects need to be wiped with disinfectant regularly. Alcohol based hand rub dispensers should be maintained at prominent places across the facility. Keep promoting hand-washing through posters and monitors across the facility so that it is a constant reminder for employees to take precautions.

Having to be careful with numbers would require companies to redesign workplaces to have employees coming back. Even though it might not be entirely viable, it can be a mix of having employees continue work from home in rotation, perhaps every week, or whatever works best for the functions, while others work out of the office in redesigned (read larger, increased physical distances) workspaces.  Allocating more space to employees can be achieved only through rotation shifts in order to support social distancing for the rest of the required period as per WHO / local health authority guidelines.  Plan work schedule charts for the various functions to work out of their offices, and maintaining strict schedules will not only decrease the risk of infection but also help employees to plan better, as well as ease anxieties and confusion.

To make the best out of the situation, let’s take the opportunity to accept this as a huge learning time – rethink on travel, travel only if it is really necessary and save money, it can be diverted into more important areas. Promote collaboration across geos, virtual meetings have been a big success during this time, and lets continue to collaborate not just for work and meetings but also to have online employee events across geos. If anything, using more online meetings due to the situation has only brought about an increased sense of camaraderie.  We have seen our colleagues in New York city working at the BronxCare, helping patients in ICU, working alongside the medical staff, and it has been a proud moment for every GAVSian across the world to celebrate them, GAVS’ heroes.

And lastly, as we leave this traumatic time behind us, let’s be careful to ensure that we don’t have to go through the situation again.  Follow WHO guidelines to take control measures that focus on prevention and on active surveillance for early detection and treatment.  The opportunities that this pandemic has shown us are multitude – Newspapers report “our planet is detoxing as humans stay lockdown” – Lower carbon emissions are reported.  Rob Jackson, a professor of Earth system science at Standford University says that carbon output could fall by more than 5% this year, the first dip since a 1.4% reduction after the 2008 financial crisis. The air is cleaner and it is quieter too. Decibel readings at a busy intersection in India were 90 pre-pandemic but it recently measured at just 68, reports Boston University. Water quality is reported to have improved across the globe – from Venice, famous for its canals, its waterways are benefiting from the lack of usual boat traffic brought on by thousands of visitors. The wildlife that usually shies away from humans is seen in abundance, be it the Ridley turtles in the beaches of Orissa, India, to the otters in Singapore, to the whales and deer in Japan, to the orcas in North America.  There is so much of the natural world that is suddenly thriving when we gave it a little space….

This has been a time of unprecedented learning opportunities even as our lives got turned upside down. But true as human spirits go, here is something remarkable I read on Linkedin; it reflects hope, positivity, and genuine empathy – here is an excerpt from a post by Dr. Joerg Storm “Next year, I don’t want to hear about the Oscars, Grammys, Tonys or Golden Globes….. I want to see nurses, doctors, ambulance crews, firefighters, healthcare support workers, delivery guys, shop workers, truck drivers, grocery store workers, and all other essential workers get free red carpet parties with awards and expensive goodie bags. “

Keep Calm and Be a Great Leader in a Time of Pandemic

Katy Sherman

We live in scary times. While governments call for social distancing, it becomes more important than ever to stay connected as a community. For many of us the measures around COVID-19 mean we work from home and manage remote teams. While virtual teams are not unusual, today’s situation brings its own challenges. Today it is not only about being remote, it’s about facing fears. We fear for our jobs, our health, our families and friends.

How do we help each other stay productive and connected while we are worried and isolated?

This is what every leader should do to support their teams and help them get through the difficult times:

1) Make sure everybody has what they need to work remotely. Technology goes a long way in creating inclusive collaborative environment. Ask frequently, be prepared to act to resolve issues. Know how to navigate the company to obtain resources through management, HR, and Helpdesk.

2) Mentor team members on time management, especially people who are not used to work from home. Share expectations and establish norms of how to be available throughout the day, and when to go offline. While some people struggle with home environment being too distracting, others find it difficult to disengage at the end of the day and would stay at their desks until late. Give guidance based on the unique needs of each individual.

3) Get into a habit of checking in on people without agenda – have a coffee break together, chat about things not related to work, allow to unwind. Keep your finger on the pulse! Your team members can experience anxiety, be dealing with personal issues or worried about their communities. Some will need time off, or more flexibility than usual to provide child care, buy groceries during sporadic shortages, or take care of family members.

4) Simulate reality through video chats. Being on camera helps us stay focused, engaged in the conversation, as well as look and feel professionally. It also allows to read the non-verbals and better understand the vibe of the conversation. Turn your video on every time you’re in a meeting, this will encourage others to do the same.

5) Take care about yourself! Wash hands, sleep, exercise, go for a walk, drink water. Keep calm. Don’t spread frustration and panic. Remember, people are looking up to you, so lead by example.

I am sure we will get through this as a community. Lead the way and help others!

Microsoft Cloud Solution Provider

About the Author:

Katy is passionate about:

•Leadership and vision • Innovation, technical excellence and highest quality standards • Agility achieved through teamwork, Agile, Scrum, Kanban, TDD, CI/CD, DevOps and automation • Breaking silos and promoting collaboration of Development, Testing and Operations under cross-functional umbrella of Software Engineering • Diversity of personalities, experiences and opinions.

Things Katy does to spread the word:

•Speak at Technology conferences (including as an invited and key-note speaker) • Blog and participate in group discussions

•Collaborate with schools, universities and clubs • Empower girls and women, help them learn about Technology and become engineers