How to retrieve table column values from SQL Server(in-database) data sources

[Raj Joseph]

Hi Team,

the custom extension does not load the data when we using data sources as "Microsoft SQL Server".

I would like to know the way ofdata fetching method from SQL tables(External Tables).

I have to access a table data from an in-database connection(SQL Server) and loads data into the Tibco Spotfire custom extension

Tibco version in use: 10.2

Problem definition:

 

data not loaded from external tables when connected with SQL data sources.

please note that Tibco Spotfire supports SQL connected data sources when we select the load method as "Imported Data Only". but it doesn't proceed with real data, which means data not get updated if table values get changed, and imported rows also limited. an application needs to load data for all the load methods.["Allow All Methods","External Data Only","Imported Data Only"]

 

I would appreciate helping to resolve this issue and wait for your response. please let me know if you need further more information.