Spotfire Ideas Portal
Currently you barely have any options when setting up an ODBC connection (In our case to DB2). We need the feature to be able to set the isolation level to uncommitted read to increase the database performance and to prevent lockings.
The setting sets the reads on the database to not lock the database while doing it. Not having this option is a risk when writing data to the database at the same time as reading others.
Yes, the JDBC connections are more customizeable. For ODBC this is not possible though. You only get a basic set of fileds for entering your connection parameters but none for extra options.
Well I haven't used Data Connectors much but when you use JDBC connections for Information Links you can define any custom JDBC connection property the JDBC driver supports in the data source template. Is there no equivalent file to set ODBC connection properties?
Yes, totally. Information links are not used by us because they do not perform well when accessing data with a ton of rows.
Did you really mean to say ODBC connection, which only works for Data Connectors, rather than JDBC which works for Information Links?