June 20, 2018
June 20, 2018 | Volume 12 Issue 22
- LEAD ARTICLE: POWERUp 18 Recap
- FEATURED ARTICLE: Making Node.js a Business Application Language
- FEATURED ARTICLE: Book Review: Extract, Transform, and Load with SSIS
- NEWS HIGHLIGHT: IBM Cloud Fuels Smart Building Innovation
- WHITE PAPER: 3 Compelling Drivers for Implementing an HA Solution on an IBM i Cloud with MIMIX
- FEATURED VIDEO: Design an Invoice in 10 Minutes
- EVENT: Query, Reporting, and Analytics for IBM i Users

POWERUp 18 Recap
COMMON’s POWERUp 18 showcased new hardware editions and cognitive solutions.
By Steve Pitcher
I’m going to bounce around a little with my topic coverage, because there’s a lot to talk about with regard to POWERUp, COMMON’s newly renamed spring conference that was held in San Antonio last month.
About 1,000 people attended this year. As part of the Board of Directors for COMMON, I try to shake every attendee’s hand and say hello. I haven’t confirmed yet, but it seemed that the number of first-time attendees was up really well this year (we give those people special ribbons to signify them).
IBM Unveils New Offerings for Faster and More Secured Path to Hybrid Cloud
IBM Watson Now Available Anywhere
IBM Chairman, President And CEO Ginni Rometty To Keynote IBM Think 2019
Register Now: Introducing Profound UI Version 6 |

Making Node.js a Business Application Language
You want to start developing an application in Node.js, but you soon realize the JavaScript language is not necessarily business oriented. What to do?
By Brian May
JavaScript, like most interpreted languages, can be immensely powerful due to its flexibility. Variables can be dynamically typed, code can be passed as a parameter and executed, and code can be run asynchronously. These types of features allow amazing things to be done. As a true geek, I love to use these types of things.
Mobile Computing and the IBM i
Mobile computing is rapidly maturing into a solid platform for delivering enterprise applications. Many IBM i shops today are realizing that integrating their IBM i with mobile applications is the fast path to improved business workflows, better customer relations, and more responsive business reporting. The ROI that mobile applications can produce for your business is substantial.
This ASNA whitepaper takes a look at mobile computing for the IBM i. It discusses the different ways mobile applications may be used within the enterprise and how ASNA products solve the challenges mobile presents. It also presents the case that you already have the mobile programming team your projects need: that team is your existing RPG development team!
Download your copy today!
3 Compelling Drivers for Implementing an HA Solution on an IBM i Cloud with MIMIX
1. Affordable Cloud Solutions
2. Efficiencies of MIMIX
3. Rising Cost of Downtime
This collaborative effort from Connectria Hostingand Vision Solutions will provide a review of the core causes and costs of both planned and unplanned downtime and will then provide a detailed discussion of current options for IBM i High Availability and Disaster Recovery in the Cloud.
Most importantly, as you read you will learn why true HA and DR protection are now within reach of even the smallest of businesses.
Get a copy of this White Paper Now!
Survey Results: 2018 Top Cybersecurity Risks and Mitigation Strategies
Protecting your organization from cyberthreats has never been more important—or more difficult.
In 2018, HelpSystems surveyed more than 600 IT and cybersecurity professionals to find out what security exploits loom largest and what strategies they’re turning to for protection.
Watch to learn about:
- Security strategies your peers are most interested in implementing
- How managers and executives prioritize security
- Who is responsible for cybersecurity at organizations around the world
- Where IT pros turn for assistance with security
You'll also get practical tips for using this data to drive cybersecurity conversations at your organization.
watch now!
Make Modern Apps You'll Love with Profound UI & Profound.js
It's time to make your apps proud to be seen! Whether you have green screens or a drab GUI, your outdated apps can benefit from modern source code, modern GUIs, and modern tools. Alex Roytman and Liam Allan show you how Free-format RPG and Node.js make it possible to deliver apps your business will love.
You'll learn how you can use both Profound UI and Profound.js to: Transform legacy RPG code to modern free-format RPG and Node.js; Deliver truly modern application interfaces with Profound UI; Extend your RPG applications to include Web Services and NPM packages with Node.js.
ACO MONITOR Manages your IBM i 24/7 and Notifies You When Your IBM i Needs Assistance!
ACO MONITOR is a complete systems management solution for your Power Systems running IBM i. ACO MONITOR manages your Power System 24/7, uses advanced technology (like two-way messaging) to notify on-duty support personnel, and responds to complex problems before they reach critical status.
ACO MONITOR is proven technology and is capable of processing thousands of mission-critical events daily. The software is pre-configured, easy to install, scalable, and greatly improves data center (and staff) efficiency.
Try ACO MONITOR FREE for 30 days.
Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Why support 5 different products, when you can do it all with MarkMagic?

Book Review: Extract, Transform, and Load with SSIS
Do your business apps access different data sources? This book shows you how to make that task easier
by Steven Cole
As a developer, I have often worked with business applications that pull in data from various sources, such as files or databases, and send that data to multiple destinations. This sounds simple enough, but clients and/or applications typically do not send or receive data the same way. So, what happens when you must update that data for the destination to take it in? There are multiple tools you can use to modify (transform) this data—essentially, the extract, transform, and load (ETL) concept. Wouldn’t it be great to have one tool to handle multiple ETL scenarios? That’s where Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and DB2 comes into play. This book is exactly what the title states. In it, authors Thomas Snyder and Vedish Shah dive into how to use Microsoft’s SQL Server Integration Services (SSIS) to accomplish these tasks.