How to connect to database to create the XML data
AA Adaptor connects to access, SQL server, SharePoint user profile, Oracle database and linked active directory and generates XML data required for the chart.
For more information about AA Adaptor (Version 2.2 for WSS 3.0) click on the following link.
http://www.aasoftech.com/Download/Pages/AA_AdapterUserGuide_2.2.pdf.
To download AA Adaptor (Version 2.2 for WSS 3.0) click on the following link:
http://www.aasoftech.com/Download/Pages/AAAdaptor_2.2.zip.
For more information about AA Adaptor (Version 1.6 for WSS 2.0) click on the following link.
http://www.aasoftech.com/Download/Pages/AA_AdapterUserGuide_1.6.pdf.
To download AA Adaptor (Version 1.6 for WSS 2.0) click on the following link:
http://www.aasoftech.com/Download/Pages/AA_Adaptor1_6.zip.
How to connect to SharePoint user profile
AA OrgChart WebPart (Version 2.2) can connect directly to User profile. For more information look at the help document Chapter 7.
How to connect to linked active directory
In order to use active directory from our adaptor program you can link Active directory to SQL server using the following command:
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource'
Following article explains how to use AD as a linked server in SQL, then use a view to query AD information:
Then you need to create a view for this active directory. You can create a view in SQL server like:
SELECT title as JobTitle, displayName as Name,manager,department as DeptName,
mail as Email, telephoneNumber as Telephone,info as Category,info as Picture,
displayName as ORG_ID, manager as MGR_ID, 0 as 'Secretary',
(CASE WHEN manager IS NULL THEN 0 ELSE 1 END) AS 'HasParent'
FROM OpenQuery(ADSI, 'SELECT title,manager,mail, info,department, displayName, sAMAccountName, givenName, telephoneNumber, facsimileTelephoneNumber, sn FROM ''LDAP://DEV'' where objectClass = ''User''')
Now from the adaptor application you can connect to this database using the above view.
Followings are two samples of the SQL Connection string that can be used by our adaptor.
Example 1:
<add key="ConnectionString" value="Server=WSS2DEV;Database=SharedServices1_DB;Integrated Security=SSPI;"/>
Example 2:
<add key="ConnectionString" value="Data Source=YourSharePointSQLServer;Initial Catalog=YourSharedServicesdatabaseName;Integrated Security=SSPI;"/>
