Data from databases
In Spotfire, you can connect to and access data from your external data sources, such as databases, data lakes and warehouses.
Accessing data from supported data sources with connectors
Spotfire has native support for lots of data source types. You can
connect to all supported data sources from the
Connect to list in the
Files and data
flyout.
![](../../images/connect_connect_to_list.png)
Technically, when you connect to a data source from the Connect to list, you're using a connector. Each connector is designed and optimized for one or more data sources. For the full list of supported data sources and the connectors you use to access data from them, see: Supported data sources.
If your data source is available in the Connect to list, this is the preferred way to access your data. Connectors are well-suited for handling big data, because data can be kept external for in-database analysis. That means that queries are pushed to the data source from Spotfire as you work on the analysis. Of course, with connectors you can also import data into Spotfire or load the data on demand.
To get started and create your first connection to your data source, see: Accessing data from a database.
Connecting to other data sources
Even if Spotfire does not yet have native support for the type of external data source where you store your data, meaning there is no specifically designed and optimized data connector for that source, you can probably still load your data into Spotfire.
To connect to a data source for which there is no self-service data connector, you can use one of Spotfire's generic methods for connecting to external data sources.
Information Designer - Server-side JDBC connectivity
With Information Designer (Information Services), you can connect to and load data from JDBC-compliant data sources. Data can be imported for in-memory analysis in Spotfire.
Information Services is a server-side method for loading data, which means that JDBC drivers and JDBC data source templates that are required to connect to your data source must be installed and configured on your Spotfire Server.
Once these preparations are set up on the Spotfire Server, you use the Information Designer tool in your Spotfire Analyst client to create information links for loading data from your JDBC-compliant external data source.
Load data with ODBC, OLE DB, or ADO.NET data provider
If there is no native data connector that you can use to connect to your external data source, and you cannot use Information Services to connect with generic JDBC connectivity, you can use Spotfire's generic support for loading data with a data source driver that you have installed on your computer.
With this method, you can use a driver of the types ODBC, OLE DB data provider, and ADO.NET data provider to connect and load data from an external data source.
- Supported data sources in the TIBCO Cloud™ Spotfire® web client
In the TIBCO Cloud™ Spotfire® web client, you can connect to and analyze data from many different external data sources. When you work with data connections in the web client, you have different capabilities for different data sources. - Accessing data from a database
You can connect to and access data from external data sources, such as databases, data warehouses, and data lakes. On this page, you learn how to connect to your data source with a data connection. - Supported data sources
The following are the external data sources that this version of Spotfire has native support for. In order to connect to a data source, you use a connector to create a data connection. Some connectors have support for more than one data source, which is why there are more supported data sources than connectors. - Data connections and connection data sources
With a data connection, you can analyze data from an external system, such as a database, in Spotfire. To create and open data connections, you use the connector corresponding to the system you want to connect to. When you access data with data connections, you can either analyze data as in-database data tables, or import the data tables into the Spotfire data engine. - Data connections in the Spotfire web client
When you use a Spotfire web client, you can access and analyze data from virtually any external data source that you can connect to in the installed client. Depending on the data source and method for connecting to it, you have access to different amounts of functionality in the web client. - Logging in to a data connection
When you open an analysis that contains data from a database, you typically have to log in to the external database. After logging in, you have access to up-to-date data directly from the external database in your analysis. - In-database and in-memory data loading in the TIBCO Cloud™ Spotfire® web client
When you analyze data from external data sources, you can either import data and analyze it within the Spotfire data engine (in-memory) or you can keep the data in the external system (in-database). - Configuring access for the TIBCO Cloud™ Spotfire® web client in cloud data sources
If you want to use data from cloud data sources, such as Azure SQL or Amazon Redshift, in the TIBCO Cloud™ Spotfire® web client, certain configurations might be required in the data source. Setting up the proper access rules is often a task for the data source administrator. - Properties in connection data sources
When you create or edit a data connection, you can set and change properties in the connection data source. Data source properties are settings that provide information about the external data source and decide how Spotfire should communicate with it.
- Supported data sources in the TIBCO Cloud™ Spotfire® web client
In the TIBCO Cloud™ Spotfire® web client, you can connect to and analyze data from many different external data sources. When you work with data connections in the web client, you have different capabilities for different data sources. - Accessing data from a database
You can connect to and access data from external data sources, such as databases, data warehouses, and data lakes. On this page, you learn how to connect to your data source with a data connection. - Supported data sources
The following are the external data sources that this version of Spotfire has native support for. In order to connect to a data source, you use a connector to create a data connection. Some connectors have support for more than one data source, which is why there are more supported data sources than connectors. - Data connections and connection data sources
With a data connection, you can analyze data from an external system, such as a database, in Spotfire. To create and open data connections, you use the connector corresponding to the system you want to connect to. When you access data with data connections, you can either analyze data as in-database data tables, or import the data tables into the Spotfire data engine. - Data connections in the Spotfire web client
When you use a Spotfire web client, you can access and analyze data from virtually any external data source that you can connect to in the installed client. Depending on the data source and method for connecting to it, you have access to different amounts of functionality in the web client. - Logging in to a data connection
When you open an analysis that contains data from a database, you typically have to log in to the external database. After logging in, you have access to up-to-date data directly from the external database in your analysis. - In-database and in-memory data loading in the TIBCO Cloud™ Spotfire® web client
When you analyze data from external data sources, you can either import data and analyze it within the Spotfire data engine (in-memory) or you can keep the data in the external system (in-database). - Configuring access for the TIBCO Cloud™ Spotfire® web client in cloud data sources
If you want to use data from cloud data sources, such as Azure SQL or Amazon Redshift, in the TIBCO Cloud™ Spotfire® web client, certain configurations might be required in the data source. Setting up the proper access rules is often a task for the data source administrator. - Properties in connection data sources
When you create or edit a data connection, you can set and change properties in the connection data source. Data source properties are settings that provide information about the external data source and decide how Spotfire should communicate with it.