Orchestration Components

JDBC connection

i m trying to get all the tables from sql server using JDBC incremental load component after connecting successfully couldn't able see list of the tables simply process sysmbol is...

Connect to 'data areas' using a SQL component for IBM DB2 for i.

Greetings. We want to connect to 'data areas' and not normal tables that exist in a IBM DB2 for i database so we can get some values to organise our...

Database Query Component

I tried loading data from sql server to s3 bucket using Database query component , i m gettting some non -readable format data , how can i can load in...

JDBC connection

i m using JDBC Load Component in Matillion ETL For Snowflake...Please help.... I m getting the following error while i connect .... Exception caught whilst testing connection: No suitable driver...

Tables load

Using database query component i can fetch only single table ,if I wanted to load all the tables belongs to a database from sql server to s3 bucket using matillion...

python component to trigger parallel job

Hi team, I have to trigger multiple workflow in a gap of 15-20 minute , I thought of using python script for calling workflow , I believe Matilllion has their...

Data migration from Teradata to Redshift using Database query component taking long time

Hi Team, I am migrating Terdata table Data (approx 200 million records) to Redshift using Database query component , I have setup 17 currency as I am on Cluster ds2.xlarge...

Data migration from Teradata to Redshift using Database query component taking long time

Hi Team, I am migrating Terdata table Data (approx 200 million records) to Redshift using Database query component , I have setup 17 currency as I am on Cluster ds2.xlarge...

Getting Filename from a S3 bucket and assigning into variable

I am trying to get the file name that resides in a S3 bucket. The filename varies every day in the S3 bucket. I need this to be assigned to...

Variable in SQL insert statement

I defined a variable with 'FileName' and assigned a value to it. No I am trying to use this variable in the INSERT INTO statement. cursor.execute("INSERT INTO etlbatch (source) VALUES...