Infor Data Fabric User Guide

Home

Back

Forward

Search

Help
Copy URL
PDF
Print this page

Help

Help

Copy URL

Copy URL

Topic URL copied to clipboard

PDF

PDF

Print

About this guide

Intended audience

Prerequisite knowledge

Related documents

Introduction to Data Fabric

Data object properties

Data versioning

Data object creation

Data object processing concepts

What is included

Compass JDBC driver

Quick guide to Data Fabric

Sending data to Data Lake

Viewing data in Data Lake

Validating data in Data Lake

Extracting data from Data Lake

Querying data from Data Lake

Deleting data from Data Lake

Using Metagraphs

Enforcing data security

Infor OS Service Limits

Supported languages

Data Fabric in Infor Government Solutions

How to use the Data Fabric application

Navigating to Data Fabric

Data Fabric home page

Viewing Data Fabric version details

Bookmarking pages in Infor OS Portal

Bookmarking pages in Infor Ming.le

Sending data to Data Lake

Choosing appropriate methods of ingestion

Logical IDs recommendations

Streaming Ingestion

Micro-batching of streamed data

Batch Ingestion API

Data Preparation

Tracing and troubleshooting

Sending data through the Atlas Upload widget

Validating data in Data Lake

Reconciliation of data sent in batches

Reconciliation of streamed data

Possible causes of mismatches

How to use Data Ledger

Viewing the reconciliation card

Filtering based on data object name or application

Sorting the list

Searching for reconciliations

Filtering based on classification

Filtering to get last reconciliation per each data object

Sorting reconciliations

Refreshing Data Ledger

Querying Compass

Activity charts

Changing the application for charts

Instance count chart

Top 5 Mismatched Tables chart

Last readings per app chart

Viewing data in Data Lake

Searching by object name

Filtering by object type

Filtering uncatalogued object names

Showing absent objects

Sorting object names

Object name details

Refreshing the object names list

Browsing data objects

Searching for data objects

Viewing a data object

Filtering data objects

Refreshing data objects

Maximizing the Data Grid view

Maximizing the Object Content view

Show the UTC date and time

Unit of measure

Personalizing columns

Exporting to CSV

Downloading data objects

Managing data in Data Lake

Marking or clearing data as corrupt

Deleting data from Data Lake

Deleting data objects in Atlas

Purging archived data objects in Atlas

Deleting data objects in Purge

Purging by object by ID

Purging by filter

Purging archived data objects in Purge

Using the Delete APIs

Working with Purge logs

Exporting purge logs

Stopping a purge event

Purge status indicators

Managing Compass data

Streaming data from Data Fabric

Stream Pipelines concepts

Pipeline monitoring concept

Supported databases

Loading data in Snowflake

Authenticating in Snowflake

Rotating key pairs

Snowflake data types

Pipelines IP address reference

Viewing the list of destinations

Viewing a destination

Creating a PostgreSQL destination

Creating a Snowflake destination

Testing a destination

Updating a destination

Creating a copy of a destination

Deleting a destination

Deleting multiple destinations

Exporting a destination

Importing a destination

Usage of a destination

Stream Pipelines

Viewing the list of pipelines

Creating a pipeline

Modeling a pipeline

Data object activity

Changing and activity name and description

Table mapping and model validation

Management of object schema modifications

Operating a pipeline

Pipeline statuses

Initial Load status

Replay Queue status

Starting a pipeline

Starting an initial load

Stopping an initial load

Stopping a pipeline

Editing a pipeline

Monitoring a pipeline

Finding a problem

Listing the failed events

Replaying events

Replaying events from a specific record

Discarding events and retention period

Extracting data from Data Lake

Data Objects and Views panel

Searching the list

Refreshing the list

Data object menu

Generating a SELECT statement

Archive options

Syntax and formatting

Using the auto-suggest functionality

Formatting the query

Running a query

Running multiple queries

Searching results

Altering the results view

Exporting to CSV

Configuring the mode

Using Compass query APIs

Using the data object retrieval APIs

Compass JDBC Driver

Installation and configuration

Prerequisites for the Compass JDBC driver

Downloading the Compass JDBC driver

Authenticating with the API Gateway security credentials file

The Compass JDBC driver in your SQL query tool

Option 1 - Incorporating the security credentials using the .ionapi file in the same directory as the driver

Option 2 - Incorporating the security credentials in the connection string with the tenant ID

Option 3 - Incorporating the security credentials in the connection string without the tenant ID

Java Documentation

Querying the Data Lake

Data object definitions

JSON data objects

DSV data objects

Date and datetime property definitions

Supported formats

Data object definitions for localized string values

Localized data definition, method 1

Localized data definition, method 2

Object metadata best practices for queryable data

Creating a view

Updating a view

Dropping a view

Data Lake JDBC driver for Birst

Data Selection Features

Data Selection for Localized String Values

Troubleshooting SQL expressions

Data Lake Compass queries

Query functionality and syntax

Infor functionality

Queries for localized data

Select localized values for a property

Data Catalog locale selections

Queries for incremental data loads

Using the LASTMODIFIED property

Use the INFOR.LASTMODIFIED() function in a WHERE clause for an incremental data load

Query functions for Data Lake and Compass properties

Data Lake properties

Query functions for Data Lake

INFOR.DATAOBJECTID

INFOR.DATAOBJECTSEQID

Compass properties

Query functions for Compass

INFOR.COMPASSTIMESTAMP

INFOR.PARTITION

Flexible data formats

INFOR.SHOW_VALUE

Infor value transformation functions

INFOR.CONCAT2 through INFOR.CONCAT6

INFOR.DATETIME_TO_TIMESTAMP

INFOR.TIMESTAMP_TO_STRING

INFOR.STRING_TO_TIMESTAMP

INFOR.SPLIT_VALUE

includeAllVariations

includeDeletionsWithMaxVariations

includeInSelectAll

skipReformatting

Variation handling

Select the maximum variation excluding deleted and archived records

Select all variations of each record excluding archived records

infor.allvariations() table function

IncludeAllVariations query hint

Select the maximum variation including deleted records

infor.includedeleted () table function

IncludeDeletionsWithMaximumVariations query hint

Select the maximum variation of only archived records

infor.showarchived () table function

Select all variations of archived records

Infor.showallarchived() table function

Select the maximum variation including deleted records and archived records

infor.includearchivedanddeleted() table function

Select all variations of each record

infor.allvariationsincludearchived() table function

Master variation handling table function

Data Lake database schemas

Property definitions

String properties

Integer and numeric properties

Date and timestamp properties

Boolean properties

Query processing

Data administration stored procedures

Clear table with or without clearing data

INFOR.CLEAR_TABLE and clear Compass data

INFOR.CLEAR_TABLE and retain Compass data

INFOR.CLEAR_VIEW

INFOR.CLEAR_DATA

INFOR.RESET_PARTITIONS

Query result set differences

Compass SQL Reference

Query structure

UNION | UNION ALL

SELECT LIMIT number of rows

SELECT TOP number of rows

SELECT DISTINCT

Select individual properties from an object

Select individual properties using aliases from an object

Incorporate comments in a query

Select properties and include the Data Object load timestamp

Select records based on the last modified timestamp

Select all records

Select the Data Catalog Locale Selections

Select localized values for a property

Select localized values for a property and autofill unused property positions

Select localized values for a property that is not localized

Select a localized property without the locale function

Expressions and comparison functions

Logical and comparison operators

String functions

CONCATENATION USING ||

Mathematical operators

Mathematical functions

Signed expression

Aggregation functions

Datetime functions

CURRENT_TIMESTAMP

DAY, DAYOFMONTH, DAY_OF_MONTH

FROM_UTC_TIMESTAMP

Conversion functions

CONVERT datetime to string

CONVERT string to datetime

Analytic functions

RANK …OVER … PARTITION BY

ROW_NUMBER … OVER … PARTITION BY

Metagraph naming conventions

Notification icons and banners

Viewing the list of metagraphs

Overview page toolbar

Single-select mode

Multi-select mode

Sorting the metagraphs

Viewing a metagraph

Details page toolbar

Personalizing a metagraph

Creating a metagraph

Importing a metagraph

Exporting a metagraph

Creating a copy of a metagraph

Deleting a metagraph

Understanding the results panel

Modeling your metagraph

Updating the description

Viewing node details

Managing default properties

Setting the primary node

Creating relationships

Viewing relationships

Editing relationships

Deleting relationships

Understanding the Notifications Panel

Publishing a view to Data Lake

Creating a view

Previewing the result set

Data security scope

How to determine permissions

Enabling data security

Disabling data security

Creating a security profile

Viewing a security profile

Updating a security profile

Updating access controls

Updating data security

Disabling a security profile

Deleting a security profile

Configuration Management

Data Lake query error handling

SQL Messages 200-399

Process Messages 400-499

Data Storage 500-599

Compass API Messages 700-749

Compass API Messages 750-799

Troubleshooting Compass queries

Initial query is executing for a long time

Updated Data Catalog data object metadata changes are not in Compass

Updated Data Catalog locale selections cause queries to fail with a 401 error

Incorrect query results when the results have duplicate column names

Queries fail after object metadata is updated

Limitations and restrictions for Views

Compass Query Timeout

Links
docs.infor.com
Send Feedback on Current Topic
Product Support

Open link in new tab
Open link in new window
Copy link to clipboard