FEATURE ARTICLES >>

TechTip: Store and Parse JSON Data Natively with DB2 for i

Learn how the latest DB2 for i features can reduce development time when interacting with the popular JSON data format.

Written by Michael Sansoterra

In my prior tip about using JSON with DB2 for i, I articulated a method of accessing JSON with SQL by use of Java external user-defined functions (UDFs) that convert JSON to XML and XML to JSON. Starting in IBM i 7.1 TR10 (Database Group PTF Level 34) and IBM i 7.2 TR2 (Database Group PTF Level 5), IBM has added native JSON support to the DB2 for i database engine. Keep in mind that, at this first release, the JSON support is still considered a "technology preview," so be sure to test any JSON implementations carefully before using them in production. Also, based on available documentation, some of these features and JSON functions are not yet advertised by IBM for the IBM i and may be subject to change.

Read more >>
 
TechTip: Wizard Analytics on DB2 Web Query, Part 1

Business analysts, developers, administrators, and even non-technical individuals can get started generating sophisticated reports and visualizationsover their own datain minutes!

kathy steinbrinkWritten by Kathy Steinbrink

IBM DB2 Web Query for i is an analytics tool for modernizing Query/400 reports and delivering analytics to the web or mobile devices. It's a web-based Business Intelligence (BI) solution for visualizing, analyzing, and sharing critical business data. Available since 2007 on the IBM i platform, DB2 Web Query has delivered through the years a steady heartbeat of new function.

Read more >>
 
What's Hot: Secure File Transfers on IBM i. What's Not: FTP

Organizations must rethink how file transfers are secured and controlled within the organization.

bob luebbeWritten by Bob Luebbe

Every day, millions of files are transmitted around the world by corporations, government, and other organizations. These electronic transfers include the critical data needed to conduct business, such as customer and order information, EDI documents, financial data, payment information, as well as employee and healthcare information.

 

File Transfer Protocol (FTP) has been used for decades to transmit vital information, but this popular protocol has serious security risks that should not be ignored.

Read more >>
 
Data Masking and Assuring Security During Software Testing

Your production data could be more exposed than you think during software testing.

Written by Green Light Technology

Editor's note: This article introduces the white paper "A Road Map to Successful Data Masking," which is available free from the MC White Paper Center.

 

Data masking during software testing (or otherwise) is not the simple process that the uninitiated might suppose. Gone are the days when replacing personally identifiable information with random characters makes the grade. Obfuscating data for use in development, testing, and QA environments means you need to be able to quickly provide teams with secure sets of consistent, meaningful data that can be used again and again. But this can be difficult to achieve, particularly in geographically dispersed organizations, and especially if you don't adopt a systematic, centralized approach to de-identifying sensitive data.

Read more >>
 
The Benefits of a Strong Security Implementation…Beyond Security

Carol explains the benefits of implementing the features of IBM i security…beyond the obvious security-related benefits.

carol woodburyWritten by Carol Woodbury

While the benefits of using the integrated features of IBM i security are obvious—confidentiality of data, data integrity, fully audited, etc. —benefits beyond the obvious exist. Let's take a look.

Read more >>
 
TechTip: Building Charts with Highcharts, Part 2

Add more flavor to your charts.

jan jorgensenWritten by Jan Jorgensen

In my last TechTip, I described how to set up Highcharts and how to make a very simple standard chart using Highcharts right out of the box. With a simple AJAX call, we created a line chart out of some very basic data. In this TechTip, we'll make the charts look better, add more functions, and dig into the API documentation to show how to find examples and test ideas.

Read more >>
 

INDUSTRY NEWS >>

OpenLegacy Announces New eSuite Integration Platform and Secured Web Gateway

Enables any core enterprise system to integrate with mobile, web, or cloud via standard APIs.

Read more >>
 
Red Hat Updates Integration Offerings

Red Hat, Inc. announces the release of Red Hat JBoss Fuse 6.2 and Red Hat JBoss A-MQ 6.2, introducing new capabilities to help developers simplify their enterprise application and messaging initiatives.

Read more >>
 
Red Hat Introduces the Red Hat Mobile Application Platform

Red Hat, Inc. introduces the Red Hat Mobile Application Platform, which incorporates technology from the  acquisition of FeedHenry with products from Red Hat's JBoss Middleware and OpenShift PaaS portfolio, and adds new mobile services.

Read more >>
 
IBM Performance Management Portfolio Provides Three New Offerings to Manage Critical Hybrid Workload

IBM Application Performance Management V8.1.1IBM Application Diagnostics V8.1.1, and IBM Application Performance Management Advanced V8.1.1

Read more >>
 
IBM Business Process Manager on Cloud for US Federal

fIBM Business Process Manager on Cloud for US Federal provides enhanced self-service capabilities and additional purchase options.

Read more >>
 
IBM dashDB Provides Data Warehousing and Analytics Service in the Cloud

IBM dashDB data warehousing and analytics service allows you to focus on the business, not the business of data warehousing.

Read more >>
 
Docker Trusted Registry Brings Hybrid Cloud Portability to Enterprise Applications

Docker Trusted Registry Is a solution for creating a private image repository of Docker images behind the firewall.

Read more >>
 
IBM PureApplication Service Offers Hybrid Cloud Environment

IBM PureApplication Service delivers enhancements for an enterprise-grade, hybrid cloud environment and the ability to purchase and configure PureApplication Service by using an online, self-service portal.

Read more >>
 

VIDEOS>>

Introduction to Configuring iAccess Servers to use SSL

To see a list of all the MC Press videos, click here

UPCOMING EVENTS >>

Tue Jun 30 @08:30 - 11:30AM
i-Hosting-i + PowerHA
Tue Jun 30 @10:00 - 10:30AM
The Impact of IPv6 on Network Management
Tue Jun 30 @13:00 - 01:30PM
No Time for IBM i Security? No Problem.

Events Calendar

June 2015
S M T W T F S
31 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 1 2 3 4

LATEST COMMENTS >>

RESOURCE CENTERS >>

NEW White Paper

MC White Paper Center

8 Very Good Reasons to Use Your Power i For Shipping

 

MC PRESS STORE >>

NEW BOOK!

FREE-FORMAT RPG IV

 

See the new H, F, D

and P specs in action.

ORDER YOUR COPY TODAY

*******************

WEBCAST

MC Webcast CenterFEATURED WEBCAST

See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

 

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 

 

Watch the Webinar Now!

 

TRIAL SOFTWARE

MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.

   MC-STORE.COM

Latest Offer from the MC Press Bookstore >>

Element Break

 

NEW BOOK - FREE-FORMAT RPG IV


A must-read for all RPG programmers, featuring completely updated code. See the new H, F, D and P specs in action in this easy-to-use reference guide.

On Sale Now - Save 10%

ORDER YOUR COPY TODAY
 Element Break

 

eBook Special >>

 

 

Shop the MC Press Store