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.
Every data connector in Spotfire has a built-in set of data source properties that you can control. Some basic properties are available for most connectors, such as properties to specify the server address to connect to, the authentication method to use for login, and the username and password. Other properties are connector-specific, and some are applicable only for certain types of external data sources.
![](../../images/connectors_connect_form_d.png)
Usually, there is a match between a data source property in Spotfire
and a setting or option in the driver software or API that Spotfire uses for
communication with the external system. For example, if you create a connection
with the Amazon Redshift connector, the data source property
SSL Mode
controls the option
SSLMode
in the Amazon Redshift ODBC driver. Therefore,
to learn more about various data source properties, refer to the official
documentation from the vendor of the database or driver.
Configuring other driver settings as custom properties
Data connectors in Spotfire only officially support the built-in data source properties. However, the driver software or API can have many more settings and options.
Por Que e Quando Desempenhar Esta Tarefa
With some connectors, you can add custom properties to your connection data source. With custom properties, you can add and change driver settings that do not have built-in data source properties. While the settings that you control with custom properties are not officially supported, they can be useful for tweaking the connection performance, changing the behavior of a connection, or accessing certain data.
Adding a custom property to a data connection
To use a custom property in a data connection, you must add the property and set a value for it.
Por Que e Quando Desempenhar Esta Tarefa
Before you add a setting as a custom property, refer to the official documentation from the database or driver vendor. You must know what the setting does, and what type of input it accepts.
![Adding a custom property to a connection data source.](../../images/connector_custom_properties_d.png)
Procedimento
- Create a new data connection, or edit an existing one.
- When you edit the connection data source in the Connect to [data source] form, click More properties.
- In the expanded More properties form, click Add property.
- In the popover menu, select the setting you want to add as a custom property.
- In the new input field that was added, set a value for your custom property.
Enabling custom properties for a connector
As a Spotfire administrator, for each data connector that supports custom properties, you can allow or turn off the use of custom properties. By default, custom properties are turned on.
Procedimento
Connectors > [Connector Name] >
AllowCustomProperties
to
True
.
Controlling what custom properties are allowed
As a Spotfire administrator, you can enter a list of driver settings or options that are available as custom properties for each connector.
Por Que e Quando Desempenhar Esta Tarefa
CustomProperties
preference is empty, a list of
default settings are allowed as custom properties for each connector. See the
help topic for each connector for the full list.
Procedimento
Connectors > [Connector Name] >
CustomProperties
and add a list of driver settings or options to
allow.