Data Mapper
- How to setup Data Maps
- Data Mapper: How to use For Each function to filter data?
- Data Mapper: How to do drag and drop and apply one-to-one mapping rules?
- How to create an API used in the Template's External Mapping Validation feature
- Splitting Large Files into Smaller Files and Writing to Target Location
- Implementing Conditional Logic in Mapping
Process Designer
- Using Decompression to Unzip files from a Zipped file
- How to Split Data in a Process Flow
- How to Consume and Publish APIs
- How to configure an Advanced Database Layout and use it in a Process Flow
- Process Designer: Integration with Kafka
- Process Designer: Using JMS connector for Message Queue integration
Updates & Service Packs
- Steps to import new SSL Certificate in AIS/AC3 Environment (cacerts file)
- Alter scripts for Mnt. Patch 04
- POODLE Vulnerability Fix
- Cloud_Apps_Certificates
- Restoring LOG DB to MNT4 or Earlier MNT Patches
- Upgrade Guide: v5.3 SP1 to v6.1
Application Settings
- Importing P7B SSL certificate in Adeptia
- Event Scheduler Failure in Adeptia Connect due to SQL Syntax Errors and Event Activation Conflicts
- Birthday attacks against TLS ciphers with 64bit block size vulnerability (Sweet32)
- OAuth Refresh Token FAQ
- Issue after Upgrade to Adeptiav6.6
- Updating Database Properties
Installation
- Fail Over Guide
- Video: Configuring Adeptia for Version Control
- Adeptia Maintenance Guidelines Template
- Download Adeptia Suites
- Alter script to restore log DB V6.1 Oct Mt Patch
- Training and Evaluation Objects
Web Services
- How to use Oauth Profile and Oauth in configuring REST Security Policy
- Override Web Service Provider Status Code
- Issue with Rest Provider While Downloading Excel File
- Send file content as a body to REST Consumer.
- How can we dynamically add a Header to a Rest Web Service Call?
- Handling Rate Limit Restrictions in a Process Flow while Calling a REST API
Source & Target
- Handling Binary Data Transmission to Snowflake – SQL Compilation Error Analysis
- Using Stored Procedure as Source/Target
- Handle CLOB/BLOB data as Source/Target in Oracle DB
- Process Multiple Attachments from the Mail Source
- Connecting to MQ
- Box, Dropbox and Google Drive as Source and Target
Creating Workflows
- Set Logged in User's Parameters in WebForms
- Using Context Variables in the Email Body
- File Upload in Web Form
- Attach Document to Human Workflow
- Passing data stream into the Workflow Task Form
- How to remove all the tasks from the Task Manager
Connecting to Databases
- Steps to configure Adeptia's Backend and Log database with Windows Authentication.
- Steps to configure Azure Active Directory credentials to login MS SQL Server Backend and Log Database in Adeptia
- MS SQL Database for Adeptia Backend, Log and Quartz
- Configuring Adeptia Suite with Secured MySQL on SSL
- Oracle connection using sqlplus statement
- SSL Encryption Error for DB Activities
Solution Accelerators
- SalesForce Connector FAQs
- API Management Accelerator
- Updating Accord DTCC EDI standard v5.0 Messages
- Salesforce Record Limit
- EDI - Customizing Data Dictionary
- EDI Inbound Relationship Mode Type
Custom Plugins
- Posting Message to Redis
- Using Custom code within Adeptia To Bulk Load Data into Snowflake and cleanup temp files
- Convert the .xlsb file into .xlsx extension
- Setting context variable in parent flow when Redis is enabled
- Ability to spawn child flows based on the number of static threads
- Inserting data into JSONB and UUID data type in the Postgres Database
Triggers
- Database Trigger - MySQL
- Event Error - Email Notification
- Trigger the event every 5 minutes
- File Event - Best Practices
- Complex Event Example
- MySQL database trigger
Schemas
- Schema Using API – Adeptia
- Video: How to build an Excel Layout
- Video: How to build a Text Layout
- Video: How to build an Advanced Positional Layout
- Sample Advanced Positional Data Definition file format
- Video: How to build a Positional Layout