TIBCO Spotfire
TIBCO Spotfire is a business intelligence tool that you can use to explore data through dashboards and advanced analytics.
Objects Extracted
The TIBCO Spotfire resource extracts metadata from the following assets:
- •Reports (Analysis documents)
- •Pages
- •Page objects such as Charts, Tables, Axis, Cross Table, Graphical Table, and Fields.
- •Custom Queries
- •Data Columns
- •Data Connections
- •Data Functions
- •Data Producers
- •Data Sources
- •Data Tables
- •Data Transformations
- •Expressions
- •Filters
- •Folders
- •Scripts
Permissions to Configure the Resource
Configure read permission for the user account used to access TIBCO Spotfire data source.
Lineage Support for TIBCO Spotfire Assets
You can view the column level lineage between the Data Sources, Data Tables, and Report objects in the catalog.
You can extract lineage from the following asset types in TIBCO Spotfire:
- •Oracle
- •Microsoft SQL Server
- •Azure Microsoft SQL Data Warehouse
- •MongoDB
- •PostgreSQL
- •Teradata
- •Files such as CSV and TXT
- •JDBC
- •Snowflake
Connect to a TIBCO Spotfire Source Enabled for SSL
To connect to a TIBCO Spotfire data source enabled for SSL, perform the following steps:
- 1. Run the following command to generate the TIBCO Spotfire SSL certificates:
openssl s_client -connect <TIBCO Spotfire hostname>:<portnumber> -showcerts </dev/null | sed -ne '/-BEGIN CERTIFICATE-/,/-END CERTIFICATE-/p' > <Path on the Informatica domain machine>/<certificate>.crt
- 2. Go to the <INFA_HOME>/source/java/jre/bin directory and run the following keytool command to import each copied certificate as a trusted certificate in the Informatica domain keystore:
keytool -import -file <Path on the Informatica domain machine>/<certificate>.cer -alias <alias name> -keystore <INFA_HOME>/services/shared/security/infa_truststore.jks -storepass <Informatica default truststore password>
- 3. Restart the Catalog Service.
Basic Information
The General tab includes the following basic information about the resource:
Information | Description |
|---|
Name | The name of the resource. |
Description | The description of the resource. |
Resource type | The type of the resource. |
Execute On | You can choose to run the resource on the default catalog server or offline. |
Resource Connection Properties
The General tab includes the following properties:
Property | Description |
|---|
Server URL | URL to connect to the TIBCO Spotfire Server. |
OAuth Client ID | OAuth client ID to connect to the TIBCO Spotfire Server. For more information about the steps to generate the OAuth client ID and client secret key, see the Generate the OAuth client ID and client secret key on the TIBCO Spotfire Server knowledge base article. |
OAuth Client Secret | OAuth client secret key to connect to the TIBCO Spotfire Server. |
The Metadata Load Settings tab includes the following properties:
Property | Description |
|---|
Enable Source Metadata | Extracts metadata from the data source. |
Library | Imports library objects such as reports and data sources. For a report object, the resource imports the dependent data sources. |
Memory | Configures the memory required to run the scanner job. Select one of the following values based on the data set size imported: Note: For more information about the memory values, see the Tuning Enterprise Data Catalog Performance article on How To-Library Articles tab in the Informatica Doc Portal |
Custom Options | Configures the scanner container using JVM parameters. You can use the following arguments to configure the parameters: - - -Dscannerloglevel=<DEBUG/INFO/ERROR>. Changes the log level of scanner to values, such as DEBUG, ERROR, or INFO. Default value is INFO.
- - -Dscanner.container.core=<No. of core>. Increases the core for the scanner container. The value must be a number.
- - -Dscanner.yarn.app.environment=<key=value>. Key pair value that you need to set in the Yarn environment. Use a comma to separate the key pair value.
- - -Dscanner.pmem.enabled.container.memory.jvm.memory.ratio=<1.0/2.0>. Increases the scanner container memory when you enable pmem. Default value is 1.
- - -DhandleIdCollisionForTableau=true. Handles the duplicate object conflicts with the extracted TIBCO Spotfire objects.
|
Track Data Source Changes | Displays metadata source change notifications in Enterprise Data Catalog. |
Auto Assign Connections | Indicates whether the connections are assigned automatically. |
Enable Reference Resources | Extracts metadata about assets that are not included in this resource, but referred to in the resource. Examples include source tables and files from TIBCO Spotfire reports. |
Retain Unresolved Reference Assets | Retains unresolved reference assets in the catalog after you assign connections. Retaining unresolved reference assets help you view the complete lineage. The unresolved assets include deleted files, temporary tables, and other assets that are not present in the primary resource. |
Limitations of the Resource
The TIBCO Spotfire resource includes the following limitations:
- •The resource does not parse few complex SQL queries and code written in programming languages such as JavaScript, R, and Python.
- •Enterprise Data Catalog supports only OAuth 2.0 authentication to connect to the TIBCO Spotfire data source.
- •The resource does not extract information link from libraries as the TIBCO Spotfire API does not provide this information during the metadata scan.