Omnata Product Documentation
  • Omnata Sync for Snowflake
    • What is Omnata Sync for Snowflake?
    • How it works
      • Terminology
      • Branching Mode
      • Sync Directions and Strategies
        • Outbound
        • Inbound
      • Rate Limiting
      • Access Control
      • Notifications
      • Security and Privacy
      • Internal tables
      • Internal Stored Procedures
      • FAQ
    • Step-by-step guides
      • 1. Install the Omnata Sync Engine
      • 2. Install the Omnata Plugin
      • 3. Configure the Plugin
      • 4. Create a connection
      • 5. Create a sync
    • Apps
      • Aerobotics
        • 📘Release History
      • Airtable
        • 📘Release History
      • Amazon Ads
        • Privacy Notice
      • ApprovalMax
        • 📘Release History
      • Bamboo HR
        • 📘Release History
      • Clockify
        • 📘Release History
      • Contentful
        • 📘Release History
      • GitHub
        • 📘Release History
      • Github
      • Google Ads
        • 📘Release History
      • Google Sheets
        • 📘Release History
      • HubSpot
        • 📘Release History
      • Hubspot
      • Infor Data Lake
        • 📘Release History
      • Jira
        • 📘Release History
      • LinkedIn Ads
        • 📘Release History
      • Mailgun
        • 📘Release History
      • Marketo
        • 📘Release History
      • Meta Marketing
        • 📘Release History
      • Microsoft Ads
        • 📘Release History
      • Microsoft Dynamics 365 Business Central
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
      • Microsoft Entra ID
        • 📘Release History
        • 📘Release History
        • 📘Release History
        • 📘Release History
      • Microsoft Excel
      • Microsoft SQL Server
        • 📘Release History
      • Monday.com
        • 📘Release History
      • MRPeasy
        • 📘Release History
      • PayHero
        • 📘Release History
      • Pinterest Ads
        • Privacy Policy
      • PostgreSQL
        • 📘Release History
      • Salesforce
        • Salesforce Permissions needed
        • Formula Fields
        • How we use the Salesforce APIs
        • 📘Release History
      • Salesforce Marketing Cloud
        • OAuth for APIs, SFTP for file transfer with GPG on outbound
        • OAuth for APIs, SFTP for file transfer
        • OAuth for APIs, Cloud Storage for file transfer
        • 📘Release History
      • Shopify
        • Outbound sync data structures
        • 📘Release History
      • Slack
        • 📘Release History
      • Tiktok Ads
        • Privacy Policy
      • Typeform
        • 📘Release History
      • Wise
        • 📘Release History
      • Xero
        • 📘Release History
      • Zendesk Support
        • 📘Release History
        • 📘Release History
    • Plugins
      • Anatomy of a Plugin
      • Example Plugins
        • Example Plugin: Slack
        • Example Plugin: Zoho CRM
      • Creating Plugins
      • Advanced Plugin topics
        • Advanced rate limiting / concurrency
        • Custom Jinja filters
        • Custom Record Transformers
        • Dynamic Configuration Forms
        • Test case generation
    • Branching
      • Inbound Sync branching
      • Outbound Sync branching
    • Integrations
      • dbt
        • Validation Tests (coming soon)
    • 📘Release History
  • Omnata Connect for Salesforce
    • Overview
    • Getting Started
      • Install the Salesforce App
      • Connect to your data warehouse
        • Snowflake
        • BigQuery
        • Rockset
        • Firebolt
        • SingleStore (previously MemSQL)
      • Deciding which mode to use
    • Omnata with Salesforce Connect (External Objects)
      • Object Configuration
      • View your data in a list
      • Link to other objects
      • Use in a Report
      • Database schema changes
      • Writing to External Objects
    • Omnata with Salesforce Lightning Components
      • Object Configuration
      • View your data in a list
      • Link to other objects
      • Using the Lightning Component on a page
      • Assigning Permissions
    • Advanced Features
      • Row Level Filtering
      • Multi-Currency handling
        • About Multi-Currency
        • Support in Omnata Connect
        • Apex Features
    • Integrations
      • Datadog
    • Omnata with Salesforce Apex
    • Security
    • Use cases
      • Linked object drill-downs
      • Global Search
      • ERP and historical data
      • Embedded product metrics
    • Best Practices
      • Global Search
      • Change Management
      • Snowflake table design
      • Salesforce page layout
      • Salesforce Caching
Powered by GitBook
On this page
  • V1.19
  • V1.18
  • V1.17
  • V1.16
  • V1.15
  • V1.14
  • V1.13
  • V1.12
  • V1.11
  • V1.10
  • V1.9
  • V1.8
  • V1.7
  • V1.6
  • V1.5
  • V1.4
  • V1.3
  • V1.2
  • V1.1
  • V1.0
  1. Omnata Sync for Snowflake
  2. Apps
  3. Infor Data Lake

Release History


V1.19

Created: 2025-04-07

  • added support for the infor regions (US East(no subdomain), Frankfurt(eu1), Singapore(se1), Sydney(se2), Tokyo(ne1)


V1.18

Created: 2025-04-06

  • modified allowed network addresses to use a wildcard so that multi infor regions can be accessed.


V1.17

Created: 2025-03-24

  • fixed log message when running a sync so the sync name appears in the correct position within the record attributes

  • fixed issue the where clause multiple where statements in

  • fixed logging for provide_results to return the data

  • added error information into the state when a given where clause fails


V1.16

Created: 2025-03-13

  • fixed issue when no cono column is available in a stream and a sync is incremental.


V1.15

Created: 2025-03-12

  • added additional minute level grouping when determining what queries are required to retreive the inital data load.


V1.14

Created: 2025-03-12

  • fixed issue where failed queries would get added into the list of queries still to be run as a list instead of a single query


V1.13

Created: 2025-03-11

  • updated setting of the state for the cursor field so that it is updated once all queries have been processed


V1.12

Created: 2025-03-07

  • fixed issue around multi query completion


V1.11

Created: 2025-03-07

  • added in additional logging details for job completion and job checks


V1.10

Created: 2025-03-07

  • added ability to limit the total number of queries are allowed to be executed for a stream in a single sync run. This allows for larger datasets to be broken down into smaller chunks and processed over time.


V1.9

Created: 2025-03-06

  • fixed issue when last_modified_date is not set for full refresh syncs


V1.8

Created: 2025-02-21

  • refactored logging for readability in logs

  • fixed InforTableDistinctStats query

  • modified partial sync failures to report as success but keeps the failed statements for processing next time


V1.7

Created: 2025-02-18

  • enabled incremental syncs to respect the max record count


V1.6

Created: 2025-02-17

  • modified the json column name to use field RFLD instead of FLDW in the table CFIFFD


V1.5

Created: 2025-02-14

  • added in new UDF to allow for disinct counts as well as counts

  • modified primary key for append behavior to use dataObjectId and dataObjectSequenceId instead of variationNumber and deleted

  • updated default concurrent queries to 10

  • updated default max records per query to 5M

  • updated table categories so they are inalignment with the descriptions for the tables


V1.4

Created: 2025-02-13

  • fixed usage grants for stages


V1.3

Created: 2025-02-12

  • enabled BYO of the infor-compass-jdbc-2023.10.jar file


V1.2

Created: 2025-02-11

  • removed additional jars which weren't required


V1.1

Created: 2025-02-10

  • added sync capabilities for tables in datalake

  • added basic table and row stat functions

  • included CONO filter for tables

  • included Min Acquisition Date filter

  • added custom where clause filter

  • added direct query capability


V1.0

Created: 2025-02-10

  • added sync capabilities for tables in datalake

  • added basic table and row stat functions

  • included CONO filter for tables

  • included Min Acquisition Date filter

  • added custom where clause filter

  • added direct query capability


PreviousInfor Data LakeNextJira

Last updated 1 month ago

📘