Advanced

Matillion with GoldenGate (not instead of)

We have an existing GoldenGate CDC process for some sources which will eventually go away. We want to load this and other data into Snowflake on AWS. If I understand...

importing environment variables

Hi, I exported my matillion jobs and environment variables from a dev project in the hope that I can import those objects into our pre-prod project. When I imported the...

Matillion REST API Endpoint

Hi, We need to set up a load balancer in front of our Matillion server. To make a long technical explanation short, we need to change the endpoint path from...

get status job web services v1

Hi I can use v1 web services with python to check status of tasks and also to start tasks. However I need to get the current (last) status of a...

Matillion REST API Returns all Jobs

We are attempting to get the our job scheduler working with the REST API. We fire the following curl command to start the job: curl -u ec2-user:<pwd> -X POST "<server...

OpenID Google Setup

I've tried to setup the Google OpenID setup. I've done the steps as I understand them but I still get an "Invalid Username or password" error when logging in via...

Adobe Analytics

Currently loading information from Adobe Analytics data feed into Snowflake via an orchestration. The transformation aspects are quite daunting. Looking for articles or reference data that might provide some guidance...

Update default job variable value

Is it somehow possible to update default job variable value? e.g. I have job variable foo=0 Then I update it foo=5 in Python script, but value remains updated only in...

How do we use Netsuite SuiteAnalytics

Hello, I know matillion Netsuite connector is using SOAP based web services to extract data from Netsuite but Netsuite also has SuiteAnalytics which is kind extracting from database using JDBC/ODBC...

Capture Errors in SNS component

Hi, we are using SNS component to notify the user for any job fail, now we want to send the notification email with Error message included in it , is...