MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

November 11, 2015 | Volume 10 Issue 11


TOP STORY: Easily Create Excel Spreadsheets from Your IBM i Using SSIS
FEATURED NEWS: Incentive Compensation Management V9.0.2 Includes Watson Analytics as an Option
NEWS HIGHLIGHT: Jamison RFID and CYBRA Announce CYBRA-Hawk Loss Prevention Solution
MC PRESS BOOKSTORE: Top Selling Titles
EVENT: Security on IBM i

Sponsor - New Generation Software

FREE Webinar: Migration Alternatives for Query/400 Users: Nov. 18, 2015. 1. Qport Office for Query/400: Pay no license fee for two users. Run IBM Query/400 queries from the Windows desktop. Create/refresh Excel sheets in one click. 2. NGS SDK - $895: Query & Web reporting for one developer & one concurrent user. 3. NGS-IQ: Windows, Web, 5250 interfaces. Define conditional & report break calculations, run-time prompts. Output to Excel, Word, Access, PDF, HTML, OLAP, CSV, XML, & more.


Feature Article - Database
Easily Create Excel Spreadsheets from Your IBM i Using SSIS

Point-and-click your way to building a repeatable, dynamic Excel spreadsheet from DB2.

tom snyderWritten by Tom Snyder

Thanks for sticking it out through my preliminary Microsoft articles. It's about to pay off. Creating Excel spreadsheets from DB2 seems to be a common theme these days, with multiple ways of going about it. The topic of this article is using SQL Server Integration Services (SSIS) with DB2, but it's only the tip of the iceberg for articles to come in the interests of business intelligence, data warehousing, and website feeds.


Sponsor - The MC Press Bookstore

Become a certified DBA. Take on Exams 611 (DB2 10.1) and 311 (DB2 10.5) with this comprehensive 1,248-page book. This valuable resource is much more than a typical study guide. You’ll gain a deep understanding of DB2 server management, physical design, business rules implementation, activity monitoring, utilities, high availability, security, and connectivity and networking. It’s all the fundamentals plus valuable author insight. Includes 50+ step-by-step DB2 feature implementation procedures and 400+ practice questions with detailed answers. Order Today!


Featured News
Incentive Compensation Management V9.0.2 Includes Watson Analytics as an Option

IBM Incentive Compensation Management V9.0.2 delivers a new level of understanding data with a new option, IBM Incentive Compensation Management with Watson Analytics.


Sponsor - The MC Press Bookstore

The wait is over! The 5th edition is here. Here’s your chance to expand your ILE RPG knowledge with our most significant update to this classic RPG book. The latest edition features exclusive coverage of free-format RPG; more SQL than ever before; and greater emphasis on ILE modules, procedures, and service programs. This essential guide covers all the fundamentals you need to be successful with ILE RPG plus the latest development tools. All new programming exercises and assignments included. Order today!


Most Popular MC Press Titles

Best-Selling MC Press Titles

  1. Programming in ILE RPG, Fifth Edition
  2. IBM i Security Administration and Compliance
  3. Flexible Input, Dazzling Output with IBM i
  4. Free-Format RPG IV
  5. Subfiles in Free-Format RPG
  6. IBM Cloud Platform Primer
  7. Mastering IBM i
  8. Database Design and SQL for DB2
  9. DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide
  10. DB2 10.1 Fundamentals (Exam 610)


In the News

Vendors:  Have a press release to share?  Send it to MC Press.

The Latest from IBM

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor