Orchestration Components

Bash Script component

I am trying to use the bash script component (in conjunction with a file iterator) to move a file from one directory of an sftp site to another. Is there...

Accessing the New SQL Editor in v1.33?

The version 1.33 release notes say: "SQL Editor (in all Query components) now shows available Tables/Columns and Variables to help you author and test SQL queries from source systems." I...

Salesforec Query Error

I am trying to use username/password/security token to connect. But still getting a Timeout error. I have listed Matillion IP as trusted IP in SFDC portal too. Please suggest.

ServiceNow query

From which version , can we use the ServiceNow query component in orchestration components ? Our version: Version: 1.28.7 (build 36) AMI Version: 1.28.7

Delete S3 Objects

How do I go about deleting an S3 object? I want to copy an object from inbox into archive and then delete it from inbox. The S3 Put Object component...

MongoDB query component advanced connection options

Hello, I am trying to connect to a Mongo cluster in Atlas. How do I specify advanced connection options e.g. authentication database or use ssl? These options don't seem to...

RDS Query component no long works in Version: 1.25.3 (build 66)

I get this error when I try to pull data from RDS "Exception during component validation: null" How do I fix?

Identifying File Format from its Contents

I'm having trouble figuring out how (or if it is possible) to identify the' format' of a file using its contents. I would like to be able to receive files...

Help with If Component Advanced Settings

I am trying to create a project that determines a files 'format,' (ie. the columns and their types) and, using an if component, loads the data into the correct preconfigured...

Variable in Oracle Database Quey

I am new to this product as am still in the trial mode. But want to use the product as it suites our needs and price point. I have a...