What's New

Current Release

: FactoryTalk DataMosaix SaaS 1.09.00

New Features

VantagePoint Model Migration: New tool which facilitates migration of data models from FactoryTalk VantagePoint to
FactoryTalk DataMosaix SaaS
.
Customer-requested Project Offboarding - Customers may manually request deletion of their
FactoryTalk DataMosaix SaaS
tenant after all
FactoryTalk DataMosaix SaaS
subscriptions related to the tenant have expired.
Support for additional entities in the Virtual PostgresSQL Interface: Enables users to retrieve data from Flexible Data Model entities to BI tools. Newly supported entities include: Containers, Data models (including all models created from Core Data Models), Spaces and Views (Instances).
Enhanced Localization Support: The
FactoryTalk DataMosaix SaaS
Management Console is now available in:
English
Spanish
German
Japanese
Portuguese
French
Italian
Korean
More granular authorization management of
FactoryTalk DataMosaix SaaS
features: The following capabilities are now available for manual inclusion to Capability Groups
Timeseries subscriptions
Postgres Gateway
Data Workflows
SAP writeback
SAP writeback requests
Diagram parsing
Simulator integration
Atlas AI Agents

Fixes and Improvements

Quality improvements on Virtual PostgresSQL Data Interface for improved performance and stability.

Known Anomalies

User with service-level admin role in
FactoryTalk Hub
is not getting assigned the Project admin role in
FactoryTalk DataMosaix SaaS
while creating a project.
Incorrect status for the user who already has access to the project as an organization-level admin in
FactoryTalk Hub
.
An approach was identified to retrieve all events generated by the
FactoryTalk Optix
project. However, the retrieved data includes a mix of state changes, acknowledgments, confirmations, and alarm events. Currently, there is no reliable mechanism to distinguish alarm events from other event types within the retrieved dataset.

Limitations

Only UI elements are translated, everything that comes as an API response like error messages, grid data etc. remains in English.
When translating labels on the user interface (UI), we are intentionally keeping technical terms, product names, feature names, and similar domain-specific terminology in English.
In this release, we support Tableau (Desktop and Server), Power BI,
Microsoft
Excel
, and
Microsoft
SQL Server Reporting Services as BI tools using the new egress data interface.
In mathematical queries, division by zero will result in an error.
The following functions are not supported in the virtual PostgreSQL data interface:
Aggregate functions ARRAY_AGG, JSONB_AGG, and JSON_AGG.
The cumulative distribution function CUME_DIST().
The string function Reverse.
The string function SPLIT_PART().
The window function PERCENT_RANK().
Function REGEXP_MATCHES
LIKE operator does not work for timeseries datapoints.
The ISO date format('YYYY-MM-DDThh:mm:ss.000Z') is not supported for the virtual postgres server
SQL Queries and functions:
Only select, select with top and select with where clause are supported.
It provides limited capability for SQL aggregations and functions.
Join operations between the exposed
FactoryTalk DataMosaix SaaS
entities are supported.
Sample queries are available in the online help, refer to Sample Queries.
The available
FactoryTalk DataMosaix SaaS
entities:
This release currently supports nine
FactoryTalk DataMosaix SaaS
entities, and they are exposed as if they were Postgres SQL tables for BI tools to query from. Refer to the Supported Entities in the Virtual PostgreSQL Data Interface.
This release currently supports four
FactoryTalk DataMosaix SaaS
dynamic entities, and they are exposed as if they were Postgres SQL tables for BI tools to query from. Refer to the Supported Entities in the Virtual PostgreSQL Data Interface.
The
timeseries_datapoints
table will only return the rows if a valid external ID or timeseries ID is provided in the where clause. Otherwise, the SELECT query returns an empty row. In case of joining with the "timeseries" table, it will fetch the rows if where clause on external ID or timeseries ID is present for
timeseries_datapoints
table.
Time series data point aggregation functions are currently not supported.
While there are no hard limits on the number of rows that can be fetched from assets and timeseries tables, performance in scenarios with large datasets may result in unexpected errors or timeouts. For the
timeseries_datapoints
table it is mandatory to provide timeseries ID or external ID in the where clause. By default, the data points for the last 24 hours will be returned but the user can also use the timestamputc column to fetch any relevant time range data points.
Fetching more than 1M data will result in an error  - "Please consider adding more filters to narrow down the fetched data."
Table constraints are not defined for the exposed
FactoryTalk DataMosaix SaaS
entities. However, the relationships can be easily defined by a Tableau user using the reference table defined in line with
FactoryTalk DataMosaix SaaS
entities APIs. For example, the asset ID is the unique (can be assumed as primary key) ID so there will be no duplicate asset ID in the table. Refer to the following Primary key and Foreign key columns table:
Primary and Foreign Key Columns Table
Table Name	Primary Key Column	Foreign Key Column
assets	id	datasetid (datasets)
timeseries	id	assetid (assets), datasetid (datasets)
timeseries_datapoints	timeseriesid , timestamputc	timeseriesid (timeseries)
sequences	id	assetid (assets), datasetid (datasets)
relationships	id	datasetid (datasets)
events	id	datasetid (datasets)
datasets	id
labels	id	datasetid (datasets)
files	id	datasetid (datasets)
For dynamic entities, view without data model will not be listed.
For dynamic entities, to perform ASC/DSC make sure we have used EnableFolding=false with query.
To import an IIP file, user must have Data Scientist and Data Configurator roles.
By default, the following SQL functions are supported:
COUNT()
NOW()
ISNULL()
EXTRACT()
MAX()
MIN()
AVG()
RANK()
CUBE()
CONCAT()
SUM()
UPPER()
LOWER()
If the group count goes beyond 350 (irrespective of tenant, project, or organization), the token size will exceed the limit of 8 KB, leading to the token failure.
Time out issue while executing join query with datasets and events.
Only users/M2M with the roles of Application Developer, Project Admin, Data Configuration, Data Scientist, or Application User can access the list of Applications and Extractors.
Special characters are not allowed when creating models in
FactoryTalk DataMosaix SaaS
using
FactoryTalk Optix
.
Depending on the scale of the changes made to the
FactoryTalk Optix
model, sometimes the changes may not be correctly pushed to the Flexible Data Model (FDM). If this happens, it is recommended to either change the FDMSpaceName property of the FTDataMosaixStore object or increase its FDMModelVersion value.

Previous Releases