How to get the custom attributes using the Active Directory adapter in TIBCO Data Virtualization?

How to get the custom attributes using the Active Directory adapter in TIBCO Data Virtualization?

book

Article ID: KB0071653

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

In the introspected list of resources for the AD adapter, there should be a procedure 'GetAttributes()' that can be used to achieve this use case.
 

Resolution

Steps to fetch the custom attributes:

1. Open 'GetAttributes()' procedure and check the 'DesignMode' checkbox located at the top right corner. Click OK if any prompts show up.

2. Use the green (+) button to create a CURSOR

3. Click on the <-> direction button twice to change the CURSOR direction to OUT. Hovering on the CURSOR would tell you the current direction.

4. Now, click on the cursor and then click on the green (+) button to add 2 VARCHAR values (for 'AttributeName' and 'AttributeValue')

5. Right-click on the 'varcharColumn' and rename it to 'AttributeName'

6. Similarly, create another varcharColumn for 'AttributeValue'. Note that these VARCHAR columns are a part of the cursor created in step (4)
User-added image

7. Save the changes made.

Issue/Introduction

This article summarizes the steps required to get the custom attributes using the Active Directory adapter in TIBCO Data Virtualization.