Automated scripts for AD to MS SQL synchronization

$10-30 USD

Closed

Posted

over 8 years ago

$10-30 USD

Paid on delivery

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

Project ID: 9210605

About the project

13 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

13 freelancers are bidding on average $37 USD for this job

@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 in 1 day

5.0

(1 review)

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 in 1 day

5.0

(2 reviews)

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 in 30 days

5.0

(2 reviews)

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 in 2 days

0.0

(0 reviews)

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 in 1 day