PIs Introduction TIBCO Spotfire's robust functionalities extend beyond data analysis, offering APIs that unlock a wealth of metadata for strategic purposes. By integrating these APIs into your existing infrastructure, you can ensure consistent metadata management across different platforms, facilitating better data governance, improved collaboration, and streamlined workflows. DESSS Timeline DESSS is targeting a September 2024 launch of Spotfire integration. Objectives ● To understand the type of metadata that can be extracted from Spotfire. Spotfire Connector Capabilities Spotfire offers two primary methods for metadata extraction, catering to different user needs and preferences: 1. APIs ● Rate limitations: Apply depending on your Spotfire license tier. ● Metadata Refresh Frequency: Mostly Real time but may vary depending on configuration. REST APIs: ● Library REST API: Manages content in the Spotfire Library, allowing you to upload, download, delete, and update analyses, documents, and other resources. ● Automation Services REST API: Executes pre-defined Automation Services jobs, enabling automated tasks like refreshing data, scheduling analyses, and exporting reports. SOAP web Service: ● Library Service: Provides the same functionalities as the REST API for managing content in the Spotfire Library. ● User Directory Service: Manages users and groups on the Spotfire Server, allowing you to create, update, and delete users, assign roles, and manage group memberships. ● Update Analysis Service: Enables external updating of Spotfire Web Player analyses, allowing you to refresh data and change visualizations without requiring user interaction. ● License Service: Provides access to information and functions related to Spotfire Server licenses, allowing you to monitor license usage, renew licenses, and perform other license-related tasks. ● Information Model Service: Manages the configuration of information models used as data sources in Spotfire analyses, allowing you to create, update, and delete information models and configure their connections to data sources. 2. Underlying Database: ● Metadata typically stored Spotfire Server Meta admin database (e.g., Microsoft SQL Server, Oracle). ● Specific table names and column structures may vary depending on your Spotfire configuration. Spotfire Lineage - possible to extract Requires querying the database directly. ● File path: If the data source is a file, the path to the file will be displayed. ● Database name: If the data source is a database. ● Information link name: If the data source is an information link. ● Data source name: If the data source was added through the Spotfire interface. Sample data source transformation with analysis: User Activity The user activity data within the Spotfire Server environment captures details like: ● User: Who performed the action (username) ● Action: What they did (e.g., logged in, opened a document, created a visualization) ● Timestamps: When the action occurred ● Resource: Which asset or data object was involved (optional) ● Component: Which part of the server was involved (e.g., database, web server, worker) ● Event: What happened (e.g., error message, performance metric) ● Time: When the event occurred ● Details: Additional information specific to the event (optional)Budget: $1,000 Posted On: June 27, 2024 00:51 UTCCategory: Data AnalyticsSkills:Business Intelligence, TIBCO Spotfire, Data Modeling Skills: Business Intelligence, TIBCO Spotfire, Data Modeling Country: United States click to apply