Automated scripts for AD to MS SQL synchronization

$10-30 USD

Cerrado

Publicado

hace más de 8 años

$10-30 USD

Pagado a la entrega

We have an HR / Finance system that runs on MS SQL server and we run Microsoft Active Directory Services. I'd like to run a script on a scheduled basis that would look for changes in the HR system and update our AD and vice-versa. Employee titles, locations, demographic info, etc...

Active Directory

Microsoft SQL Server

ID del proyecto: 9210605

Información sobre el proyecto

13 propuestas

Proyecto remoto

Activo hace 8 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

13 freelancers están ofertando un promedio de $37 USD por este trabajo

@dogradiwakar

This can be done using a linked server and then doing a open query to retrieve data from Active directory .For keeping the data synchronized a ssis job or a sql server job can be created to keep the data updated on regular basis

$55 USD en 1 día

5,0

(1 comentario)

2,7

@ArleMedina

I know how to synchronize objects from Active Directory data to a SQL Server database and vice-versa. I am able to: - Let SQL server maintain the anchor attribute for objects. - Implement different object types in SQL Server. - Handle multi-valued reference attributes in form of group membership. - Synchronize data from SQL Server to Active Directory

$15 USD en 1 día

5,0

(2 comentarios)

2,2

@yubor

hi there. could you provide more details about your task? as i understand your hr-system in mssql uses windows authentication and you need sync ad user properties with user attributes in mssql database. is it right?

$15 USD en 30 días

5,0

(2 comentarios)

1,5

@vw6871927vw

Fluent English speaker with great communication skills and a strong SQL (7+ years of SQL Server and Oracle combined) background.

$27 USD en 2 días

0,0

(0 comentarios)

0,0

@DeepakMSBI

Question : What is the Active directory services version and MSSQL version ? Solution steps : An SSIS package ,SQL script, PowerShell script to be created and either of them can be scheduled over SQL agent job. Inside SSIS , again an SQL ,.NET script, PowerShell can be used and SSIS can be scheduled in SQL agent job. The other way is to schedule the SQL, SSIS, PowerShell directly in agent job. Details about my experience : I am a Microsoft community Contributor for 2011 awarded by Microsoft and have been effectively executing data migration, data warehousing projects in MS SQL 2012, 2014. Also worked in 2000,2005,2008,2008R2 as well.

$25 USD en 1 día