Skip to Main Content
Spotfire Ideas Portal

Need to be able to fetch the DatabaseDataSourceSettings using API


We need an API to be able to read the DatabaseDataSourceSettings of a data table created using File-Open-DataBase (database DataSource oracle database). As per the documentation from STN at http://stn.spotfire.com/stn/API.aspx?API=dxp%2fhtml%2fP_Spotfire_Dxp_Data_Import_DatabaseDataSourceSettings_ConnectionString.htm&Article=%2fstn%2fDefault.aspx&usterms=connectionstring&uscat=3
it says that it "Gets or sets the connection string. ", but there is no possible way to get the database source settings information.
The customer has to say the following:

================
How to use Python script to get the DatabaseDataSourceSettings (need to sqlSatement, provider and connectionString) information of a datatable in dxp file that was created using File-Open-DataBase (database DataSource oracle database)?
================

Implemented in 7.10
  • ADMIN RESPONSE
    Aug 8, 2017

    A new Data Table Source View API has been introduced as part of the 7.10 release. With this API it is possible to read and modify the source view that defines a data table.

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Jun 9, 2017

      include user authentication Y/N would help a lot too for admins!

    • Guest
      Reply
      |
      May 2, 2017

      Is this still under consideration?  Ability to access DataSource Properties like Server Name, Database Name, et from the DataManager or DataTable is definitely valuable.

    • Guest
      Reply
      |
      Feb 20, 2017

      Is this the same like request https://ideas.tibco.com/ideas/TS-I-5566 ?