SQL and Adaxes

Question

Hello Support

We are looking to integrate Adaxes with the HR SQL data warehouse. We found the http://www.adaxes.com/script-repository ... e-s249.htm and have some questions as to how it will work.

Our thoughts are that we will have the SQL database compare yesterday's SQL table to today's and that way we only make changes to the accounts that have changed instead of having to "touch" every account. Please let us know if this is acceptable and recommended method.

We are thinking that we will drive the creation, modification and deprovision of accounts all during the same time. Is this the recommended process? This way we believe we can run it once during the night and make all changes at once.

Thank you
for all your continued support
Jay

Answer 1

Hello Jay,

Our thoughts are that we will have the SQL database compare yesterday's SQL table to today's and that way we only make changes to the accounts that have changed instead of having to "touch" every account. Please let us know if this is acceptable and recommended method.

It is an acceptable approach and can be achieved using PowerShell scripts.

We are thinking that we will drive the creation, modification and deprovision of accounts all during the same time. Is this the recommended process?

We recommend separating the processes as it can take long time to execute the script.