Hi,Configure an sftp server to chroot users into folders:https://askubuntu.com/questions/49271/how-to-set-up-a-sftp-server-with-users-chrooted-in-their-home-directories Generate keys for users:How to use ssh-keygen to generate a new SSH key | SSH.COM Thanks,-Jon
Hi,Like is wildcard match in SQL, generally used with '%':SQL Server LIKE Operator By ExamplesAll supported RDBMS' in ACC ship with regex engines. E.g. for Postgres:PostgreSQL REGEXP_MATCHES: Extracting Text Based on a RegexThe desired functions can be used in ACC by adding to its function list or b...
Hi,This feature appears to operate differently than intended in build 8981.With Multiple approval checkbox checked and 2 approvers, for each response it will execute the workflow from approval activity, and then again for good measure, resulting in 3 executions instead of 1.The logInfo(1) is on the ...
Hi,API calls have no limit in size AFAIK, they're ordinary HTTP POST.The Update data workflow activity defaults to transaction batches of 10k.That said, if possible use files for ETL as they are strictly better:Simple, don't need a message bus or specialized codeReliable, doesn't require high availa...
Hi,It depends on a variety of factors, such as app/db server hardware, configuration, utilization, network setup.Use a benchmarking tool such as Apache jMeter to measure overall system capacity and tune as needed.Thanks,-Jon
Hi,Create a workflow to periodically copy the .eml files from MTA disk/network mount to the S3 bucket configured via ext acct.Alternatively, just mount the S3 bucket using s3fs and skip the workflow and ext acct.Thanks,-Jon