Infor
Infor Data Fabric is Infor's cloud-native data management platform. It provides capabilities for big data storage, real-time data delivery, querying, and advanced data management tooling. It supports an ecosystem of more than 30 Infor applications and services.
Infor Data Lake is a component of Infor Data Fabric. It provides high-volume, scalable object storage for real-time data from CloudSuite applications, third-party systems, and other data producers. Data Fabric is the management and connectivity layer, and Data Lake is the underlying storage layer.
Infor Data Fabric / Data Lake integration replicates data using the Compass SQL API v2.
Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
To set up your Infor account, you need:
- An active Infor CloudSuite subscription with Data Fabric / Data Lake enabled.
- Access to Infor OS with ION API Gateway Administrator rights (
IONAPI-Administratorrole), or the ability to request that an authorized app is created for you. - A Backend Service authorized application registered in ION API Gateway, with a service account and a downloaded
.ionapicredential file. - A service account user with read access to the Data Lake tables that you want to replicate.
The .ionapi credential file is generated in Infor OS and contains the OAuth client credentials and service account keys required for authentication.
You can download these credentials only once. Store the file securely.
To obtain the .ionapi credential file:
- Log into your Infor account.
- In Infor OS, navigate to API Gateway > Authorized Apps.
- Click +.
- Enter the following information for your application:
- Name: Enter a name.
- Type: Select Backend Service.
- Description: Enter a description.
- Click Save.
- Click Download Credentials.
- Enable Create Service Account.
- Select a user to associate with the service account.
The selected user defines the data that the connector can access.
Optionally, select one or more scopes that the service account can access.
- Click DOWNLOAD to save the
.ionapicredential file.
Creating the connection
자세한 내용은 SaaS 응용 프로그램에 연결을 참조하십시오.
- 필요한 연결 속성을 입력합니다.
-
연결 이름에 연결 이름을 입력합니다.
-
연결이 만들어질 때 연결에 대한 메타데이터를 정의하려면 연결 메타데이터 열기를 선택합니다.
-
만들기를 클릭합니다.
| Setting | Description |
|---|---|
| Data gateway |
사용 사례에 필요한 경우 데이터 이동 게이트웨이를 선택합니다. 정보 메모
이 필드는 데이터 이동 게이트웨이를 지원하지 않으므로 Qlik Talend Cloud 시작 구독에서는 사용할 수 없습니다. 다른 구독 계층이 있고 데이터 이동 게이트웨이를 사용하지 않으려면 없음을 선택합니다. 데이터 이동 게이트웨이의 이점과 이를 필요로 하는 사용 사례에 대한 자세한 내용은 Qlik 데이터 게이트웨이 - 데이터 이동를 참조하십시오. |
| Start date |
데이터를 소스에서 대상으로 복제해야 하는 날짜를 |
| ION API File Content | The JSON content of the .ionapi credential file. Open the file in a text editor and paste the full content into this field. |
| Variation Handling | Controls which record versions are included in replication. Default: Latest. |
| Date Window Size | Number of days per query window for incremental replication. Date windowing keeps queries on large tables within Compass execution limits. Default: 180. Fractional values are supported (for example, 0.5 = 12 hours). |
Variation handling options
Infor Data Lake tracks multiple versions of each record, including deletions and archival states. For more information, see the Infor Data Lake documentation.
| Display Name | Config Value | Description |
|---|---|---|
| Latest | latest
|
Replicates only the current, live version of each record (excludes deleted and archived). |
| Include Deleted | include_deleted
|
Replicates current records and those soft-deleted at the source. |
| Include Deleted and Archived | include_deleted_and_archived
|
Replicates current, deleted, and archived records. |
| All Variations | all_variations
|
Replicates every historical version of each record (excludes archived). |
| All Variations Including Archived | all_variations_include_archived
|
Replicates all historical versions of each record, including archived ones. |
Replicated tables
All tables available in your organization's Infor Data Lake can be selected for replication in Qlik Talend Cloud. The specific tables you see depend on which data objects your CloudSuite applications and any third-party sources have published to your Data Lake.
To explore available data objects, use the Atlas tool within Infor Data Fabric.
Each table is incrementally replicated based on the last_modified timestamp, which is populated by Infor's infor.lastModified() system function. Primary keys for each table are automatically determined from Infor's Data Catalog API.
Limitations and considerations
- Compass queries are processed asynchronously. Each query is submitted as a job, monitored for status, and results are retrieved when the job completes. Large datasets may require additional processing time.
- A rate limit of 100 query submissions per minute applies to the Compass SQL API. Qlik Talend Cloud handles rate limiting and retries automatically.
- Query results remain accessible for approximately 20 hours after the job completes.
- The connector waits up to 10 minutes for each Compass query to complete. If a query does not finish within that time, the task stops with an error. Reduce Date Window Size to keep queries on large tables within this limit.
- The connector supports Data Lake objects in newline-delimited JSON and delimiter-separated values (DSV) formats.