Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table of Contents
maxLevel6
minLevel1
include
outlinefalse
indent
exclude
stylenone
typelist
printabletrue
class

...

1. AC5.X Deployment

Category

Question

Answer

Prerequisites and Setup

...

What are the prerequisites for deploying AC 5 on Azure?

...

Ensure Kubernetes service

...

Backend and log databases are set up.

, backend and log databases, Azure AKS credentials

...

, secure VPN connection

...

,

...

and admin rights are in place.

...

How do I access Azure AKS credentials?

...

Obtain credentials from

...

the infrastructure team

...

, including Azure portal credentials

...

and

...

Jumphost credentials

...

.

...

What applications are required for AC 5 deployment?

...

Azure CLI, kubectl CLI, and Helm CLI are required for managing Azure resources

...

, Kubernetes clusters, and application deployment.

...

Helm CLI for deploying Kubernetes applications using pre-configured charts.

Installation and Configuration

...

How can I install the Azure CLI on Windows?

...

Download the

...

Run the installer and follow on-screen instructions.

...

installer, follow setup instructions, and verify installation with az --version

...

.

...

How is kubectl CLI installed on macOS?

...

Update Macports with sudo port selfupdate

...

, install kubectl with sudo port install kubectl

...

, and verify with kubectl version --client.

...

How do I create a Kubernetes namespace?

...

Use

...

Code Block
bash

Copy code

...

kubectl create ns <namespace name>

...

. Example: kubectl create ns ac5tmt. Follow naming conventions

...

.

How do I configure the database for AC 5?

...

Create two MySQL databases (backend and log)

...

, create a user

...

, and grant

...

full privileges

...

.

...

How can I set up environment variables in values.yaml?

...

Open values.yaml

...

, update fields like BACKEND_DB_USERNAME and BACKEND_DB_PASSWORD

...

, and enable jobs as needed.

...

How do I install Adeptia Connect using Helm?

...

Navigate to

...

Run:

Code Block
bash

Helm chart folder and run helm install <release name>

...

<chart path> --timeout 10m --debug -n <namespace>

...

.

Deployment Verification and Troubleshooting

...

How can I verify Adeptia Connect’s deployment status?

...

Use kubectl get pods -n <namespace>

...

. If errors

...

occur, use kubectl logs <pod-name> -n <namespace> to troubleshoot.

...

What is the purpose of the values.yaml file in deployment?

...

Centralizes configuration details for easy management of environment-specific settings.

Networking and Accessibility

...

What is the function of Ingress in AC 5 deployment?

...

Ingress manages external HTTP/HTTPS access to

...

Kubernetes services and enables secure routing of traffic

...

.

How can I set up Ingress for AC 5?

...

Modify ingress.yaml

...

, create a TLS secret

...

Code Block
bash

Copy code

using kubectl create secret tls

...

Apply Ingress configuration:

Code Block
bash

Copy code

, and apply configuration with kubectl apply -f ingress.yaml.

...

How is the external IP for AC 5 obtained?

...

Assigned to the Ingress service

...

, with DNS binding handled by the MST team for user-friendly

...

access.

Key Components and Services

...

What is Helm, and why is it necessary for AC 5?

...

Helm

...

simplifies deployment using

...

pre-configured

...

charts, streamlining Kubernetes manifest management.

What role does RabbitMQ play in AC 5?

...

RabbitMQ

...

facilitates asynchronous communication between services, supporting event-driven processing

...

and task queuing

...

.

...

...

  • Backend database: Stores application data.

  • Log database: Captures and stores system logs.

...

What databases are required for AC 5’s backend and log data?

...

The backend database stores application data, and the log database captures system logs. Defined in values.yaml.

...

What are the main microservices in AC 5’s architecture?

...

Portal

...

(user management), Webapp-gateway

...

(request routing), and Event processor (managing triggers).

User Interaction and Operations

...

How do users interact with the AC 5 application?

...

Via a browser. Requests

...

are routed through the

...

web app gateway to backend services like the portal or event processor.

...

How can I check existing namespaces in AKS?

...

Use

...

Code Block
bash

Copy code

kubectl get ns

...

to list all namespaces and their statuses

...

.

...

2. Automations

...

Category

Question

Answer

Overview and Basics

What is an Automation in AC5 Professional?

Automation

...

is a defined workflow

...

for automating ETL processes and ensuring efficient data flow between

...

source and destination

...

applications.

...

What are the types of Automation in AC5

...

?

...

  1. App-to-App Automation:

...

  1. Transfers data

...

  1. between

...

  1. applications

...

  1. .

  1. IDP

...

  1. Automation: Processes unstructured data

...

  1. before transfer.

...

What is the difference between App-to-App and IDP Automation?

App-to-App

...

directly transfers data

...

, while IDP

...

processes unstructured data (e.g., PDFs)

...

into structured formats before transferring.

...

Which applications can be used

...

in Automations?

Some supported applications include:

  • QuickBooks

  • Xero

  • Google Drive

  • Salesforce

  • Shopify

  • Microsoft SharePoint

  • BambooHR

  • Zoho CRM

  • HubSpot, and many others.

...

Supported apps include QuickBooks, Xero, Salesforce, Shopify, Google Drive, Zoho CRM, HubSpot, and more.

Creating and Configuring

How do I create an Automation with QuickBooks

...

?

...

Navigate to

...

Automation

...

> Create New

...

, define QuickBooks as

...

source

...

Configure the necessary settings such as triggers, actions, and mapping.

...

Save the Automation and activate it if required.

...

/destination, configure settings, save, and activate the Automation.

What is a trigger in Automation

...

?

A trigger is an event

...

that starts an Automation

...

,

...

like "New Account"

...

in QuickBooks.

...

How do I map source and destination elements

...

?

...

Use the Data Mapper

...

tool to drag/drop fields or apply mapping expressions; enable data splitting for large files if needed.

...

How can I configure triggers for execution?

Use POLLING for intervals or CRON EXPRESSION for exact schedules to define trigger execution timings.

What is a trigger condition?

A filter that retrieves data meeting specific criteria (e.g., date range or logical operators).

IDP Automation

What is IDP Automation, and how does it work?

...

Processes unstructured data (e.g.,

...

PDFs), extracts key info, converts it to structured formats (e.g., JSON), and transfers it.

Can I customize data extraction in IDP

...

?

Yes,

...

you can define rules for

...

precise data extraction based on business requirements.

...

10. How can I manage an Automation once it is created?

You can manage Automations using options like:

  • View details

  • Edit configurations

  • Delete outdated Automation

  • Run Automations instantly

  • Activate or deactivate Automation

...

What file formats are supported in IDP?

Formats like PDFs are supported, with extracted data converted into JSON or other structured formats.

Management and Operations

How can I manage an Automation?

View, edit, delete, activate/deactivate, or run Automations instantly as needed.

What are the key aspects of

...

Automation

...

?

The key aspects include:

Data flow management

...

, process automation

...

System integration

...

Configuration of rules and settings

...

Monitoring and tracking

...

Error handling

12. What file formats are supported in IDP Automation?

AC5 Professional can handle both structured and unstructured data formats. For IDP Automation, file formats such as PDFs are supported for extracting key information and converting it into structured formats like JSON.

13. How can I configure triggers for Automation execution?

You can configure triggers either through POLLING or CRON EXPRESSION:

  • POLLING: Defines a time interval for checking and executing the Automation.

  • CRON EXPRESSION: Specifies an exact schedule for Automation execution.

14. What is a trigger condition, and how is it used?

A trigger condition filters data fetched from the source by specifying conditions, such as retrieving data within a specific date range or applying additional criteria.

15. Can Automations process data in parallel?

Yes, AC5 Professional allows parallel processing of data. You can enable it by selecting the "Parallel Processing" checkbox and defining the number of concurrent processes.

16. What is the importance of data mapping in Automations?

Data mapping ensures that data from different sources is accurately and consistently transferred or merged into a target system, maintaining data integrity and enabling seamless workflows.

17. What is the role of OAuth in QuickBooks integration?

OAuth is used for authenticating and authorizing data exchanges between QuickBooks and AC5 Professional. You must configure an OAuth Client with a callback URL to enable this.

18. How do I test the connection between AC5 Professional and QuickBooks?

After configuring QuickBooks as either the source or destination application, you can test the connectivity by clicking the "Test" button to ensure data exchanges work correctly.

19. How can I apply filters to data in Automations?

Filters can be applied based on specific criteria to control which records or data sets are fetched from the source application. Filters can be set using logical operators like AND/OR.

20. What happens if an error occurs during Automation execution?

...

, system integration, monitoring, configuration, and error handling.

Can Automations process data in parallel?

Yes, enable "Parallel Processing" and define the number of concurrent processes.

How can I apply filters to data?

Use logical conditions like AND/OR to filter data from the source application.

What happens if an error occurs?

AC5 logs errors, notifies contacts, and allows review/reprocessing of failed tasks.

Integration and Connectivity

What is the role of OAuth in QuickBooks integration?

OAuth provides secure authentication for data exchanges. Configure an OAuth Client with a callback URL for setup.

How do I test the connection with QuickBooks?

After configuration, click the "Test" button to verify connectivity and resolve issues if any.

...

2.1 Automation: IDP to JSON

...