0 votes

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

by (3.2k points)

1 Answer

0 votes
by (270k points)
selected by
Best answer

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.

Related questions

0 votes
1 answer

Hi All, I am currently using the 30 day free trial of Adaxes and seeing if we can use it to achieve our method of user provisioning. I am looking into server-side ... variable value within an SQL query Can this be achieved? Any help is much appreciated, Thanks

asked Feb 1 by Lewis (40 points)
0 votes
1 answer

Our SQL DBAs are working to move most/all our SQL connections to SSL. They have asked if Adaxes can support this.

asked Feb 22, 2021 by ggallaway (300 points)
0 votes
1 answer

Dear Adaxes team, Please confirm if Adaxes 2019.1 support SQL server 2017 for logging database. Also suggest Adaxes steps to perform if we are migrating our logging database from SQL server 2012 to SQL server 2017

asked Apr 16, 2020 by kushal.gaurav (20 points)
0 votes
1 answer

We are planning to use Adaxes in our environment and before proceeding, we need to understand the firewall port requirements for Adaxes service to work. What are the firewall ports needed between Adaxes and AD domain controller?

asked Jan 24 by Renugopal (120 points)
0 votes
1 answer

We are in the process of updating our Active Directory Domain Controllers to server 2022 and the Domain/Forest function level. Our concern is that we still have Adaxes ... version of Windows server for our DCs and the Domain/Forest function level of 2016?

asked Oct 11, 2023 by sphoeinix (20 points)
3,326 questions
3,026 answers
7,727 comments
544,681 users