Spotfire DB connection in python script

2k Views Asked by At

we are doing tagging in Spotfire. For this purpose we are using a python script. inside that script for data source connection we are using follwong code.

dbsettings = DatabaseDataSourceSettings( "System.Data.OracleClient","Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx.XXX.com)(PORT=1530))(CONNECT_DATA=(SID=xxxx)));User Id=xxxx;Password=xxxx45",sqlSelect)
ds = DatabaseDataSource(dbsettings)

Is there any way not to hard code this.Can we take in data source connection that is configured in library? For example, is there a way to call below attached data source in python script like, dbsettings =Datasource:Sample data source
(Sample data source is the data source configured in libarary)

(please see the attached picture)Data source from library

0

There are 0 best solutions below