We would like to move the users from a one Identity system to WSO2 IS. Both userstores reside on a SQL DB. We would use SELECT INTO (INSERT INTO SELECT) at the database level to move the users from the old Identity Store to WSO2 IS. Will this cause any issues with the data integrity? Or should we just use the WSO2 IS APIs instead?
Importing users into a WSO2 IS User Database
843 Views Asked by Saqib Ali At
1
There are 1 best solutions below
Related Questions in WSO2
- Auto redirection in WSO2 API
- writing into file using VFS -WSO2 ESB 4.8.1
- how can I improve the response of BPS
- How to route by call method in proxy with WSO2?
- writing into file (Converting Base64 to Binary) values Using VFS and ESB 4.8.1
- How to publish wsdl when using different endpoints in proxy with WSO2?
- Importing users into a WSO2 IS User Database
- WSO2 IS - Do a Single Logout using the IdentitySAMLSSOService
- Wso2 DSS Tenant Endpoint Url not working
- How to deploy API Managers behind ELBs on AWS and preserve X-Forwarded headers?
- Is one XACML file per user a good approach?
- Changing WSO2 / Synapse to expose CXF service instead of AXIS2
- Fault Sequence ERROR_CODE property is not generating error as expected in wso2
- WSO2 ESB returning HTTP/1.1 413 Request Too Long for GET with url of 8k characters
- WSO2 MDM Connection Failer
Related Questions in WSO2-IDENTITY-SERVER
- Auto redirection in WSO2 API
- Login with openid on wso2is from java application
- Importing users into a WSO2 IS User Database
- WSO2 IS - Do a Single Logout using the IdentitySAMLSSOService
- Is one XACML file per user a good approach?
- How to identify the user from the User Token in WSO2 API Manager
- Web API calls Authentication in WSO2 IS
- Can I disable or remove the wso2 identity server resident service provider?
- Integrating AngularJS application with WSO2 identity server
- Service Provider and Identity Providers lists do not show changes in cluster node with WSO2 Identity Server
- Resolving localhost in email template in WSO2 IS
- org.apache.axis2.AxisFault: Message Receiver not found for AxisOperation: requestSecurityToken
- WSO Identity Server HA Cluster
- Adding users to WSO2 Identity Server using SOAP API without specifying a password
- Manage external custom permissions with WSO2 Identity Server?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You have your users in separate user DB (say foo user store) and you need to move all users in to WSO2IS user store schema..? It mostly depends on the how user's password has been stored in the foo user store.
If password is stored as plain text (or encrypted as it can be decrypted), you can WSO2IS APIs to add users which is mostly the best option. You can write some tool to read from foo DB and call the API of WSO2IS. User Mgt API can be used for it. More details from here
If password is stored as hashed, then we can not use the APIs and we need to use some database level migration. You can move to username and user's password in to UM_USER table and user's attributes in UM_ATTRIBUTE tables.
But, please note, if your foo DB has used some different password hashing schema which is not supported by WSO2IS, above migration also would not be success out of the box. By default WSO2IS supports for SHA-1, SHA-2 hashing methods only. If it is not, you may need to do some customization.
However, why you are trying migrate it to WSO2IS schema? Can't you write a custom user store manager implementation for your foo DB and connect WSO2IS in to your existing user store ? I guess, it is more convenient than migrating.