SAP Identity Management 8.0 Video – Basic Synchron...
Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
This is a video tutorial showing you a basic example of how to use SAP Identity Management 8.0, and more specifically, how to synchronize and manage the user data provided by two different data sources. They can be exported from your SAP or non-SAP system. For this example, we use a TXT file, containing the user IDs and emails of the users, and the second data source is a database table containing further information about the same users.
Target group
The video shows a simple, understandable and easy to execute example. It is meant for users who need an introduction to basic synchronization operations in SAP Identity Management.
Purpose of the video
Along with the introduction to the basic synchronization operations, you will get knowledge of the Eclipse-based development environment in SAP Identity Management 8.0 and the new package concept.
Scenario
Using SAP Identity Management 8.0, we import the information from the file email.txt and the database table HR_Sample into the identity store of the SAP Identity Management 8.0 system. The information from both data sources is merged and uploaded to the identity store.
Result
As a result, the information from both data sources is synchronized and transferred to the identity store of an SAP Identity Management system.
i was trying to follow the video ToASCII pass but i encountered with this error....
i have selected sap identity management database , so in the destination tab i have given a temp table , does the table exist in the sap identity database or i should create a temporary table???
As far as I can remember, in this video we don’t use a To ASCII File pass, but a From ASCII File pass. Can you please check what pass have you created? Also verify that the repository constant Filename contains the correct link to the txt file with the emails. If it is still not working, please open a ticket to report an issue. In the meantime, you can try to add the values to this table manually, so that you can continue with the tutorial.
As you have created the repository in the System Configuration tab of the Admin UI, then the constant FILENAME should be fine (this is what I mean with “verify that the repository constant Filename contains the correct link to the txt file with the emails”). This txt file must contain the IDs and emails of the employees.
If this is not working, you can also try to update the mapping table on the Destination tab of the pass manually. For example you can use the same values as on the screenshot:
may be have in mind in the video the Eclipse development environment and the NetWeaver where IDM is running are on the same machine. If at your environment they are on different machines then the file name you specify should be one on the server side, not on the client side.
So if you fill in the table manually then you don’t need to choose this button again. The purpose of the “Insert template” button is to fill in the table for you, but if you have already done this manually, you can save the pass and continue with the next step.
in the eclipse i have installed the idm plugin they are on the same machine , and in the admin url i have given the configuration of the database and the source file (the location of the source file is in my local system) and database is on remote location so i have given the remote location configuration and the jdbc driver path is in my local system path i gave in the url
source file path in admin url : C:\Users\anurag\email.txt
but as you said then it should work for database repository type .......
i have installed oracle client and the database is at the server side , so i am able to connect to the database remotely through my client using jdbc driver
the file should be accessible for the runtime - e.g. where is your dispatcher? Is it on the same machine as NetWeaver or other?
About JDBC :
On the client side you do not need to know anything about the DB directly except the server name, port and DataSource name configured in eclipse/preferences/connection.
Could you please check whether Dispatcher is selected for the Job or not and also check the Dispatcher status. To run a particular job, corresponding dispatcher status must be Running.
If Dispatcher is already selected and runing then please share screenshots.
i have a job to run using TODATABASE pass.............. like my source one database and destination is one database which is connected through the jdbc:odbc driver ..............
so when i run the job the error is
source is a table not a view ...........
The key attribute (e.g. MSKEYVALUE) is missing or the value is empty
To Database initPass
java.lang.Throwable
Please if any one can help me with this to execute the job.............
It seems in the source tab, you are not retrieving any MSKEYVLAUE from the SQL query which is required in the Destination definition.
Suggested Solution-
Please modify your source query and retrieve the data as MSKEYVALUE which will be used in Destination definition.
or,
Instead of using single pass use two passes - first pass is FROM Database and store it in a temp table and then use a second pass (TO DataBase) where you can read data from the temp table in the source tab.
in my query i wrote select * from tablename where column='value'
and in the destination tab i am giving four values MSKEYVALUE, and remaining columns.......... in the destination tab do i need to specify all the columns from the source???
And in my source table i dont think there is a column named mskeyvalue..........
This is the destination tab, i have tried removing MSKEYVALUE in the destination tab but it is iving same error.......... i have tried everything keeping MSKEYVALUE and removing MKEYVALUE and tested it but same error.........
And it is not giving me any database connectivity problem..........
I have not much idea about IDM 8.0 however I think concept here will be same as IDM 7.2
In IDM 7.2, we need to pass the value for each attribute in destination Tab. Your Value column seems empty here. Please try passing the value for each attribute (MANDT, BNAME & ANAME).
for example If you are passing LastName to BNAME then write it as %LastName% in the value column in front BNAME. Similarly you need to pass value for each attribute.
Note - All the value which you will pass here should be present in the output of source query.
could you please post your queries as questions/discussions?
Please explain the issue in detail, provide screenshots of config (source and destination) you have tried and of error messages, and mention relevant IDM component versions in your post so that people can help you better.
source is ECCDEV and connected through jdbc:odbc driver and destination is CUA and connected through jdbc:odbc driver andgetting this error
JDBCHandler constructor failed connecting to DB jdbc:odbc:SMD
java.lang.Throwable: No suitable driver found for jdbc:odbc:SMD,
but for source it is not throwing error ........ SMD is my destination db
And as said
passing LastName to BNAME then write it as %LastName% in the value column in front BNAME. Similarly you need to pass value for each attribute.I have given the values to each and every attribute
SAP docs are well explained and very helpful however If you are facing any issue/error to provision to target system, you can always start a discussion at SAP Identity Management/
While starting a discussion at SAP Identity Management, please also mention the Target system Name as SAP IDM uses different Repository & Connectors based on the target system.
My team and I are new to IDM 8.0 and are in the process of building a system for proof of concept. Your demo filled in many of the gaps I had from my reading of IDM literature. The video was very informative and the scenarios you provided gave us a better understanding of how to load and synchronize data from multiple sources. I'll have to take a look at some of the other tutorial and learning references you provide.
I am very novice in SAP Identity Management is the first time that used it, and maybe you can help me.
I started to work in a SAP Identity Management Project. I want to integrate as primary source for identity information SAP HCM.
Nowadays my client has SAP ECC 6.0 on SQL Server 2008 but there are a migration plan SAP ECC on hana, so I wondering, if I start to work with the actual versión and then do a upgrade, is a good option?, I mean, What I should do to upgrade IDM to the new SAP ECC ? If would be dificult?I will appreciate your help.