Tag Archives: Integration

Integration

Integration Services

Today’s expectation is to generate ground-breaking innovations creating new revenue streams, delivered quickly to increasingly more demanding customers. To become the most agile and responsive organisation, you have to innovate faster than your competition. Invenio Business Solutions is able to work with your company to ensure success now and in the future.

INNOVATE FASTER

Create new business models faster than your competition

DIGITAL TRANSFORMATION

Reposition your system for the future

EXCEED CUSTOMER EXPECTATIONS

Accurate, fast and intuitive user experience

LONG-TERM COST EFFICIENCY

Smarter setup lowers costs

The benefits of Integration

Integration allows software programs such as CRM and ERP to work seamlessly together and reduce the increasing complexity to bring agility to the entire IT landscape. When integration is implemented correctly, it will allow companies to realise the full benefit of their technology investments.

Information sharing

Data collection across departments and outside the company is consolidated, eliminating the redundancies of having each application collect and store for its own purpose. That means employees spend less time searching for information and the data they get is more complete and up to date.

Reduced IT complexity

Enterprise application integration overcomes these roadblocks to ease business processes by combining the information and functionality of several applications into a single, easy-to-use interface.

Increased agility

One of the key benefits of integration is that it allows organisations to recognise and respond to opportunities faster. Integration can help companies address shifts in the market, reputation management issues, supply chain disruptions and more all from a single interface.

Reduce costs

Integration enables businesses to do more with less. Additional value can be created by decentralising IT tasks. When set up correctly, time to develop, integrate and deployment of solutions is also reduced.

How can SAP SUPPORT TEAM help?

Consultation

We help customers select the most appropriate tools to meet their objectives.

Support

Our experts continually enhance the system to ensure maximum return on investment.

Implementation

Working with your team on the ground, we’ll ensure minimum disruption (if any) to business as usual.

To know more –

Contact us  

SAP Business Objects Universe integration with SAP HANA

SAP Business Objects Universe integration with SAP HANA Universes are a middle layer between certain sources (SAP HANA in our case) and some Business objects reporting tools. These are the tools that do not have direct connectivity via standard connections to SAP HANA sources. SAP Web Intelligence is a tool which was highly dependent on SAP Business Objects Universe as a middle layer when connecting to SAP HANA. This is because Web Intelligence (Commonly called WebI) had no native connectivity options to SAP HANA until the latest version. But with the advent of Business Objects 4.1 SP3 (Service Pack 3), even SAP Web Intelligence also connects directly to SAP HANA eliminating the need for universes as a middle layer completely.

So, if you are working/going to work on a new project that is on Business Objects 4.1 SP3, you won’t need to create a universe and probably don’t need the below tutorial. Unfortunately, most projects out there have been running for a while now and their WebI reports did not have the liberty of connecting directly to SAP HANA back then. Consequently, since Business Objects Universe was a key component of creating Webi Reports, it exists in huge numbers in projects that have been running for years. Thus it makes it an important topic to know

Step 1: Business Objects Universe – Creating a Relational Connection

A Business Objects Universe is created in the IDT (Information design tool). It should be available under the SAP Business Intelligence folder in the start menu as marked below.

Business Objects Universe

The below application when it opens up, should look like as shown below.

Firstly, we would need the tool to be connected to the business objects server so that everything we create here can be published to the online Business Objects repository.

To do this, click on the green plus sign or the black downward arrow marked below.

Business Objects Universe

Click on the Insert session button marked below.

Business Objects Universe

The below dialog box opens which asks for your Business Objects server details. Provide your system name, username, password and Authentication method as provided to you by your SAP security team.

Business Objects Universe

After the details are filled, press OK to confirm.

Business Objects Universe

The BO repository connection has now been established as seen below.

Business Objects Universe

Now, we need a “Project” to organize our work under. A “Project” is nothing but a folder in this case where our work will be grouped. Right Click somewhere inside the blank area of the “Local Projects” pane and then select New Project.

Business Objects Universe

It would ask you to name the project. Give it a meaningful name.

Business Objects Universe

Press “Finish” when done.

Business Objects Universe

As seen below, the “Project” TEACHMEHANA has been created. Now, we can finally start building our Relational connection.

To do this, right click on the TEACHMEHANA project, navigate to New Relational Connection.

Business Objects Universe

Give it a technical name and a description as shown in the example below and then press “Next”.

Business Objects Universe

The next step requires you to choose the Middle-ware driver. Since we need to connect to the SAP HANA database, we expand the SAP section.

Business Objects Universe

Under the SAP section, you would find different SAP sources. In our case, choose the SAP HANA database 1.0 and expand it. There is an option to choose JDBC and ODBC.

Select JDBC and press “Next”.

Business Objects Universe

The next step asks for your HANA system credentials. Provide your username, password, host name and instance number.

Business Objects Universe

Press “Finish” to confirm when done.

Business Objects Universe

1

1

A new relational connection has now been created as seen below. But right now, this connection is local and not published to the repository.

Local connections have the extension .cnx but what we need is a secure connection that is published on the repository.

Business Objects Universe

To create a secured connection, right click on our .cnx connection that we just created and then click “Publish Connection to Repository”.

Business Objects Universe

This opens up the window where you see the connection details to which the connection is going to be published to. In case you have multiple BO systems connected, you can choose where to publish it to at this step.

Press Next.

Business Objects Universe

On the SAP Business Objects Repository of your project, you would have different folders. Choose the folder where you wish to publish this and then press “Finish”.

Business Objects Universe

As seen below, the system confirms that the connection was published successfully. Now, this becomes a secured connection with the file extension “.cns”. The system prompt also asks if you wish to create a shortcut to this newly created cns connection on the same project folder.

Press Yes to confirm.

Business Objects Universe

As seen below, now the cns secured relational connection is available inside the “project” folder.

Business Objects Universe

 

Step 2A: SAP Business Objects Information design tool – Creating a Data Foundation (BO Version < 4.1) 

Note: This explanation is of SAP Business Objects Information Design tool version less than 4.1. If you are on 4.1 version, skip to Step 2B.

The next step to create a universe, is to create a “Data Foundation”. Right click on your project folder and then navigate to New Data Foundation.

SAP Business Objects Information design tool

It asks you for the technical name and description of this data foundation.

SAP Business Objects Information design tool

I name this TMH_DF_OLD since this is the older method for creating data foundation (i.e for versions 4.1 and before).

SAP Business Objects Information design tool

Since there is only a single source of data, select “Single Source” and press “Next”

SAP Business Objects Information design tool

It now requires you to choose a relational connection to connection to the underlying data source. Choose the secured connection always which is the “.cns” one.

Press Finish when done.

SAP Business Objects Information design tool

As seen below, the data foundation has been created successfully. Also, a connection pane opens up. Expand the connection to see the SAP HANA schemas below.

SAP Business Objects Information design tool

As you see below, in this case, you don’t see the SAP HANA packages and the underlying views directly. You only have access to the schemas which house the tables and view metadata as well.

If you have gone through my HANA and SQL tutorials, you would already know that the “_SYS_BIC” schema contains the metadata for all the SAP HANA information views that we model under different packages. Expand this schema as I’ve done in the example below.

SAP Business Objects Information design tool

Now scroll down and find your SAP HANA information view on which you wish to create the SAP HANA universe. This is a bit of a mess since all the information views from your entire SAP HAAN system are in this schema and it might take a while to find it. This has been made better in the consequent SAP Business Objects versions which we will learn soon but for now, double click on your view once you find it.

SAP Business Objects Information design tool

Press the save button once done.

SAP Business Objects Information design tool

Step 3A: SAP Business Objects Information design tool – Creating a Business Layer (BO Version < 4.1) 

Note: This explanation is of SAP Business Objects Information Design tool version less than 4.1. If you are on 4.1 version, skip to Step 2B and 3B.

The next step now requires us to create a Business Layer. To do this, right click on the “Project” folder and select New Business layer from the context menu as shown below.

SAP Business Objects Information design tool

Select the type of data source as “Relational Data Foundation” and press “Next”.

SAP Business Objects Information design tool

Again, you are now required to enter a technical name for this business layer and a description.

SAP Business Objects Information design tool

Since this is the older method, I name the business layer as TMH_UNIV_OLD.

Press Next when done.

SAP Business Objects Information design tool

It would ask you to select a data foundation. Since we only have one data foundation here, it shows up. If you have multiple, choose the data foundation on which you wish to build the report on later.

Press Finish when done.

SAP Business Objects Information design tool

As you press finish, the new business layer now appears.

SAP Business Objects Information design tool

You are now one step away from converting this Business layer to a universe by publishing it to the repository. But before we get there, let’s see how to create a data foundation and business layer on Business objects versions 4.1 and above.

Once we have both these business layers, we will publish them together.

If you are not interested in the explanation of versions 4.1 and above and just want to learn how to publish the older universe version, skip to Step 4.

Otherwise, read on..

Step 3B: SAP Business Objects Information design tool – Creating a Business Layer (BO Version > 4.1) 

The process here is quite similar with the exception that you do not have to create a data foundation by yourself here, system does that part for you. Just a small added luxury .. nothing to brag about.

Right click on the project again, navigate to New “SAP HANA Business Layer” this time. You won’t see this option in SAP Information design tool versions <4.1 .

SAP Business Objects Information design tool

A window opens up asking for the Business Layer and Data foundation name – give them some meaningful technical names compliant with your project guidelines and press “Next”.

SAP Business Objects Information design tool

We already created a relational connection earlier which we can use here. But, we needed the secure connection (.cns which we had published to the repository earlier). Instead the system only shows us the local .cnx. For now, we compromise and pick this connection as the system gives us no choice. We would need to switch the connection later once the business layer has been created.

SAP Business Objects Information design tool

Click the checkbox and press “Next”.

SAP Business Objects Information design tool

Now, instead of having to go through the clutter of _SYS_BIC schema in the older IDT versions, we now have the luxury of having the SAP HANA package tree hierarchy at our disposal. Expand the schema where your view is contained.

SAP Business Objects Information design tool

For example, let’s choose our employee view. Press finish.

SAP Business Objects Information design tool

As you see below, a TMH_UNIV_NEW data foundation(.dfx) and a business layer (.blx) have been auto generated. This version now saved us the time of creating a data foundation.

SAP Business Objects Information design tool

1

Now, since we used a local .cnx connection to create this business layer and underlying data foundation, now comes the time to switch the connection to a secure .cns type. Only then would we be allowed to publish our business layer to the repository to create the universe.

To do this, double click on the new data foundation we just created – TMH_UNIV_NEW.

SAP Business Objects Information design tool

The data foundation opens up as shown below. Click on the “Edit Connection” button

SAP Business Objects Information design tool

This shows you the list of available connections. We would need to select the secured connection here and press “Finish”.

SAP Business Objects Information design tool

Press the “Save” button to save your changes.

SAP Business Objects Information design tool

Step 4: SAP Business Objects Information design tool – Publishing a Business Layer 

Finally, we reach the magical step where we publish the business layers which creates a universe. This step is fairly straightforward. Just right click on your business layer and press Publish -> “To a Repository”

SAP Business Objects Information design tool

Here, there are different validations/check you can perform based on your project guidelines about universes, if any. Otherwise, press “Next”

SAP Business Objects Information design tool

Choose the folder where you wish to publish this universe. In this example, we continue the shameless self promotion and name another folder as TEACHMEHANA. We will publish our Business Objects artifacts here from now on. Double click on the folder to go inside.

SAP Business Objects Information design tool

Press Finish to publish your universe here.

SAP Business Objects Information design tool

The Business Objects Information design tool congratulates you on this monumental achievement. The universe is now saved on the repository with the same name as the business layer with an extension of .unx

SAP Business Objects Information design tool

Let’s do the same for the business layer we created with the new process.

SAP Business Objects Information design tool

Ignoring the validation window, we reach the below step where I already navigated to our TEACHMEHANA folder where we saved our last universe. You can see it resting in the folder below under the unx extension as explained before.

Press finish to save this new universe as well.

SAP Business Objects Information design tool

IDT confirms that the publish was successful.

SAP Business Objects Information design tool

SAP SuccessFactors Integration

SAP SuccessFactors is SAP’s cloud-based human resources solution. It offers a variety of applications from Core HR application like Employee Central and Employee Central Payroll, over SAP SuccessFactors Talent Solutions for recruiting and learning, to SAP SuccessFactors Analytics Solutions like Workforce Analytics.

SAP SuccessFactors has different applications in itself which are supported and connected in different ways.

SAP SuccessFactors Integration SuccessFactors via Central SF Event API

Most application of SuccessFactors support the Central SuccessFactors Event API. Solution Manager can connect to this API via an OData API. This way we can receive exceptions in scheduled jobs and simple integration exceptions and alert on them in SAP Solution Manager. When it comes to connecting SuccessFactors to your on-premise system you have several options again, depending on you SuccessFactors use case. You can transfer files via FTP / SFTP servers. This can be monitored with Interface and Connection Monitoring. You can integrate SF with your on-premise system via SAP PI or SAP HCI. SAP PI can be monitored via PI Monitoring, Interface and Connection Monitoring and single message flows can be monitored using

SAP Successfactor Integration
SAP Successfactor Integration

 

SAP SuccessFactors Integration SuccessFactors Talent Management Applications

One of the first monitoring techniques we were using with SuccessFactors was the Email-to-Event converter. SAP Solution Manager would be registered as receiver for emails for error events and then a converter would parse this emails and create an exception out of it. We still have this functionality but we work on replacing this with the possibilities of the Central SF Event API.

Depending on which integration option you choose this can be monitored as well, via PI or Message Flow Monitoring and via Interface and Connection Monitoring.

SuccessFactors Talent Management Applications Integration
SuccessFactors Talent Management Applications Integration

 

SAP SuccessFactors Integration Integration add-on for SAP ERP HCM and SuccessFactors HCM allows you to integrate data between two environments related to organizational structure, organizational data, compensation and qualification data.

Compensation Data

You can support compensation process on Business Execution by transferring data from compensation SAP ERP HCM to SuccessFactors BizX. It is also possible to transfer planned compensation data from SuccessFactors Business Execution to SAP ERP HCM and you can import this data in payroll cycle in HCM suite.

Employee Data

Integration add-on allows you to transfer employee and organizational data from SAP ERP HCM to SuccessFactors and you can manage Talent Management process on SuccessFactors Business Execution (BizX).

Evaluation Data

You can manage work force planning and analytics by transferring data from SAP ERP HCM to SuccessFactors cloud.

Integration Add-On Releases

Integration add-on releases are as follows −

  • Integration Add-On 1.0 for SAP ERP HCM and SuccessFactors BizX
  • Integration Add-On 2.0 for SAP ERP HCM and SuccessFactors BizX
  • Integration Add-On 3.0 for SAP ERP HCM and SuccessFactors