Designing and Running Pipelines

File Writer Output to GroundPlex

I am suddenly unable to write a file on my groundplex; has anyone see this before? Just a straight write, e.g., “file:///Users/rwhite/Development/test.json”. Oddly, I can read that exact file and location. The error I get follows as well some groundp...

Oracle execute with setting session variables

I would like to set date format and timestamp format for the session and run the select statement in oracle execute snap like this Begin execute immediate ‘alter session set nls_date_format=’‘MM/DD/YYYY’‘’; execute immediate ‘alter session set nls_ti...

Oracle dimension tables to Azure ADLS

We’re starting a project to move dozens of Oracle warehouse dimension tables to ADLS, and are using parent/child pipelines to pass table names. The pipelines correctly pass and resolve the table name to operate on. The child pipeline uses Oracle E...

Resolved! Oracle Table Partition Name as parameter

I have a child pipeline called from Pipeline Execute which is passing partition name as pipeline parameter to Oracle-Execute snap Oracle-Execute has a sql => “select * from obia1.sales_invoice_lines partition (” + _partName + “) where rownum < 11” th...

Downloading and writing a base64 encoded ZIP file

Hello, Has anyone had experience of downloading a base64 encoded ZIP file. It sounds relatively straight forward however the file that is created cannot be opened (m/s invalid file format error appears). The size of the file is almost the same as the...

Object mapping

I have a situation in which for one object I can have more than one node which has the same name. However, each node may be different by additional attributes "IsUpdated, “IsAdded”. It is also possible that the node doesn’t have any attentional attri...

Creating output file names dynamically for each SQL Server table data stream taken as input from configuration File

I am trying to create a pipeline which will take a configuration file as an input and it will have Table name and column names that i will need for that table. You can put any no of tables and for each table no of column selected will be different. I...

Resolved! Snaplogic Pipeline Metadata

Hi , I am trying to read the pipeline metadata, specifically the child pipeline names that are invoked from a particular pipeline . I used the Snaplogic Read snap and i have the information in the $snap_map object variable , inside which there are su...

SnapLogic - Integration Nation

Forum Posts

File Writer Output to GroundPlex

Oracle execute with setting session variables

Oracle dimension tables to Azure ADLS

Resolved! Oracle Table Partition Name as parameter

Downloading and writing a base64 encoded ZIP file

Object mapping

Creating output file names dynamically for each SQL Server table data stream taken as input from configuration File

Resolved! Snaplogic Pipeline Metadata

How to read .xlsb file

Append input data vertically

Difference between 2 dates

Find unmatched data using join

split target csv file into more smaller CSV's

How can I edit/update my community posts?

Http Client Snap vs REST Post snap

Parsing CSV file

Data Validator Pattern error

Deleting multiple files at once from SFTP folder