Jump to content

Add DataTable from database via IronPython in Spotfire

Holger Schimanski 2

Recommended Posts

I would like to add a new data tableto a workbook viaan IronPython script.

This new data table should be imported from a database.I would dynamically definein the IronPython script, which table from which schema and use the Oracle database connection in the workbook.

And then as an additional step I would like to add a table visualization with this new data table in a new page of the workbook to allow browsing of the data.

Any idea how to do that

Link to comment
Share on other sites

Hello Holger,

You can have a look at this page (https://community.spotfire.com/wiki/ironpython-scripting-tibco-spotfire), where you can find lots of iron python code snippets to start building your own code.

Especially theselinks might be a good starting point for you:





You could combine a couple of these above mentioned links in setting up the code for the database connection as well as store it in a new data table and create a visualization on top of it.

Kind regards,


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...