Skip to Main Content
Spotfire Ideas Portal
Status Implemented
Product Spotfire
Categories API
Created by Guest
Created on Feb 6, 2016

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
  • 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 ?