October 14, 2022

October 14, 2022 | Volume 14 Issue 75
- LEAD ARTICLE: TechTip: Database Setup - IBM DB2 Database
- FEATURED NEWS: Hispanic Heritage Foundation Announces Collaboration with IBM to Upskill Latinos Through IBM SkillsBuild and Meet America's Workforce Needs
- FEATURED EVENT: Choosing your IBM i / AS400 modernization path
- WHITE PAPER DOWNLOAD: Profound Logic Solution Guide
- WEBCAST LEARNING: Low Code: A Digital Transformation of Supply Chain and Logistics
- MC VIDEO SHOWCASE: TLAForms - Software to Design and Generate Forms on IBM i
- UPCOMING EVENT: 2022 October OCEAN Meeting - IBM i Open Source Expert Alan Seiden
TechTip: Database Setup - IBM DB2 Database
We will be building solutions to common problems, which use several different database sources. To provide real-life examples, we will work through actual problems using different databases and SSIS to solve several common problems. We will do this by deliberately using different database types to work in a collaborative environment.
By Tom Snyder
Editor’s Note: This article is excerpted from chapter 4 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 Figure 4.1, you can see that we will be using the IBM DB2 database as our source system of record (SSoR or SOR). Database communications will be made to the SQL Server database using Web services, XML, and database-to-database operations. We will also be creating Excel spreadsheets from our database and sending extract, transform, and load (ETL) updates to our Oracle data warehouse.
IBM Quantum Computer Demonstrates Next Step Towards Moving Beyond Classical Supercomputing
Hispanic Heritage Foundation Announces Collaboration with IBM to Upskill Latinos Through IBM SkillsBuild and Meet America's Workforce Needs
Program to Prepare, Certify and Position Latinos for the Future through Tech Ed and Job Skills
By IBM Corporation
The Hispanic Heritage Foundation (HHF) announced today its collaboration with IBM which includes leveraging IBM SkillsBuild – a free education program that helps students and adult learners develop valuable new skills and access career opportunities in technology fields – by providing digital content, personalized mentoring, and the experiential learning they need to gain technical, critical thinking, and creative problem-solving skills. The program will be offered for FREE to HHF Network, is completely digital, and includes IBM-branded digital credentials that are recognized by the market to create direct pathways to tech jobs. The effort will be open to high school students, college students, young professionals, and adult learners.
|
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.
Watch Now. |
|
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! |


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.
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:
LATEST COMMENTS
MC Press Online