Jump to content

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

Osiel Ángeles

Recommended Posts

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.

Link to comment
Share on other sites

  • 1 month later...

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,


Link to comment
Share on other sites


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.





Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...