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 |
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.
include user authentication Y/N would help a lot too for admins!
Is this still under consideration? Ability to access DataSource Properties like Server Name, Database Name, et from the DataManager or DataTable is definitely valuable.
Is this the same like request https://ideas.tibco.com/ideas/TS-I-5566 ?