Need insights on DataDeploy capabilities

mimidep

Hello,

We are currently developing a new application and evaluating DataDeploy. We have several questions regarding the product:

- Can DataDeploy access TeamSite Basic Attributes and deploy to a User Defined Schema (DB2)?
- Can DataDeploy access TeamSite Extended Attributes and deploy to a User Defined Schema (DB2)?
- Can DataDeploy be used to access the iw-store and store a selected file as a CLOB in a DB2 table?
- Can DataDeploy be used to query a table in DB2 and set the result as a TeamSite Extended Attribute on a selected file?
- Can DataDeploy be used to derive values from the file Vpath and update DB2?

To help you answer these questions, let me give you some background on our TeamSite and DB2 configuration.

TeamSite branch and workarea are organized as followed:

- Main
|_ Repository
|_ Editions
|_ Staging
|_ Workareas
|_ BusinessArea_1
|_ Editions
|_ Staging
|_ Workareas
|_ User1
|_ BusinessArea_2
|_ Editions
|_ Staging
|_ Workareas
|_ User1

The main table to be updated in DB2 has the following columns:

ID Primary Key – TeamSite Extended Attribute
BusAreaName From Vpath, i.e. BusinessArea_1
Filename From Vpath
Fileextent From Vpath
Vocabulary TeamSite Metadata
AuthorID TeamSite Metadata
Category TeamSite Metadata
Tag TeamSite Metadata
Created TeamSite Basic Attribute
LastModified TeamSite Basic Attribute
ArtifactFile CLOB - From filesystem
Deleted Flag – no value in TeamSite

Note: We don’t want to create a metadata capture template for all of the column in the database as it would be prone to user input error. As stated in the table above, some of the value can be extracted based on either TeamSite Basic Attribute or the file Vpath. The ID is a value generated in DB2 and applied as TeamSite Extended Attribute on the file.

Your feedback is much appreciated.

Regards,
Myriam Depauw