Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 486

Kill existing Data Source connection to the database.

Sometimes the existing data source connection (say A)to the database hangs and no more new connections are established until the old connections are released. Though this can be increased(max connections) at data source level, a) It will not cl...
over 5 years ago in Spotfire / Information Services 1 Already exists

Official support to connect to MongoDB via JDBC

Although you can use a JDBC driver on the Spotfire server and connect to MongoDB via Info Links, this is not yet officially supported as I was told. Consequently I do not get support as I'm having weird issues. Since Mongo is more and more used, o...
over 7 years ago in Spotfire / Data Access 6 Future Consideration

Change default encoding to Unicode (UTF8) when replacing data table in Spotfire using Ironpython script

refer to the support ticket - 01862613 We have code in place which replaces data table based on dynamic parameter passing for multi clustered sql data. This works perfectly fine in english. But since because the encoding cannot be done before load...
almost 5 years ago in Spotfire / Data Access 3 Future Consideration

Open session commands (pre post statements) for data connections

We have many data sources that implement row level security using features such as Oracle’s VPD. This relies on the ability for Spotfire to provide the end user identity whenever running SQL on the database - which is easily achieved using the Ope...
almost 6 years ago in Spotfire / Data Access 6 Future Consideration

Define information link using arbitrary SQL

Bring a custom SQL over and have Spotfire create an information link from it.
about 9 years ago in Spotfire / Data Access / Information Services 4 Future Consideration

Support local trust across multiple machines when working on application server farms

According to https://support.tibco.com/s/article/Tibco-KnowledgeArticle-Article-44214 there are two options for trusting. Option #1 where the user can only trust their own queries is a useful method if you want to a) avoid that users are getting t...
almost 4 years ago in Spotfire / Data Access 2 Future Consideration

Connector for Microsoft SQL Server Analysis Services to support tabular models with DAX querying

Currently the Spotfire connector for Microsoft SQL Server Analysis Services works well with multidimensional models (using MDX queries). To handle tabular models more efficiently, the connector should push down DAX queries from visulizations and f...
almost 2 years ago in Spotfire / Data Access 0 Future Consideration

Spotfire should support any ODBC DSN in-database

Spotfire should support any ODBC driver and DSN in-database so that we could connect to any ODBC compliant data source using connectors and in-database live query analytics. It's also important to have all connection string options available when ...
over 6 years ago in Spotfire / Data Access 0 Future Consideration

Vertica Connector Improvement

We are using Vertica Connector keeping data in the external system (in-database) and we detect lot of missing function that are not available on Spotfire. Below the function we'd like to have: Date function (eg. Current_date,TimestapAdd, DateDi...
almost 8 years ago in Spotfire / Data Access 1 Future Consideration

Allow configuring user rights for information designer and data connections with identical right sets

Independet from whether data is accessed using information links or data connections a company would like to be able to control the user rights in an identical way. In our case we would like to be able to define three analyst levels where „setting...
about 4 years ago in Spotfire / Data Access / Information Services 0 Future Consideration