• IBM Mulls Using DataMigrator as Cloud Warehouse Pipeline

  June 29, 2022 Alex Woodie

  IBMers are playing around with an update to a little-known ETL tool called DataMigrator for i that would make it easier for IBM i shops to move transactional data to cloud-based data warehousing platforms. The update would use Apache Kafka for the final connection to the cloud.

  DataMigrator ETL Extension, as the product is formally known, is an extract, transform, and load (ETL) tool created by IBM back in 2015. The product was developed to work with Db2 Web Query, the Java-based business intelligence tool that it OEMed from Information Builders (now owned by TIBCO).

  DataMigrator for …

  Read more

• Multiple Security Vulnerabilities Patched on IBM i

  June 22, 2022 Alex Woodie

  In recent weeks, IBM has disclosed a handful of vulnerabilities in its IBM i operating system and related IBM i products, including Db2 Mirror, WebSphere, Navigator for i, the Java development and runtime tools, and OmniFind Text Search Server. IBM has shipped PTFs for the security problems, which range in severity from medium to high.

  IBM warned of security holes in the HTTP Server (the one powered by Apache) in a June 13 security bulletin. The flaws, identified as CVE-2022-22720 and CVE-2022-22721, carry the risk of a HTTP request smuggling that could poison the Web cache, bypass firewalls, and …

  Read more

• IBM Looking To Open Up Debugging On IBM i

  June 8, 2022 Alex Woodie

  Things are moving quickly now in the IBM i development world, particularly when it comes to lightweight, Web-based IDEs, such as IBM’s new Merlin. However, the need to debug programs and the lack of a debugger for these IDEs is causing a bit of a roadblock to developer productivity with these newer IDEs. That’s why IBM is seeking a way to get IBM i debugging capabilities into more people’s hands.

  The official IBM i Debugger product is bundled as a JAR file with IBM Toolbox for Java, and is directly integrated with Rational Developer for i (RDi), IBM’s flagship …

  Read more

• Infor CM3 to Provide On-Prem Alternative to Cloudy M3

  April 20, 2022 Alex Woodie

  For years, Infor has been leading with the cloud when it comes to M3, the ERP system formerly known as Movex. But now, the software giant is readying a new hybrid deployment option called CM3 that will run in a Linux or Windows container and IBM i.

  Long before Infor completed its Lawson acquisition in April 2012 — even before Lawson finished its acquisition of Intentia in 2006 — plans were solidly in place to migrate the core RPG code underpinning the Movex suite to Java, thereby opening the software to run on platforms besides just IBM i, its historical …

  Read more

• IBM i PTF Guide, Volume 24, Number 16

  April 20, 2022 Doug Bidwell

  It is a new week, and there are two new security vulnerabilities in the IBM i platform. First, there is Security Bulletin: IBM WebSphere Application Server Liberty for IBM i is vulnerable to spoofing and clickjacking attacks due to swagger-ui (CVE-2018-25031, CVE-2021-46708), which you can read more about here. The IBM i PTF numbers containing the fix for the CVEs:

  IBM i Release      5770-SS1 PTF Number      PTF Download Link

  7.4                          SI78971                                https://www.ibm.com/support/pages/ptf/SI78971

  7.3                          SI78972                                https://www.ibm.com/support/pages/ptf/SI78972

  7.2                          SI78973                                https://www.ibm.com/support/pages/ptf/SI78973

  Then there is Security Bulletin: OpenSSL for IBM i is vulnerable to a denial of service due to a flaw in …

  Read more

• Connectria, Now A Top AWS Partner, Primed For Hybrid Push

  April 13, 2022 Alex Woodie

  Amazon Web Services has lots and lots of servers and storage — enough to supply the IT needs of more than 1 million customers around the world, including one rather large e-commerce site. The cloud giant also has more than 125,000 business partners helping it to scale out to meet those customer needs. Now, thanks to a recent promotion, IBM i hosting specialist Connectria won’t get lost in the AWS partnership jungle.

  Last week, Connectria announced that AWS has named it a Premier Consulting Partner, the highest echelon in the AWS Partner Network. With just 120 members, the move into …

  Read more

• IBM Ships ACS Version 1.1.9.0

  April 13, 2022 Alex Woodie

  IBM this week delivered an update to Access Client Solutions (ACS), the popular Java-based utility that many IBM i professionals use to interact with the platform. IBM is delivering several enhancements with ACS version 1.1.9.0, some of which came through the request for enhancement (RFE) process. It also defaults to opening IBM’s new Navigator for i, rather than the old one, which is susceptible to the Log4j security vulnerability.

  ACS is the universal Java-based utility that IBM unveiled 10 years ago this August to replace older Client Access products, including the ones for Windows, Linux, and Mac. The software, which …

  Read more

• IBM i PTF Guide, Volume 24, Number 14

  April 6, 2022 Doug Bidwell

  Get your PTF patching fingers ready to roll across the keyboard because there are some new security vulnerabilities in the IBM i platform. First up, Security Bulletin: IBM Db2 Web Query for i is vulnerable to denial of service in Apache Commons Compress (CVE-2021-36090), arbitrary code execution in Apache Log4j (CVE-2021-44832), and cross-site scripting in TIBCO WebFOCUS (CVE-2021-35493), which you can learn about here.

  Release 2.2.0 can be fixed by upgrading to release 2.2.1 or 2.3.0, depending on your IBM i release level:

  • IBM i 7.4: Upgrade to Db2 Web Query for i 2.3.0
  • IBM i 7.3: Upgrade to

  …

  Read more

• IBM i Salaries: Underpaid, Yet Highly Valued And Hard To Replace

  March 7, 2022 Timothy Prickett Morgan

  It is a funny old world. In many cases, the applications that are running on the IBM i platforms of the world are trapped in a kind of time warp and so are the people who created and who maintain them. This is the only plausible explanation for the fact that salaries in the IBM i real world also seem to be in a time warp. And here we are riding up a huge wave of inflation, in something of a war footing thanks to COVID and the war in Ukraine, and it is not yet clear to any of …

  Read more

• Marketplace Study Shows How IBM i Language Use Evolves

  February 9, 2022 Alex Woodie

  It’s no secret that RPG dominates development on the IBM i platform. SQL and Control Language (CL) are also heavily used in the day-to-day operations of tens of thousands of IBM i shops. But what about other established languages, like Java and C++? What about newer open source languages, like PHP and Node.js? The recent HelpSystems Marketplace Study provides us a clue into language use.

  HelpSystems published its first IBM i Marketplace Study back in January 2016, reflecting data collected in late 2015 from 834 IBM i professionals around the world. One of the questions it has consistently asked is …

  Read more

Previous Articles