Getting Started

Mongo DB Json Extract

Hi, I have field in mongodb as greater than 65535 array of JSON data.. I'm used varchar(max). It only get 65535 character count from source to redshift. Any option to...

streaming ETL

Hi....is anyone using Matillion in a streaming fashion where it is reading directly from Kinesis or Kafka?

How to get identity from one row insert?

We would like to generate id for each job execution. CREATE TABLE public.etlbatch ( _etlbatchid INTEGER NOT NULL IDENTITY(1, 1), datetimeid TIMESTAMP DEFAULT ('now'::character varying)::timestamp without time zone NOT NULL,...

Evaluating Matillion

Hi Matillion Community, My team is in the process of evaluating ETL tools to load data from 30+ data source into our data lake. I have two questions: - Does...

MongoDB Component

Hi, I'm updating my mattillion version 1.36.7 and now iam facing some iisue in mongodb components from basic mode. Some fields in mongodb but not display in basic mode. I'm...

Do Matillion have a Split component?

My destinations: CREATE TABLE TBL_1 (DT DATETIME ); CREATE TABLE TBL_2 (INTG INT ); CREATE TABLE TBL_3 (TXT VARCHAR(30)); Source (one file, no header, pipe delimiter): TYPE1| 2018-08-13 00:00:00 TYPE2|1234...

WSDL to generate API Profile?

I've got a WSDL file (XML) that defines a set of APIs. In trying to use the API Profile tool, where does that file need to live? On the server...

Export Schedules?

Is there a way to export Schedules or otherwise move them between Projects?

Mysql Connection over ssh

While dragging a database query component and enter MySql connection details, our MySql needs to be connected over ssh, but there is no option to enter the ssh server instance...

XL query component (redshift)

Wondering if its possible to skip a number of lines at the beginning before loading in data from XL. Lets say we have a header line at line 5 then...