February 10, 2023

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

Issue Highlights
Lead Article - Programming

TechTip: Data Source Base Project, Part 3 - SSIS Code Structure

In Part 3 we look at creating our data source SSIS code structure.  Click here to review Part 1 and Part 2.

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.

As our final step, we will prepare our package for reuse by copying the package to a location external to our SSIS solution.

For readers who may not be familiar with Visual Studio, I would like to do a quick review of the structure of the source code in a solution that will help you understand how we will prepare our package for reuse.

IBM i Security

Penetration Testing for IBM i provides you with “Proof”

A popular topic these days is “Zero Trust”.   How IBM i Pen Testing intersects with zero trust is at the point of proof.

By DXR Security, LLC.

When you consider zero trust in the realm of IBM i, the first thing you think of is to implement a “deny by default” approach. Meaning that objects – especially database files – are created with *PUBLIC authority set to *EXCLUDE and only those users requiring access to the information are granted access. In addition, user profiles are configured with only the authority – especially special authorities – that are required to perform their job functions. So the question is this: How can you know this configuration is working? That’s where IBM i Pen Testing and Zero Trust meet.   With IBM i Pen Testing, you get proof to know whether the security configuration you’ve implemented is working as you intend – or whether this configuration needs improvement.

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.
Featured News

IBM and NASA Collaborate to Research Impact of Climate Change with AI

New IBM Foundation Model Technology Leverages NASA Earth Science Data for Geospatial Intelligence

By IBM Corporation

IBM and NASA's Marshall Space Flight Center today announce a collaboration to use IBM's artificial intelligence (AI) technology to discover new insights in NASA's massive trove of Earth and geospatial science data. The joint work will apply AI foundation model technology to NASA's Earth-observing satellite data for the first time.

Application Dev

Operating Systems

Database

Programming

Management & Career

System Administration

Upcoming Events
MC Press Bookstore

Support MC Press Online

$

Book Reviews

Resource Center

  •  

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: