Getting up and running with ECL:

Workshop links:

Join us at our HPCC Systems ECL Workshop

Event date	April 2-5, 2024
Location	Conference room 7028 Malachowsky Hall
Cost	Free
Hosted by	University of Florida
Eligibility	Must be a UF student who pre-registered for the event
Registration	FULL
Learn	Topics Include: Syntax and Queries ETL (Extract, Transform, and Load) Data Delivery Analytics (featuring Machine Learning)
Data Source	Provided on training cluster (Active March 29 - April 5)
Workshop Trainer, and Hackathon support	Bob Foreman - Software Engineering Lead
What you need	A laptop Installed VS Code with ECL Extension or ECL IDE Ability to access the public internet (available in workshop room)
Quick start resources	View our ECL Cheat Sheet to get started quickly ECL IDE Quick start guide ECL training in these six short videos Latest ECL Language Reference Guide VSCode Cheat Sheet
Group messaging application	Microsoft Teams
Internship Opportunities	Find out more about the HPCC Systems intern program

What can I do to prepare?

First thing to do is to watch this series of videos on the introduction to ECL.

Course Title	Video Link

Course Title	Video Link
Introduction to ECL Part 1 Session 1: HPCC Architecture and Introduction to ECL	Part 1
Introduction to ECL Part 1 Session 2: More ECL Introduction, RECORD and DATASET	Part 2
Introduction to ECL Part 1 Session 3: ECL Definitions	Part 3
Introduction to ECL Part 1 Session 4a: Functions and Value Definitions	Part 4
Introduction to ECL Part 1 Session 4b: Functions and Value Definitions	Part 5
Introduction to ECL Part 2 Session 1a: ETL with ECL, Crosstab Reports	Part 6
Introduction to ECL Part 2 Session 1b: ETL with ECL, Crosstab Reports	Part 7
Introduction to ECL Part 2 Session 2a: Data Evaluation, TRANSFORM functions	Part 8
Introduction to ECL Part 2 Session 2b: Data Evaluation, TRANSFORM functions	Part 9
Introduction to ECL Part 2 Session 3a: Transform using Tables, ROLLUP	Part 10
Introduction to ECL Part 2 Session 3b: Transform using Tables, ROLLUP	Part 11
Introduction to ECL Part 2 Session 3c: Transform using Tables, ROLLUP	Part 12
Introduction to ECL Part 2 Session 4a: JOINS and Class Wrap Up	Part 13
Introduction to ECL Part 2 Session 4b: JOINS and Class Wrap Up	Part 14

We have many resources available for you to use to familiarize yourself with our technology and how to use it. If you are new to us, then take some time to find out about HPCC Systems and what we do. Find out how HPCC Systems works, what ECL is and take a look at what goes on in our community.

Watch a quick overview video about HPCC Systems
Create your own Localized Container based Cluster.
- Note: We will be using a cloud-based HPCC Systems cluster for the workshop.
You can use your preferred editor to write code but we do have our own, a Windows-based ECL IDE which you can download. On the download page, under Operating System, select Windows. Download both the ECL IDE and Client Tools.
VS Code is a good code editor if you don't use Windows. Installation is slightly more complicated see below and also this cheat sheet:
1. Download and install VS Code from here if you don't already have it installed.
2. Download the HPCC Systems Client Tools from here.
  1. Choose your operating system from the popup list.
  2. Choose the appropriate "Client Tools" option for your operating system. Make sure only one checkbox on the entire page is selected.
  3. Download and install.
3. Launch VS Code, then search for and install the extension named "ECL (Enterprise Control Language) support for Visual Studio Code".
Once you’re up and running, try out a few of the tutorials.
Learn some ECL. This is the language used to write queries. It's easy to use, try it for yourself. Read the documentation or take a training course.
Take a look at some video tutorials

Be a hero: Help save Missing Kids

Please help HPCC Systems and the ADAM Program to save missing children in your local area by signing up for email alerts!

University of Florida (UF)