This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Created by @pkona
This pipeline pattern uses the Script Snap to change the case of all attributes in the document to upper or lower case.
Configuration
Sources: JSON
Targets: JSON
Snaps used: JSON Generator, Script
Downloads
Pattern - Change case...
Created by @pkona
This pipeline pattern uses the Script Snap (here labeled Execute Script Snap) to call a command line utility on the Snaplex node. This pipeline calls any allowed shell command on the Snaplex node and the command is executed as the ...
Created by @pkona
This pattern ingests all the tables present in an Oracle database into the Hadoop Data Lake. This pattern will achieve the following:
Automatically creates Avro schemas and Hive tablesAutomatically shards large tablesIngests data i...
Created by @pkona
This pipeline pattern determines changes between two data files (inserts, updates, deletes, no-changes, older-records-for-updates).
This is a standard mode pipeline pattern that illustrates how to find and separate changes like ins...
Created by @pkona
Integrations involving ingesting data into Hive requires creating tables on Hive and creating the schema for data formats like Avro.
This pattern generates the AVRO schema based on querying the table metadata for a Oracle table. It...
Here is the link to the current documentation on Microsoft on installing the sqltools on linux. Its pretty straight forward
docs.microsoft.com
Install SQL Server command-line tools on Linux - SQL Server
Learn how to install the ...
The oracle extract uses the limit offset to help with shrading the data. If you plan to ignore shrading the data then you can easily convert the existing pattern to support MSSQL and target as Snowflake… Set shrading as no in the pipeline parameters ...
The snap requires a field " BCP absolute path" that needs the
Absolute path of the BCP utility program in JCC’s file system. If empty, the Snap will look for it in JCC’s environment variable PATH.