Update data from TIBCO Clarity to TIBCO Data Virtualization

[Ramu Chowdam 3]

Hello all,

I'm working on a solution where cleansed data from TIBCO clarity should be published to TDV and this data from TDV will be consumed by TIBCO BW interfaces. I don't see any option to publish the data from Clarity to TDV. Any pointers on this

Thanks,

Ramu Chowdm.

[Laszlo Darazsdi]

Is this still actualClarity tagscleansed data. Also,TIBCO clarity has services that can be called byTDV.

[Steven van der Kroft]

Hi Ramu,

Do you mean actually publishing the result to TDV

I would expect to pubish to a data source and have TDV consume this data source when being updated. Clarity does publish to databases directly

Alternatively you could access the TDV APIs to create the data sources

[infohills]

You're right, TIBCO Clarity itself doesn't offer a direct publishing option to TDV. However, there are a couple of workarounds to achieve your goal of getting cleansed data from Clarity to TDV for consumption by BW interfaces:

1. Export and Import:

• Cleanse data in TIBCO Clarity: Use Clarity's data preparation capabilities to clean and transform your data.
• Export the cleansed data: Export the prepared data from Clarity. Clarity supports various formats like CSV, Excel, and relational databases.
• Import data into TDV: In TIBCO Data Virtualization (TDV), you can import the exported data using its data import functionality. TDV supports various data sources, so you should be able to import your chosen format.

2. Leverage External Tools:

• ETL tools: Consider using an Extract, Transform, Load (ETL) tool as an intermediary. You can do data enrich from Clarity, transform it within the ETL tool, and then load it into TDV. Popular ETL tools include TIBCO BusinessWorks (BW) itself, Informatica PowerCenter, or Microsoft SSIS.
• Custom scripting: If you're comfortable with scripting, you can write scripts to interact with both Clarity's API (if available) and TDV's data import mechanisms. This approach requires more development effort but offers greater flexibility.

Edited March 14 by infohills