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

Migrateduser

DataDeploy cannot access the basic attributes. You have to write external tuple pre-processor callout to retrieve it and supply to DD. Once this is done, you can deploy to UDS/DB2.

Yes., DataDeploy can access TeamSite EAand deploy to a UD/DB2.

Yes., you can use is-url to specify the URL of the file in the backing store whole content will be deployed. Beware though, if TeamSite has an open handle on the file in the backing store in exclusive mode, DD will get permission errors.

No., DataDeploy cannot be used to set EAs.

I don't understand the last question. What you mean "derive" values from the file vpath? What kind of values you expect to derive using the vpath? Is it filesystem properties of the file?

IN anycase, you should be able to combine basic & extended attributes in a single deployment. You would define the value mappings for extended attributes in UDS definition and map basic attributes to virtual fields. You would write the Java class for exernal tuple processor whose methods will be invoked by DataDeploy with the vpath of the file being deployed. Using that vpath, you can extract the basic attributes either using OpenAPI or using java.io.* package and supply to DD. This way you fool DD as if the data is coming from the "source".