What's New

Current Release
: FactoryTalk DataMosaix SaaS 1.10.00

New Features

This release includes the following new features:
  • New extractor for
    FactoryTalk® View SE
    , designed exclusively to retrieve data from Historian.
  • New clusters have been introduced, including
    aw-dub-gp-001
    ,
    aw-tyo-001
    ,
    az-gru-001
    , and
    az-tyo-gp-001
    .
  • Introduced Azure Private Link to enable secure, private connectivity from virtual networks to Azure services, enhancing security and compliance by eliminating public internet exposure.

Fixes and Improvements

This release includes the following improvement:
  • In VantagePoint Model Migration, a new
    Message
     column has been added to Imported Files to provide detailed success and failure messages for import operations.

Known Anomalies

  • IN operator does not work as expected with Date/Timestamp fields in Flexible Data Modelling queries; use
    =
     or
    BETWEEN
     as a workaround.
  • 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

  • FactoryTalk View SE
     Agent SDK currently supports data retrieval from
    FactoryTalk View SE
     data sources including DataLog, FTLD, and Alarms & Events. DataLogPro is not supported, as it is based on InfluxDB, which is outside the scope of the current SDK integration capabilities.
  • FactoryTalk View SE
     integration currently supports retrieval of numeric historical data only.
  • Date-time filters on the Virtual PostgreSQL server require explicit parsing using
    PARSE_DATETIME
     for ISO formats (Example,
    2024-01-01T23:00:00Z
    ).
  • Start Date and Time in
    FactoryTalk View SE
     Connector Extractor defines the initial historical data range and cannot be changed later; extractor uses incremental refresh for new data only.
  • Boolean filters may fail if Boolean-typed fields contain non-Boolean numeric values (Example,
    WHERE col = TRUE
     won’t match values like 12345).
  • 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.
  • 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:
      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

Version
FactoryTalk DataMosaix SaaS 1.00.00 - July 2023
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal