We have a pretty complex AD environment and we use CSV files from Human Resources as the data source. Are there any tutorials or recommendations on using a SQL database to keep information straight in Adaxes?

by (3.2k points)

1 Answer

by (307k points)
Best answer
0 votes

Hello,

It is possible to create new and update existing user accounts based on the information from an SQL database using Powershell scripts. For information on how to do this, check the following script in our repository: http://www.adaxes.com/script-repository ... e-s249.htm.

by (3.2k points)
0

I have been reading that the timeout for Adaxes is 10 minutes. The DB we would using houses near 10,000 employees and countless tables. We had the idea that we would use this DB as our definitive data source and alter (modify or create) accounts based on the information in the DB daily.

  • Will we need to break up the cycle to get all the way through?

  • Is this a recommended practice?

  • Do you have recommendations on other ways to keep the data up to date?

Related questions

Hi, By chance I noticed a typo in one of the columns used by the logging database (2025.1 v3.17.23904.0). The column is called OpeartionState and I assume it should be OperationState. So the E and R are swapped.

asked Nov 19 by wintec01 (2.4k points)
0 votes
1 answer

Hello, I seem to have an issue with viewing logs: I am using the default built-in log database: What is causing this? I am using the latest version of Adaxes.

asked Sep 12 by Edogstraus00 (590 points)
0 votes
1 answer

Hi , i want to export users are in specific archive database named ARCHIVE01 using report function. How can i do that? I want to see how many users are using ARCHIVE01 as a Archive Database?

asked Dec 2, 2024 by vagifazari (470 points)
0 votes
1 answer

We will be migrating from the default logging in the SQL Express database to a fully licenses MS SQL Server database. We would like for the existing logs to be ported over as well.

asked Dec 28, 2022 by bsteele (90 points)
0 votes
1 answer

I have problem to connect mysql to adaxes, what adaxes is support mysql or not suport mysql. can you give a sample script to connect adaxes to mysql?

asked Jan 5, 2022 by systech (100 points)
0 votes
1 answer