Modeler Connect

The Connect tab in Modeler brings data into a space by connecting to cloud applications, databases, or uploading files. You can preview tables, select columns, apply filters, and import data for reporting. For real-time queries, use Live Access to connect without importing data.

On this page you can perform these actions:

Connect with Infor Data Lake and Data Warehouse
You can connect to Infor Data Lake and Data Warehouses for unified data integration and advanced analytics.
Connect to Databases
It creates connections to SQL databases, such as MSSQL, Oracle, and PostgreSQL using Import or Live Access. It supports agent-based and agentless connections.
Connect to Cloud Applications
It integrates with apps like Salesforce, Jira, Google Analytics, Dropbox, and Amazon S3. You can configure credentials, select objects, and apply filters.
Query-Based Objects
It creates custom SQL queries for simplified views or joins instead of importing entire tables.
Upload Data Source Files
It uploads Excel, CSV, or text files. Each worksheet becomes a separate data source. It configures upload settings and selects tables and columns before importing. All uploaded files go through Virus Scan.
Advanced Options
- Do Not Use Prefix: Prevents name prefixing during migration.
- Autocommit for PostgreSQL: Controls transaction behavior.
- Snowflake Private Key Authentication: Supports database connections.
Special Connectors
- JSON Connector: Upload JSON files or ZIP bundles. Connect with JSON Connector
- REST Connector: Configure API endpoints with OAuth or Basic authentication.
- SFTP Connector: Securely access remote files.
Direct Access Connections
It maps tables for real-time queries without importing data. Supports caching, query timeout, and compound tables.
Birst Cloud Agent
It is required for connecting to on-premises databases or large file uploads. It supports scheduling and load balancing.
Extract Groups
It groups multiple data sources for scheduled extraction workflows via Orchestration.