December 16, 2022

MC TNT Header dots fade with byline 2017 06 01 l r

Lead Article - Database

TechTip: Data Source Base Project, Part 1

In this excerpt, we will begin building a base project that can be used as the starting point for the rest of the chapters in this book. If you followed the installation instructions exactly as specified in the previous chapter, you should be able to use the base project with minimal changes.

By Tom Snyder

Editor’s Note: This article is excerpted from chapter 5 of Extract, Transform, and Load with SQL Server Integration Services--with Microsoft SQL Server, Oracle, and IBM DB2, by Thomas Snyder and Vedish Shah.

In the previous chapter we established our database organization as follows:

  • IBM DB2 database
    • Our member and billing maintenance
  • Microsoft SQL Server database
    • Order entry application
    • Web service
  • Oracle database
    • Data warehouse
Featured News

IBM and David Clark Cause Aim to Reduce Food Waste; Name AI-Powered Gardening App Winner of 5th Annual Call for Code

The Linux Foundation invites contributions to two open-source Call for Code sustainability projects

Clinton Global Initiative University announces energy trading platform winner of Call for Code University Edition

By IBM Corporation

Today, Call for Code founding partner IBM, creator, David Clark Cause, charitable partner United Nations Human Rights, and program affiliate, the Linux Foundation announced the winner of the fifth annual Call for Code Global Challenge, which invited innovators across the globe to help accelerate sustainability and combat climate change with open source-powered technology. The top prize this year went to GardenMate for creating an app that uses IBM Watson® to connect gardeners with excess produce to people in need.

White Paper Download

   Profound Logic

 

More than ever, there is a demand for IT to deliver innovation.

Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects.

The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

Get your copy of this important guide today! Download your copy today!
Webcast Learning

   LANSA

 

Supply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals.

In this webinar, we discuss how:

  • Low-Code facilitates the development of Supply Chain Collaborative Portals.
  • Value Chain integration enhances visibility, timeliness, and consistency.
  • New technologies help modernize and expand ERP and Legacy Platform support.

 

Watch Now.
Application Dev

Operating Systems

Database

Programming

Management & Career

System Administration

Featured Event

Upcoming Events
MC Press Bookstore