Home / Course catalog / SQL and Flat File Configuration (CFG200)


Get this course

Configuration

SQL and Flat File Configuration (CFG200)


Description
This course teaches the basics of reading from and writing to SQL databases and flat (text) files. The exercises are designed with the assumption that readers already possess general NLINK conceptual knowledge, and know how to navigate through the NLINK Configuration Module, NLINK Debug Module, and the NLINK Management Module.
Content
  • Overview
  • Setup
  • Exercise 1 - Read from SQL and Write to Flat File
  • Exercise 1 Overview
  • 1.1 SQL eXtender - Read Data from SQL
  • Recap: NLINK Configuration Objects in the NCM
  • 1.2 Flat File eXtender - Write Data to CSV
  • 1.3 Additional Exercises
  • 1.3.1 Additional Exercise 1 - Loop Table Action, String Action
  • 1.3.2 Additional Exercise 2 - Add Selection Criteria to SQL Call
  • 1.3.3 Additional Exercise 3 - Date Action, Compare Action
  • 1.3.4 Additional Exercise 4 - Change Flat File Delimiter
  • 1.3.5 Additional Exercise 5 - Set Interface Name & Log Action
  • Exercise 1 Summary
  • Exercise 2 - File Trigger and Write to SQL
  • Exercise 2 Overview
  • 2.1 Flat File eXtender - Flat File Trigger
  • 2.2 SQL eXtender - Write Data to SQL
  • 2.3 Additional Exercises
  • 2.3.1 Additional Exercise 1 - SQL Map Options
  • 2.3.2 Additional Exercise 2 - Date Action, Loop Table Action, Copy Action
  • 2.3.3 Additional Exercise 3 - Compare Action, Copy Action
  • Exercise 2 Summary
  • Exercise 3 - Hierarchical SQL Tables and Complex Flat File
  • Exercise 3 Overview
  • 3.1 SQL eXtender - Read Multiple Tables from SQL
  • 3.2 Flat File eXtender - Sequential File Structure with Delimiters
  • 3.3 Additional Exercises
  • 3.3.1 Additional Exercise 1 - Cross Reference using Individual Calls
  • 3.3.2 Additional Exercise 2 - Cross Reference using Replication
  • 3.3.3 Additional Exercise 3 - String Action
  • 3.3.4 Additional Exercise 4 - Math Action, String Action
  • 3.3.5 Additional Exercise 5 - Math Action
  • Exercise 3 Summary
  • Course Feedback
Completion rules
  • All units must be completed
Back