Follow these instructions before installing the Data Integrator client on the new users machine.

1. Give the user rights to the SQL Server database repository server.
boxi2.1Open SQL Server Enterprise Manager – Connect to the Database Repository Server. Ex: DIServer
Expand Security and right click on Logins – Select New Login
Select Search to find the user in active directory and add them

 

 

 

 

 

2. Create the Repository Database for the user

boxi2.2

Open SQL Server Enterprise Manager – Connect to the Database Repository Server. Ex: DIServer

Expand Security and right click on Databases – Select New Database
Following the naming convention for the database name
Ex: BODI_REPO_DEV_USER
The Owner should be the database user you just added to SQL Server
Ex: DOMAIN\UserName
Set the data file to 30mb

 

 

3. Create the repository tables in Data Integrator
boxi2.3Open the Data Integrator Repository Manager (You should have this app on your machine.
Database Type: Microsoft_SQL_Server
Database Server Name: Ex: DIServer
Database Name: Ex: BODI_REPO_DEV_USER
Check Windows Authentication

 

 

 

 

4. Select Create – If you get an error check the spelling of your Database server name and database name.

5. Setting up the Job Server – Each user will need a repository connection to the job server. This is setup in the server manager.

boxi2.4If you do not have Data Integrator Server Manager installed on your machine you will need to remote desktop to the Data Integrator Job Server machine.
Example: DIServer Open the Data Integrator Server Manager

Select Edit Job Server Config
Highlight one of the job servers and select edit

 

 

 

 

6. Select Add in the Job Server Properties Box

boxi2.5Database Type: Microsoft_SQL_Server
Database Server Name: localhost – Because you are on the repository server
Database name: Ex: BODI_REPO_DEV_USER
Check Windows Authenication

Then Select Apply and OK
Select OK on the Job Server Configuration Editor
Check with all DI users to make sure no one is running any jobs. Then select

 
7. Restart on the Data Integrator Server manager.

Select OKboxi2.6.
Install Data Integrator software on the users machine
Make sure you have admin rights to the users machine or the install will fail.