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?
Related Questions in WSO2
- How to make gRPC request in WSO2 micro-integrator via Postman?
- Following PATTERN 3 Deployment ,Not able to consume apis in Gateway
- WSO2 change localhost - ERR_CERT_AUTHORITY_INVALID
- How to resolve unauthenticated error after calling REST API endpoint to update the Challenge Questions in WSO2 v5.11.0?
- Enable logging for API calls in wso2 identity server
- How to set weight of enpoints durin laod balancing in wso2 manager
- old apikey dont works for newly subscribed apis in wso2 apim
- WSO2 API-M: What is Synapse and why it spits following error: I/O error: Connection reset java.net.SocketException: Connection reset?
- how to upgrade httpcore-nio plugin of wso2 api manager
- Amazon RDS PostgreSQL - Caused by: java.net.UnknownHostException: yyyy.xxx.us-west-1.rds.amazonaws.com in WSO2 EI docker container
- How to Extract Queue Name, Priority, and Message ID from RabbitMQ Inbound Endpoint Messages in WSO2 MI 4.2?
- how do i manage role and permission in server side for my predefined roles and assign permission in wso2 identity server?
- Installation process of wso2 Enterprise integrator
- WSO2 - SSL troubleshooting: ERR_CERT_AUTHORITY_INVALID
- How to do error handling in Clone-Aggregator mediator in WSO2 Micro Integrator?
Related Questions in WSO2-IDENTITY-SERVER
- Enable logging for API calls in wso2 identity server
- how do i manage role and permission in server side for my predefined roles and assign permission in wso2 identity server?
- Login/initiate session in WSO2 Identity Server 5.11.0 without using UI
- Display attribute data in password-recovery-notify.jsp
- wso2 IS - User store connection lost
- JSON string wrapping within another JSON object
- Create Secondary User Store with LDAP in WSO2IS 5.11.0 via deployment.toml
- WSO2 - Security patches link / location
- wso2 api manager throws error with key managers
- WSO2 IS Recovery password / Home
- WSO2 - Identity Server 6.1.0 - Sign in with google
- Updating Client Application using DCR endpoint not working in WSO2 IS V6?
- WSO2 Identity Server SCIM API to retrieve a list of Groups
- WSO2 Identity Server updating SP/IDP error 6.1.0
- I wanted to use ISO8583 mediator but I am facing the following 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?
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)
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.