Data Marketplace use case. How to automatically extract connection string and query parameters from Spotfire or TDV

[Osiel Ángeles]

A Bank wantsto establish a data marketplace to democratize and facilitate access to different internal analytics users such as data scientists. They want to provide a self service platform to explore data from different sources and automatically, with just a click, generate the connection string and the query used (select, distinct, join, group by, where, etc.). With that, they would like to cut and paste the parameter in another tool like TensorFlow, Python, DataIQ, or whatever they want to develop their models or dashboards.

It is also intended that the ecosystem of analytical tools be connected to a single point of access to information.

I have been thinking on TDV as the single point of access between data sources and consumers and use Spotfire for exploration.

The challenge is that once the exploration is done, how to automatically generate the connection string and the query parameters. Howdo you think I couldsolve it

Thank you in advance for your support. Regards.

[Pavan Lingam]

Hello there,

There is no out-of-box methodto return the endpoints for any published artifacts in TDV. You may want to log an enhancement request using the 'Ideas' portal. If this is an important usecase, you may want to talk to TIBCO PSG team to see if they can offer you any custom solutions.

 

Best Regards,

Pavan

[Brad Shao]

Hi,

For quick exploration of the data that is revealed by the TDV services, our Business Directory dashboard application can easily and quickly browse row data.

However, if your purpose is to obtain the data source connection info in order to utilize another client tool outside the TDV scope, then there isn't an easy way to do this.

A call to our system web service /services/webservices/system/admin/resource/operations/getResource would be able to obtain much of the connection attributes in a large xml document, and the user would need to scan through the document to find the pieces of info they need.

 

 

Thanks,

Brad

[Michael Matovic]

TIBCO Data Virtualization will embed a new Web based GUI that let consumer manage data (join, union, alias, ), create their own virtual datalabs and simply publish it. So with that new GUI they can easily prepare, publish and then consume that virtual layer with any external tool (TensorFlow, Python, DataIQ) without need to extract the connection string and the query. This will give a single access point for their data (REST/SOAP/JDBC/).

If interested, Ill be able to tell you more about this new GUI in few weeks.