Hi,
I think you can find useful the following question with a detailed answer regarding the Spotfire configuration to connect to VDP:
https://community.denodo.com/answers/question/details?questionId=90670000000k9i9AAA&title=Spotfire+Data+Source+Template+for+Denodo%3F
To correctly configure Spotfire it is **very important** to set the property ***autocommit=true*** in the connection configuration. Spotfire by default creates transactions (surrounding with BEGIN/COMMIT) for all the queries, even for select statements.
Virtual DataPort uses a distributed transaction manager, which uses a 2-phase commit protocol. This protocol introduces overhead and queries will run unnecessarily slower.
Since update denodo-v55-update-20160322 for 5.5 and denodo-v60-update-20160429 for 6.0 the vdp JDBC driver supports the optional URL parameter ( autoCommit=true ).
Therefore, the URL configuration should look something like:
```
jdbc:vdb://acme:9999/denodo_database?queryTimeout=9000000&chunkTimeout=1000&userAgent=SpotFire&autoCommit=true
```
I would recommend to add this property to the template in Spotfire. Something like:
```
<connection-url-pattern>jdbc:vdb://<server>:<port9999>/<data_base>?userAgent=SpotFire&autoCommit=true</connection-url-pattern>
```
