Jump to content
We have recently updated our Privacy Statement, available here ×

Update data from TIBCO Clarity to TIBCO Data Virtualization

Ramu Chowdam 3

Recommended Posts

  • 3 months later...
  • 3 years later...

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 by infohills
Link to comment
Share on other sites

  • Create New...