By default, Spotfire can connect to several data source types using the following drivers: ODBC, OLE DB, OracleClient and SQLClient. OLE DB UDL files can also be opened directly using File > Open.... Other data sources may also be available depending on your installed data providers.
General data connection recommendations:
Preferably, use Information Services and create an information link to retrieve your data.
If you need to use SqlServer, use the SqlClient Data Provider.
If you need to use Oracle, install the Oracle Data Provider for .NET (ODP.NET) on all machines that need to reach the database. It is faster and better than the default data provider for Oracle.
It is not recommended to use the OracleClient Data Provider because is at least twice as slow at retrieving data (compared to the other options) and even slower at retrieving metadata.
Use OleDb rather than ODBC, since ODBC only refers to a local registry connection string (one on each machine), which means it will be hard to administer. For OleDb the connection string is saved within the file. One advantage with ODBC is that you can change the connection string in a single place for one computer.
See also: