Choosing the database to connect to.

 

Now that you have chosen the profile name, put in the license key, if the product has been purchased, you are ready to connect to your source database.

 

The source database is the database where your employee information sits. That might be in the database behind your Intranet e.g. a Microsoft SQL Servert, it might be an Access database or it could be any other datasource like ORACLE or DB/2.

 

You connect to a database by determining which type of database you access, the location, the database name and there might be a username and password you should type in. Everything will be put into the connection string that determines the location of the database fully.

 

IMPORTANT: The field used to identify a user uniquely should reside in a column called 'accountName'. This field should contain the logon account name which will be matched to the account name field in Active Directory. This is the way activeImport identifies the user and finds the user object in Active Directory.

 

Examples are:

 

* Connect to an Access database located in \\dc1\employeedir, Access database name employee.mdb, the connectionstring will be

 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\dc1\employeedir\employee.mdb

 

* Connect to a SQL Server on server 'SQLSERVER01', the employee directory is in the database 'INTRANET' in view or table 'EMPLOYEES'. You log on to the database with username 'admin' and password 'pass'. The connection string will be

 

Provider=SQLOLEDB.;server=SQLSERVER01;Database=INTRANET;initial catalog=EMPLOYEES;User id=admin;pwd=pass

 

Please use the 'test' button to establish connection to the database.

 

Screenshot of the settings

 

After having put in the connection string and tested that the connection is OK and types the table name in the next field you van verify the view and hence you will see how many fields are available in the database as your data source:

 

 

 

 

 

 

 

---

Page url: http://www.officeaddon.com/help/index.html?connecting_to_the_intranet_or_.htm