We're developing a Wordpress website (at WPEngine) and need help with a members section (only). The member section will require a secure login (possibly using Firebase, but open to suggestions) and need to push and pull encrypted data from and to an external SQL 2017 Server Database. The database will be open to connections. Once logged in the users will have access to update and edit personal details such as name, address, phone numbers. There will be other "read only" sections of data coming in from the MsSQL database as well. We do not want Wordpress to "hold" any client data at all or do any validation of credentials. However we do want Wordpress to be used in parts, ie WP Menus, custom fields for other elements. An attached PDF might help.
For set up we will have a test DB set up with test data that will mimick the live database. Then to go live it we hope it can then be a case of changing connections strings to the real site. We can provide logins and access to a test environment for development. Discretion is a must. Budget is a guide at this stage and we can determine timelines on acceptance. Thank you.