Datasource Connection
Search
FactoryTalk DataMosaix Help
Introduction
Getting Started
Prerequisites
Access FactoryTalk DataMosaix
Sign-in Prerequisites
Sign in to FactoryTalk DataMosaix
Access DataMosaix from FactoryTalk Hub
About the FactoryTalk DataMosaix User Interface
DataMosaix Home Page Header
Navigation
Quick Tips
Accessibility Support for FactoryTalk DataMosaix
Install a screen reader extension
Create Project
Create Project
Manage Access
Members
FactoryTalk DataMosaix Member Roles
View Group Capabilities
Assign Role
Edit Role
Remove Role
Assign Roles to Multiple Members
Remove Roles from Multiple Members
Roles
Prerequisites
Default Roles
Custom Role
Extractor and Application Methods
Default Roles and Capability Matrix
Create a Custom Role
Remove a Capability Group from Role
Delete Role
Duplicate Role
Capability Groups
Prerequisites
Read Timeseries data
Upload 3D Models
Default Capability Groups
Create a new Capability Group
Modify Capability
Remove Capability
Delete Capability Group
Duplicate Capability Group
Features
Enable or Disable Features
Activate Features
Deactivate Features
Applications
Register Application
Regenerate Secret for Application
Edit Application
Delete Application
Extractors
Supported Extractor Versions
Register an OPC UA Extractor
Prerequisites
Register an OPC UA Extractor
Troubleshooting the OPC UA Extractor
Register an FT Historian (OSI PI) Extractor
Prerequisites
Register an FT Historian (OSI PI) Extractor
Troubleshooting the FT Historian (OSI PI) Extractor
Register an ODBC Extractor
Prerequisites
Register an ODBC Extractor
Troubleshooting the ODBC Extractor
Register an FT Optix Connector
Prerequisites
Register an FT Optix Connector
Configuring FT Optix to connect to DataMosaix
Install FTOptix - DataMosaix Connector
Configuring FT Optix to connect to DataMosaix - Continuation
Run the Optix Project in Optix Panel Runtime
View Newly Create Assets
View Flexible Data Models
Store and Forward Data
Add Alarms and Events to a FactoryTalk Optix Connector
Download the FactoryTalk Optix Connector from PCDC
Register an Asset Framework (PI-AF) Connector
Prerequisites
Register an Asset Framework (PI-AF) Connector
Troubleshooting the Asset Framework (PI-AF) Connector
Register a Custom Extractor
Prerequisites
Register a Custom Extractor
Regenerate Secret for Extractor
Edit Extractor
Setup Data Transformation for CDF
Prerequisites
Register an Extractor
Create Transformation
Set Client Credentials for Transformation
Run Data Transformation
Delete Extractor
Asset Creation
Prerequisites
Create Assets
Tree View and List View
Edit Asset
Delete Asset
Analyze Data
Configuring Power BI to connect to a DataMosaix project
Prerequisites for Power BI Desktop
Configure the DataMosaix Power BI Connector
Setting up Power BI Service using the Power BI Gateway
Automatic data refresh of reports in Power BI Service
Troubleshooting
Configuring Grafana to connect to FactoryTalk DataMosaix
Prerequisites
Configuring Grafana to connect to FactoryTalk DataMosaix
Configuring the Settings
Configuring Tableau to connect to a DataMosaix project
Prerequisites
Supported Versions
Datasource Connection
Datasource Connection using Tableau Cloud
Datasource Connection using Tableau Desktop
Supported Tables and Schema
Supported Fields for the Assets Table
Supported Fields for the Timeseries Table
Supported Fields for the Timeseries Data Points
Supported Fields for the Sequences Table
Supported Fields for the Relationships Table
Supported Fields for the Datasets Table
Supported Fields for the Events Table
Sample Reference Tableau Dashboard and Steps to Include All the Supported Tables
Create relation in asset and timeseries table
Extend relation by custom parameterized SQL of timeseries_datapoints
Prepare Tableau parameterized sheet
Supported Queries for the Tables
Sample Queries
Configure Power BI to Connect to a PostgreSQL Service Gateway
Prerequisites
Configure Power BI to connect to a PostgreSQL Service Gateway
API Reference
What is REST API?
What is M2M?
What is OpenAPI Specification?
API Tokens (What are Access Tokens?)
How to access FactoryTalk DataMosaix APIs via Swagger UI
API Versioning
Troubleshooting
No Content Available
No Application to Display
No Data Sources to Display
Cannot view the [Add] icon to register application
Cannot view the [Add] icon to register extractor
Pipeline not found
Cannot Modify Member Roles
Extractor not working as expected or failing
Datasource Connection
This section provide steps on how to connect to Tableau Cloud and Desktop:
Configuring Tableau to connect to a DataMosaix project
Datasource Connection using Tableau Cloud
Datasource Connection using Tableau Desktop
Provide Feedback
Have questions or feedback about this documentation? Please
submit your feedback here
.
