Adeptia Help
Getting Started
Using Adeptia
Adeptia Connect
Support
Archive
Adeptia INTERNAL
Categories
-
Data Integration examples & videos
- Building Process Flows in Adeptia Connect
- Publish Process Flow as a REST API
- Calling SOAP or REST APIs in a Process Flow
- Connecting to Kafka in a Process Flow or via Data Transaction
- How to call a Process Flow from a data on-boarding Transaction
- How to Apply Data Validation Rules and Generate an Error Report
-
General topics & demo videos
- How to configure LEFT JOIN SQL query in Advanced Database Layout
- Joining Multiple Tables in Advanced Database Layout
- Configuring EDI Transactions in Adeptia Connect
- How to use Artificial Intelligence to automate data transformation?
- Adeptia Connect - Create and Manage new Data Transactions and Maps
- Adeptia Connect Process Designer - General Navigation Tutorial
-
Training videos
- Setting up a Data Transaction in Adeptia Connect
- How to create and manage Maps in Adeptia Connect?
- Adv Training Scenario - JSON Web Service Flow
- Training Manual - Foundation Course
- Training Session 1
- Training Session 2
-
EDI & HIPAA HealthCare Integration
- Setup EDI, HIPAA Transactions in Adeptia Connect
- HIPAA Integration: Setting up Trading Partners
- HIPAA Integration: Managing EDI HIPAA Schemas
- HIPAA Integration: Automate HIPAA Messages
- HIPAA Integration: Managing EDI HIPAA Data Standards
- HIPAA Integration: Data Mapping
-
HL7 Healthcare Integration
- Adeptia Healthcare HL7 Integration Solution
- Adeptia HL7 Integration: HL7 Message Standards List
- Adeptia HL7 Integration: FHIR Message Standards List
- Adeptia HL7 Integration Solution Technical Features
-
Data Interface tutorial videos
- Database to QuickBooks
- Database to NetSuite
- Google Spreadsheets to Database
- Email to Database
- Database to File
- File to Database
-
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
- 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
- New 6.1 maintenance patch updates
-
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
- 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
- Sample Positional Data Definition file format
-
Adeptia Videos
- Add and Manage Networks and Partners
- Adeptia Connect Overview for IT Users
- Adeptia Connect Overview for Business Users
- Configure a Data Transaction
- Connecting to Snowflake
- How to setup EDI Transactions
-
Tips and Tricks
- Calling REST API with parameters passed as x-www-form-urlencoded
- Truncate table manually for Connect portal.
- API call to check if a transaction exists for a Partner based on the Partner Parameter.
- Repositories are visible as encrypted in connect portal.
- Error migrating Process flow when column au_json content is null.
- Getting false while connecting with Salesforce.
-
Troubleshooting Adeptia Connect
- Session not valid error in Adeptia Connect
- Unable to View Diagnostics for Failed Flows/Integrations in Adeptia
- Invalid login authentication error when updating the activity.
- Getting "ORA-00001: unique constraint violated" error with Web Service Provider
- Patch application failed on Linux server with Database Connection error
- Issue while fetching low confidence suggestions in AIMap in v3.3.
-
Features Videos
- A Business Application, Not A Developer Tool
- Social Network Approach
- Collaboration Portal Internal and External Users
- Customer and Supplier Portal
- Shared Connections
- Directory of Shared Connections
-
Example Exercises
- Example Exercises
- Connect to a Shared Connection - Pass Thru
- Connect to a Shared Connection - Convert
- Create a Shared Connection and Approve Access
- Fixed Width File Conversion in Adeptia Connect
-
Connecting Source\Target
- SAP Gateway Registration Error: CUSTOMERCECP1 Connection Rejected from Host 10.*.*.*
- FTP File Not Deleting After Transfer? Resolve 'Delete File on Success' Issues!
- Upgrading MySQL Driver 8 in DB Driver and DB Info in AC
-
How To
- Configuring Application Time Zone
- Detailed post patch application steps for upgrading to v3.7.2 or 6.9.15
- How to dynamically override a Child Process Flow?
- Using Adeptia Connect without internet access
- How to pass data from Parent to Child Flow in Adeptia Connect?
- Adeptia Connect User Guide
-
Debugging
- External monitoring of Adeptia Services using Zabbix
- Issue with Double Quotes in a Date Format
- Kernel shutdown with Process status: 137
- Unexpected Values in JSON when converted from XML using JSON Schema
- Setting Up Plumbr with Adeptia
- Debug Web Services Issue(WS-Consumer/WS-Provider)
-
Policies and Procedures
- Adeptia Support
- Spring framework vulnerability - CVE-2022-22965
- Publishing Rest Ws Provider on a Custom Port(s) in GBI
- Invoke Rest Url with dynamic value
-
Tips & Tricks
- CVE-2021-44228: Log4j2 Vulnerabilites & Resolution.
- Unable to Activate Adeptia License
- Mail Notification Utility
- Relative and Absolute Path For FTP.
- To capture the file size of file.
- Getting error "ORA-12899: value too large for column" in Kernel log
-
Troubleshoot
- Application Blocked by Java Security
- Custom Plugin: Scheduler Status Check
- Unable to Use Tracer Utility Due to High CPU? Here's Another Way to Capture Thread Dumps
- Unable to deploy the Objects
- Issue activating JMS event
- Unable to setup LDAP over SSL
-
Release Notes
- v6.2 SP1 Release Notes
- v6.2 Release Notes
- v6.1 Release Notes
- v6.0 SP1 Maintenance Patch Release Notes
- v6.0 SP1 Release Notes
- v6.0 Release Notes
-
Evaluation Guides
See All Articles -
Getting Started Guides
- v6.2 Getting Started Guide
- v6.1 Getting Started Guide
- v6.0 Getting Started Guide
- v5.3 Getting Started Guide
- v5.2 Getting Started Guide
- v5.1 Getting Started Guide
-
Modeler and Simulation Guides
- v6.1 Modeler and Simulation Guide
- v6.0 Modeler and Simulation Guide
- v5.3 Modeler and Simulation Guide
- v5.2 Modeler and Simulation Guide
- v5.1 Modeler and Simulation Guide
- v5.0 SP2 Modeler and Simulation Guide
-
Developer Guides
- v6.2 Developer Guide
- v6.1 Developer Guide
- v6.0 Developer Guide
- v5.3 Developer Guide
- v5.2 Developer Guide
- v5.1 Developer Guide
-
Admin Guides
- v6.2 Admin Guide
- v6.1 Admin Guide
- v6.0 Admin Guide
- v5.3 Admin Guide
- v5.1 Admin Guide
- v5.0 SP2 Admin Guide
-
Installation Guides
- v6.2 SP1 Installation Guide
- v6.2 Installation Guide
- v6.1 Installation Guide
- v6.0 Installation Guide
- v5.3 Installation Guide
- v5.2 Installation Guide
-
User Guides
- v6.1 Business User Guide
- v6.0 Business User Guide
- v5.3 Business User Guide
- v5.1 Business User Guide
- v5.0 SP2 Business User Guide
- v5.0 SP1 Business User Guide