Microsoft LightSwitch Web Apps and DB2 for i

Development Tools / Utilities
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

Use LightSwitch and a SQL Server proxy to build DB2 for i-based web apps.


In my TechTip "Build Web Apps with the Flip of a LightSwitch", I introduced Microsoft LightSwitch and discussed how it can be used to build mobile-friendly web applications. Because it's a rapid application development (RAD) tool, the increased productivity of churning out simple applications and maintenance screens makes LightSwitch an attractive tool, even for developers who don't have much experience with .NET or web development.


I noted however, for shops that use DB2 for i, that the lack of a freely available Entity Framework .NET data provider can be a stumbling block. But if you have SQL Server (even the free SQL Server express), you can use the technique I'll demonstrate here whereby SQL Server can be used as a proxy to connect a LightSwitch app to DB2 for i.


The SQL Server setup instructions may seem a bit long, but most of these steps need to be done only once.


This article assumes that you have some familiarity with SQL Server, ODBC, IBM i Access, and the Microsoft Visual Studio IDE. Also, before doing loads of reading, you may want to glance through the article and look at the application figures 11-13 toward the end of the article so that you have an idea of the end product in mind.

The Demo Setup

The sample app is used to maintain data in the CorpData.Projects table in DB2 for i. The application is a mobile-friendly web application that can run on many devices.


As for components in the demo, I'm using the following:

  • IBM i 7.2 (DB2 for i Group PTF 1)
  • IBM i Access 7.1 Service Level SI53584 (using the ODBC driver)
  • Microsoft Windows Server 2012 Datacenter
  • Microsoft SQL Server 2012 SP1 Dev Edition (SP1) - 11.0.3339.0 (X64)
  • Visual Studio 2013 Premium Update 3

It shouldn't matter if you're running a somewhat older version of SQL Server, Windows, System i Access, IBM i, etc. Just make sure the components of the systems are up to date. The big requirement is Visual Studio 2013 Update 3 (Professional edition or higher) because there's an enhancement to LightSwitch that allows a manual declaration of primary key columns on views (more on this later). As already noted, hopefully Microsoft will garner more LightSwitch adherents with the new Visual Studio 2013 Community edition. This is the free equivalent of Visual Studio professional edition (the difference is just in the licensing).


For ODBC connectivity between SQL Server and another database platform, remember that the ODBC data source should be defined as a system DSN (or a user DSN if it's configured for the same user account running the SQL Server service). Also, make sure the ODBC driver version used in the DSN (32/64-bit) matches the SQL Server version (32/64-bit). Finally, I suggest using the *SQL naming convention with the IBM i Access ODBC driver. The last time I tried, using the *SYS naming convention with SQL Server didn't work even though the dot (.) separator is valid using either *SQL or *SYS naming (starting in IBM i 7.1 PTF Group Level 15).

Sample DB2 Data

For data, I use the old iSeries sample DB2 data library called CORPDATA. The library is not installed by default but can be installed by executing the following procedure:




Note: If you already have this library on your system and it's been modified, you may want to remove it and recreate it. The table definitions for the sample data can be found here.

SQL Server Setup

Warning: What you're about to read may seem excessive and downright ugly. Keep in mind that many of the items I'm discussing require only a one-time setup. Further, the requirements for journaling and XA transactions apply only to read/write scenarios. If you're working with a read-only app, you don't have to bother with XA transactions. If you have an Entity Framework compatible DB2 for i .NET data provider, you can skip this part and go to the section below on creating a Visual Studio LightSwitch project.


Install IBM i Access on the SQL Server box, including the ODBC driver. Next, set up an ODBC data source called DB2i to connect to your DB2 for i CORPDATA schema.


For the demo, LightSwitch will be updating DB2 for i data vicariously through SQL Server's linked server facility. LightSwitch will update special "views" in SQL Server that are dependent on DB2 for i tables. Reading or updating these SQL Server views actually reads/updates the DB2 tables.


Now, define a linked server to connect SQL Server to DB2 for i using the ODBC driver. Shown below is a T-SQL script that will create a linked server named DB2i (based on an ODBC data source called DB2i). Make sure to place your own DB2 for i user name and password in the script below (highlighted in red). Also, replace all references to S104X7AB with the name of your DB2 for i relational database entry (use the WRKRDBDIRE command if you're not sure what your *LOCAL RDB entry is called). Once the replacements have been made, run the script on your SQL Server using SQL Server Management Studio (SSMS).


USE [master]



EXEC master.dbo.sp_addlinkedserver @server = N'DB2I', @srvproduct=N'DB2 for i', @provider=N'MSDASQL', @datasrc=N'DB2i', @provstr=N'CMT=*NONE;DBQ=CORPDATA;NAM=0;XLATE=1', @catalog=N'S104X7AB'



EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB2I',@useself=N'False',@locallogin=NULL,@rmtuser=N'MyUser',@rmtpassword='MyPwd'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'collation compatible', @optvalue=N'false'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'data access', @optvalue=N'true'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'dist', @optvalue=N'false'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'pub', @optvalue=N'false'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'rpc', @optvalue=N'true'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'rpc out', @optvalue=N'true'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'sub', @optvalue=N'false'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'connect timeout', @optvalue=N'0'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'collation name', @optvalue=null


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'lazy schema validation', @optvalue=N'false'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'query timeout', @optvalue=N'0'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'use remote collation', @optvalue=N'true'


EXEC master.dbo.sp_serveroption @server=N'DB2I', @optname=N'remote proc transaction promotion', @optvalue=N'true'



SQL Server is now ready to communicate with DB2 for i.


Next, create a database in SQL Server called LightSwitchDemo using SSMS (unless you've modified your model database, the default options are probably fine). The database's only purpose is to host objects that will be used to connect to DB2 for i.


It's time to create views in SQL Server that reference DB2 for i tables. Run the following script in SSMS to create views that map directly to DB2 for i tables (using the four-part naming convention.) Remember to replace S104X7AB with your own DB2 for i RDB name.


Use LightSwitchDemo
















When accessing the new SQL Server PROJECT view, SQL Server will query the DB2 for i table called CORPDATA.PROJECT. You can test your linked server to DB2 for i by running the following T-SQL query in SSMS in the context of the LightSwitchDemo database:



Distributed (XA) Transactions

When SQL Server updates data in another RDBMS using a linked server, it tries to do so using a distributed transaction (DT). DTs are intended to make sure that data modified within a transaction can be successfully committed on multiple platforms or else rolled back in both places. A few configuration issues need attention when getting DTs to work with DB2 for i.


A side effect of distributed transactions is that SQL Server will sometimes attempt to nest transactions. The DB2 for i ODBC driver, however, doesn't support nested transactions. To bypass this unwanted nesting, the XACT_ABORT setting should be on for any SQL Server connection attempting to update DB2 data. Setting XACT_ABORT on will cause SQL Server to abort any in-progress transactions when an error occurs.


There's not an easy way to control the XACT_ABORT connection setting from LightSwitch, but this setting can be overridden globally in SQL Server using the following script:


-- Server wide SET XACT_ABORT ON

EXEC sp_configure 'user options', 16384



Warning: Changing this setting may alter the behavior of existing database application code. If you're not sure how this setting change will affect SQL Server production databases, use a standalone instance of SQL Server for this demo.

Windows Server Setup for Distributed Transactions (DTs)

For SQL Server to participate in a DT with DB2 for i via the IBM ODBC driver, a Windows service (on the box running SQL Server) called the distributed transaction coordinator must be configured to process XA Transactions. Screen shots for how to do this in Windows Server 2012 are shown here (other versions of Windows may vary slightly):



Figure 1: Click on Administrative Tools > Component Services > Computers > My Computer > Distributed Transaction Coordinator > Local DTC (right-click and choose properties).



Figure 2: In the Local DTC Properties window, select the security tab and then check "Enable XA Transactions."


If you do not complete this step, most likely you will encounter the following ugly message when you attempt to update data in LightSwitch (read operations from DB2 will be fine):


OLE DB provider "MSDASQL" for linked server "DB2i" returned message "[IBM][System i Access ODBC Driver]Enlist with DTC phase failed. 2".


Because of the distributed transaction requirement of this demo, the DB2 for i tables must be journaled so that in-process transactions can be rolled back if needed. The CORPDATA sample data is journaled by default.


In summary, reading or updating the demo's SQL Server views is equivalent to reading or updating from DB2 for i tables; that's the beauty of linked servers. The LightSwitch app will connect to SQL Server and access the views in the LightSwitchDemo database.

The Visual Studio LightSwitch Demo

This demo assumes you have some familiarity working with a Visual Studio solution. This section is a bit long, but I'll take you step by step through how to create the LightSwitch application (and the project assumes that you have a SQL Server instance ready to go following the previously listed configuration requirements).


To create the demo LightSwitch application:

  • Open Visual Studio.
  • Choose New Project.
  • Under Templates, choose your preferred language (VB or C#), choose LightSwitch, and then choose the LightSwitch HTML application (as shown below in Figure 3). 

Figure 3: Create a new Visual Studio LightSwitch HTML application.

  • Choose a name for the project (I called this sample CorpDataMaintenance).
  • When the "Start With data" tab appears, click the "Attach to external Data Source" link and choose Database.
  • Enter your SQL Server information (mine is localhost with Windows authentication specified and database "LightSwitchDemo" specified), hit "test connection" to make sure everything is OK, and then click OK. You'll see the "Choose your Database Objects" window.
  • Assuming your "LightSwitchDemo" database (or equivalent) is set up correctly, choose "Views" and then select all view objects. You should have a screen that looks something like Figure 4.


Figure 4: The Attach Data Source Wizard allows you to connect to tables and views in a database.

  • Click Finish, and Lightswitch will generate all the code necessary to access these views!

In VS, your Solution Explorer should look something like Figure 5 with the selected SQL Server views shown in the "CorpDataMaintenance.Server" project (i.e., middle tier). You'll also notice a second project called "CorpDataMaintenance.HTMLClient." This is where the client tier (UI) code is placed.



Figure 5: Under "Data Sources," the Solution Explorer shows the views from SQL Server available to the application.


You probably noticed that LightSwitch appends an "s" suffix to each view name so that the EMPLOYEE view is represented in LightSwitch as EMPLOYEEs. If you're creating a new database to be used with LightSwitch, it's a good idea to name your tables or views with a singular name (CUSTOMER instead of CUSTOMERs). Unfortunately, mixed-case names are difficult to work with in DB2 for i, so expect data-related references to look a little clumsy with respect to case because LightSwitch is fond of appending a lowercase "s" to table and view names.

Resetting Primary Keys

At this point, we'll have to rework the primary key (PK) column definitions on the views. Since LightSwitch is accessing a DB2 for i table via a SQL Server linked server view, LightSwitch can't obtain information about the primary key column(s). To compensate, LightSwitch defines its own composite PK on various columns. Therefore you have to manually reset the PK column (and this requires Visual Studio 2013 Update 3) to match the key in the DB2 table.


Start by fixing the employee table. In the Solution Explorer, under project "CorpDataMaintenance.Server" > data sources > LightSwitchDemoData (your name may be different), locate EMPLOYEEs.lsml and double-click on it. You should see something akin to Figure 6. You'll notice a key icon next to each column LightSwitch considers to be part of the PK.



Figure 6: When it can't determine the unique identifier of an underlying table, LightSwitch defines a view's primary key as a composite of non-nullable columns.


The PK column should simply be EmpNo. To rectify this, click on each column in the table that has a key icon (except EMPNO), and in the property window uncheck the "is key" property.


Repeat the same steps for:

  • ACTs.lsml (primary key column isACTNO)
  • DEPARTMENTs.lsml (primary key column is DEPTNO)
  • EMPPROJACT.lsml (primary key columns are EMPNO, PROJNO, ACTNO)
  • PROJACTs.lsml (primary key columns are PROJNO, ACTNO, ACSTDATE)
  • PROJECTs.lsml (primary key column is PROJNO)
  • STAFFs.lsml (primary key columns is ID)

The remaining views aren't required to have their primary keys changed for this demo.


Setting Relationships

One benefit of Lightswitch when you're using a database data source is that it inspects the foreign key (FK) relationships between tables and automatically links related tables for you. However, if you have legacy tables without FKs or if you're using views, as in this demo, the FKs need to be defined manually.


Take the time to define FKs, because when you're designing screens in Lightswitch, if a FK is present, it can automatically build screens to show related data. So if you've done your database-design diligence by defining foreign keys, you will be rewarded, as you will see during the screen-design phase (coming up soon).


Note: I think LightSwitch has a bug in that it will not let you define a child relationship on a nullable column.


To define a FK between PROEJCTs and DEPARTMENTs in the Solution Explorer, within the LightSwitchDemoData data source, navigate to the PROJECTs.lsml file and open it by double-clicking on it. Right-click in a gray area and choose "Add Relationship." The "Edit Relationship" window will appear like the one shown in Figure 7. Set the primary (TO) name to DEPARTMENT and set the PROJECT (Foreign) field name to DEPTNO and click OK. Repeat the same steps by adding a relationship to the EMPLOYEE table based on the column PROJECT.RESPEMP.



Figure 7: This figure shows a relationship (aka FK) definition between the PROJECTs and DEPARTMENTs views.

Defining the Summary Property on the Parent Table or View

The great thing about the relationship definitions is that when you're building a screen to display or edit Projects, LightSwitch can automatically show a related value in a parent table instead of showing an "id."


For example, the project table holds a department code, but when you're building a screen, in most cases it makes sense to show a user the department name instead of the code. When LightSwitch sees that the department view is related to the project view, it can show a column from the department table (like department name) instead of showing the department code.


But how does LightSwitch know what column in the parent table (in this case, Department) it should show the user? The answer is the view's "summary" property. This property is intended to tell LightSwitch the column (ideally, a unique value) to show the user based on a FK relationship. You can think of it as an alternate PK. For the department table, the department name would be a good choice for the summary property.


To set the department summary property, open the DEPARTMENTs data source, click the "HTMLClient" tab, select the DEPARTMENT properties, locate the summary property, and choose "DEPTNAME." When users are shown a list of departments (on a screen built on any child FK table), they will see a list of department names instead of a cryptic department id. You'll see how wonderfully this works shortly.


Likewise, you can choose an employee name to be the summary property of the employee view. Open the EMPLOYEEs data source and click the "HTMLClient" tab. Then click the word "Employee" on the title bar, and the properties for the EMPLOYEEs view will be displayed. Locate the summary property and choose "LastName" from the list of columns. When users look for a list of employees, they will see a list of last names (not ideal but sufficient for this demo) instead of a list of employee ids.


If your department names or employee names aren't unique, the user is going to have a tough time deciding among duplicates! A common way around this uniqueness problem in SQL Server is to define a computed column, which is a column expression attached to a table. This will allow a developer to concatenate field names so that the user always has something unique (such as a new column called FULL NAME that consists of First, Middle, Last Name columns on an Employee master). Because DB2 for i doesn't support computed columns, we're kind of stuck as is without implementing a workaround in the SQL Server view (which I can't bother demonstrating due to article length).

Marking the Data Source as Editable

Since LightSwitch could not verify that the PROJECT view was read/write, to be safe, it assumed it would be read-only. To change this, double-click the PROJECTs.lsml file. In the properties window, locate the "Is Editable" checkbox and make sure it's checked. PROJECTs is the only read/write view in this demo, but of course you'll have to mark all views you wish to update as editable in the same manner.

Creating Screens

Now for the good stuff.


For this demo, we're done fussing with the data sources. Here is where all the database setup work will pay off. It's time for LightSwitch to build a few screens. The demo app will have a screen for browsing all projects (including a search box), a screen for viewing project details, and a final screen for maintaining a project. Further, because of the defined foreign key relationships on employee and department, the user will be able to select these values from a list of names (the summary property setup) rather than entering a department code or employee number.


In VS, locate the "Screens" folder under the "CorpDataMaintenance.HTMLClient" project, right-click and choose "Add New Screen" (see Figure 8 below). An "Add New Screen" window will appear. On the left, leave the screen template as "Common Screen Set." On the right, choose "PROJECTs" as the screen data, and check the "PROJECT details" box. This will cause LightSwitch to build the aforementioned screens (browse, view detail, and add/edit) based on the PROJECTs view and link them together with an intuitive navigation. You'll be amazed at what is accomplished without an ounce of programming.



Figure 8: Adding a common screen set will create several related forms that are easy for a user to navigate. If the underlying screen data is updateable, a maintenance screen will be created as well.


Once LightSwitch builds the screens, you'll notice the following screen definitions will show in the Solution Explorer as shown in Figure 9.



Figure 9: The three project screens from the common screen set now show in the Solution Explorer.


All of the work thus far has been defining primary keys, relationships, summary properties, etc. When all of these are set up correctly, LightSwitch builds functional screens! Further, if you have a data source (such as SQL Server or MySQL) that supports the Entity Framework, when everything is already set up correctly in the database, you won't have to bother with the manual primary key and relationship settings!


There are a few things to do to improve the screen usability. In Solution Explorer, double-click BrowsePROJECTs.lsml to open for editing. BrowsePROJECTs is a top-level screen that shows a list of all projects to the user. You will see a list of three columns that are shown to the user: PROJNO, PROJNAME, and DEPTNO. Delete the DEPTNO column and then add the DEPARTMENT column; this will show the department name from the department table instead of showing the DEPTNO code. (You'll see what the screen looks like below in Figure 11.)


For the next UI improvement, open the AddEditPROJECTs.lsml screen. This is the screen that allows users to enter a new project or to maintain an existing one. Remove the DEPTNO and RESPEMP columns (by clicking on the column names and pressing the DELETE key) because they are unnecessary as the DEPARTMENT and EMPLOYEE columns will show the names and make the codes confusing and redundant. For reference, see Figure 10 below:



Figure 10: The PROJECT screen designer shows the list of columns to appear on the right and on the left. Remove the DEPTNO and RESEMP columns for a cleaner UI.


That's it! Press F5 in Visual Studio to run the project. The BrowsePROJECTs screen is the first to appear as shown in Figure 11.



Figure 11: This is the default browse "Projects" screen as shown in Internet Explorer. Each project is represented as a box or "tile" to make sure the app is mobile-browser-friendly.


This web page is fully functional and even has an "add project" and search facility built in. Note that the search facility does not search relationship items. It only searches data in the main table or view the screen is based on.


Each tile can be clicked on to show the "details" or ViewPROJECTs screen as shown in Figure 12:



Figure 12: The details are shown for project MA2113. Notice that both the code values and parent summary values are shown for the department and responsible employee.


Finally, to demonstrate the maintenance screen, click the edit button in the lower right corner of the "View" screen. A popup window will appear and allow edits to be made for the selected project; this is the AddEditPROJECTs screen:



Figure 13: The project maintenance screen is full-featured with date controls and "selection lists" for selecting a department and employee.


Feel free to make some changes and hit the save button (disk icon) at the top of the screen. If you goofed up any of the setup (XACT_ABORT, XA Transactions, journaling, etc.) the update may fail. If the update fails, you'll need to double-check your SQL Server/Linked Server/ODBC configuration.


You may have noticed that the labels on many of these screens can use some help (e.g., mixed case, and text such as Major Project instead of MAJPROJ. But all of these edits can be made rather easily by editing the screens and changing the display name property for the various columns.


Once you're done with your HTMLClient project, you have the option to deploy to a local IIS web server or put it in the cloud with Azure (I've done both with SQL Server projects, and they work great, although details on how to do this are beyond the scope of this article). As you may have guessed, it will pay to read online tutorials or buy a book about LightSwitch.


The Visual Studio project code can be downloaded here (although you will have to change the data source definitions to link to your own correctly configured SQL Server.)

OData Bonus

Recall a LightSwitch project's middle tier makes data available to the client tier by creating an OData service to serve the data. This means that, if desired, other OData-compatible tools can take advantage of this read (and potentially write) data source. Of course, you have to consider security, but space forbids a full discussion!


For this demo project (running in Visual Studio), you can access the OData service by taking the base URL and appending the data source name (in this case, LightSwitchDemoData) and append the .svc suffix:




When looking at the main OData service, it's easy to discern that all of the employees can be retrieved by navigating to the following URL in a browser (I suggest using a browser other than IE for this):




And, if you remember from the OData article, you can do fancy things in the URL because LightSwitch supports many OData features, such as filtering:


http://localhost:49246/LightSwitchDemoData.svc/EMPLOYEEs?$filter=WORKDEPT eq 'A00'


LightSwitch Development Considerations
Here are a few tips worth remembering as you get started with LightSwitch development:

  • Remember that the generated app is intended to be mobile-friendly. For example, there is no option to allow someone to right-click on an element to bring up a context menu.
  • Legacy DB2 for i columns, such as date/time fields stored in a numeric data type, will not use the date/time controls.
  • You need plenty of memory on your PC and/or server.
  • Large data sets may be problematic without coding or modifying the default behavior. For example, using the default search facility on a large table could take quite a while to run.
  • Unlike some Microsoft products of the past, LightSwitch works well in several modern browsers, including Chrome, Firefox, and Opera.


LightSwitch is a great tool for rapidly developing web/mobile-enabled apps. Because of its dependence on the Entity Framework, DB2 for i developers will have to use SQL Server (including the free SQL Server Express) or purchase an appropriate .NET Entity Framework-compatible data provider to allow data access directly on the IBM i/iSeries. Further, when using SQL Server as a read-write intermediary, quite a bit of additional setup is required to support read/write operations against DB2.


However, once you learn LightSwitch, it's a very effective tool. When you're adept with LightSwitch, the example here takes less than 30 minutes to create. I prefer tools like LightSwitch because I then have the ability to rapidly deploy modern web-based interfaces (instead of the green-screen subfiles) without being intimately familiar with web coding.


Michael Sansoterra is a DBA for Broadway Systems in Grand Rapids, Michigan. He can be contacted at



Support MC Press Online





  • Mobile Computing and the IBM i

    SB ASNA PPL 5450Mobile 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.

    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!

    Get your copy today!

  • Automate IBM i Operations using Wireless Devices

    DDL SystemsDownload the technical whitepaper on MANAGING YOUR IBM i WIRELESSLY and (optionally) register to download an absolutely FREE software trail. This whitepaper provides an in-depth review of the native IBM i technology and ACO MONITOR's advanced two-way messaging features to remotely manage your IBM i while in or away from the office. Notify on-duty personnel of system events and remotely respond to complex problems (via your Smartphone) before they become critical-24/7. Problem solved!

    Order your copy here.

  • DR Strategy Guide from Maxava: Brand New Edition - now fully updated to include Cloud!


    Download your free copy of DR Strategy Guide for IBM i from Maxava today.


  • White Paper: Node.js for Enterprise IBM i Modernization

    SB Profound WP 5539

    If your business is thinking about modernizing your legacy IBM i (also known as AS/400 or iSeries) applications, you will want to read this white paper first!

    Download this paper and learn how Node.js can ensure that you:
    - Modernize on-time and budget - no more lengthy, costly, disruptive app rewrites!
    - Retain your IBM i systems of record
    - Find and hire new development talent
    - Integrate new Node.js applications with your existing RPG, Java, .Net, and PHP apps
    - Extend your IBM i capabilties to include Watson API, Cloud, and Internet of Things

    Read Node.js for Enterprise IBM i Modernization Now!


  • 2020 IBM i Marketplace Survey Results


    This year marks the sixth edition of the popular IBM i Marketplace Survey Results. Each year, HelpSystems sets out to gather data about how businesses use the IBM i platform and the IT initiatives it supports. Year over year, the survey has begun to reveal long-term trends that give insight into the future of this trusted technology.

    More than 500 IBM i users from around the globe participated in this year’s survey, and we’re so happy to share the results with you. We hope you’ll find the information interesting and useful as you evaluate your own IT projects.

  • AIX Security Basics eCourse

    Core Security

    With so many organizations depending on AIX day to day, ensuring proper security and configuration is critical to ensure the safety of your environment. Don’t let common threats put your critical AIX servers at risk. Avoid simple mistakes and start to build a long-term plan with this AIX Security eCourse. Enroll today to get easy to follow instructions on topics like:

    • Removing extraneous files
    • Patching systems efficiently
    • Setting and validating permissions
    • Managing service considerations
    • Getting overall visibility into your networks


  • Developer Kit: Making a Business Case for Modernization and Beyond

    Profound Logic Software, Inc.

    Having trouble getting management approval for modernization projects? The problem may be you're not speaking enough "business" to them.

    This Developer Kit provides you study-backed data and a ready-to-use business case template to help get your very next development project approved!

  • What to Do When Your AS/400 Talent Retires

    HelpSystemsIT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators is small.

    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:

    • Why IBM i skills depletion is a top concern
    • How leading organizations are coping
    • Where automation will make the biggest impact


  • IBM i Resources Retiring?

    SB HelpSystems WC GenericLet’s face it: IBM i experts and RPG programmers are retiring from the workforce. Are you prepared to handle their departure?
    Our panel of IBM i experts—Chuck Losinski, Robin Tatam, Richard Schoen, and Tom Huntington—will outline strategies that allow your company to cope with IBM i skills depletion by adopting these strategies that allow you to get the job done without deep expertise on the OS:
    - Automate IBM i processes
    - Use managed services to help fill the gaps
    - Secure the system against data loss and viruses
    The strategies you discover in this webinar will help you ensure that your system of record—your IBM i—continues to deliver a powerful business advantage, even as staff retires.


  • Backup and Recovery Considerations for Security Data and Encrypted Backups

    SB PowerTech WC GenericSecurity expert Carol Woodbury is joined by Debbie Saugen. Debbie is an expert on IBM i backup and recovery, disaster recovery, and high availability, helping IBM i shops build and implement effective business continuity plans.
    In today’s business climate, business continuity is more important than ever. But 83 percent of organizations are not totally confident in their backup strategy.
    During this webinar, Carol and Debbie discuss the importance of a good backup plan, how to ensure you’re backing up your security information, and your options for encrypted back-ups.

  • Profound.js: The Agile Approach to Legacy Modernization

    SB Profound WC GenericIn this presentation, Alex Roytman and Liam Allan will unveil a completely new and unique way to modernize your legacy applications. Learn how Agile Modernization:
    - Uses the power of Node.js in place of costly system re-writes and migrations
    - Enables you to modernize legacy systems in an iterative, low-risk manner
    - Makes it easier to hire developers for your modernization efforts
    - Integrates with Profound UI (GUI modernization) for a seamless, end-to-end legacy modernization solution


  • Data Breaches: Is IBM i Really at Risk?

    SB PowerTech WC GenericIBM i is known for its security, but this OS could be more vulnerable than you think.
    Although Power Servers often live inside the safety of the perimeter firewall, the risk of suffering a data leak or data corruption remains high.
    Watch noted IBM i security expert Robin Tatam as he discusses common ways that this supposedly “secure” operating system may actually be vulnerable and who the culprits might be.

    Watch the webinar today!


  • Easy Mobile Development

    SB Profound WC GenericWatch this on-demand webinar and learn how to rapidly and easily deploy mobile apps to your organization – even when working with legacy RPG code! IBM Champion Scott Klement will demonstrate how to:
    - Develop RPG applications without mobile development experience
    - Deploy secure applications for any mobile device
    - Build one application for all platforms, including Apple and Android
    - Extend the life and reach of your IBM i (aka iSeries, AS400) platform
    You’ll see examples from customers who have used our products and services to deliver the mobile applications of their dreams, faster and easier than they ever thought possible!


  • Profound UI: Unlock True Modernization from your IBM i Enterprise

    SB Profound PPL 5491Modern, web-based applications can make your Enterprise more efficient, connected and engaged. This session will demonstrate how the Profound UI framework is the best and most native way to convert your existing RPG applications and develop new modern applications for your business. Additionally, you will learn how you can address modernization across your Enterprise, including databases and legacy source code, with Profound Logic.

  • Node Webinar Series Pt. 1: The World of Node.js on IBM i

    Profound Logic Software, Inc.Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

    Part 1 will teach you what Node.js is, why it's a great option for IBM i shops, and how to take advantage of the ecosystem surrounding Node.

    In addition to background information, our Director of Product Development Scott Klement will demonstrate applications that take advantage of the Node Package Manager (npm).

  • 5 New and Unique Ways to Use the IBM i Audit Journal

    SB HelpSystems ROBOT GenericYou must be asking yourself: am I doing everything I can to protect my organization’s data? Tune in as our panel of IBM i high availability experts discuss:

    - Why companies don’t test role swaps when they know they should
    - Whether high availability in the cloud makes sense for IBM i users
    - Why some organizations don’t have high availability yet
    - How to get high availability up and running at your organization
    - High availability considerations for today’s security concerns

  • Profound.js 2.0: Extend the Power of Node to your IBM i Applications

    SB Profound WC 5541In this Webinar, we'll demonstrate how Profound.js 2.0 enables you to easily adopt Node.js in your business, and to take advantage of the many benefits of Node, including access to a much larger pool of developers for IBM i and access to countless reusable open source code packages on npm (Node Package Manager).
    You will see how Profound.js 2.0 allows you to:

    • Provide RPG-like capabilities for server-side JavaScript.
    • Easily create web and mobile application interfaces for Node on IBM i.
    • Let existing RPG programs call Node.js modules directly, and vice versa.
    • Automatically generate code for Node.js.
    • Automatically converts existing RPGLE code into clean, simplified Node.js code.

    Download and watch today!


  • Make Modern Apps You'll Love with Profound UI & Profound.js

    SB Profound WC 5541Whether you have green screens or a drab GUI, your outdated apps can benefit from modern source code, modern GUIs, and modern tools.
    Profound Logic's Alex Roytman and Liam Allan are here to show you how Free-format RPG and Node.js make it possible to deliver applications your whole business will love:

    • 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


  • Accelerating Programmer Productivity with Sequel


    Most business intelligence tools are just that: tools, a means to an end but not an accelerator. Yours could even be slowing you down. But what if your BI tool didn't just give you a platform for query-writing but also improved programmer productivity?
    Watch the recorded webinar to see how Sequel:

    • Makes creating complex results simple
    • Eliminates barriers to data sources
    • Increases flexibility with data usage and distribution

    Accelerated productivity makes everyone happy, from programmer to business user.

  • Business Intelligence is Changing: Make Your Game Plan

    SB_HelpSystems_WC_GenericIt’s time to develop a strategy that will help you meet your informational challenges head-on. Watch the webinar to learn how to set your IT department up for business intelligence success. You’ll learn how the right data access tool will help you:

    • Access IBM i data faster
    • Deliver useful information to executives and business users
    • Empower users with secure data access

    Ready to make your game plan and finally keep up with your data access requests?


  • Controlling Insider Threats on IBM i

    SB_HelpSystems_WC_GenericLet’s face facts: servers don’t hack other servers. Despite the avalanche of regulations, news headlines remain chock full of stories about data breaches, all initiated by insiders or intruders masquerading as insiders.
    User profiles are often duplicated or restored and are rarely reviewed for the appropriateness of their current configuration. This increases the risk of the profile being able to access data without the intended authority or having privileges that should be reserved for administrators.
    Watch security expert Robin Tatam as he discusses a new approach for onboarding new users on IBM i and best-practices techniques for managing and monitoring activities after they sign on.

  • Don't Just Settle for Query/400...

    SB_HelpSystems_WC_GenericWhile introducing Sequel Data Access, we’ll address common frustrations with Query/400, discuss major data access, distribution trends, and more advanced query tools. Plus, you’ll learn how a tool like Sequel lightens IT’s load by:

    - Accessing real-time data, so you can make real-time decisions
    - Providing run-time prompts, so users can help themselves
    - Delivering instant results in Microsoft Excel and PDF, without the wait
    - Automating the query process with on-demand data, dashboards, and scheduled jobs

  • How to Manage Documents the Easy Way

    SB_HelpSystems_WC_GenericWhat happens when your company depends on an outdated document management strategy?
    Everything is harder.
    You don’t need to stick with status quo anymore.
    Watch the webinar to learn how to put effective document management into practice and:

    • Capture documents faster, instead of wasting everyone’s time
    • Manage documents easily, so you can always find them
    • Distribute documents automatically, and move on to the next task


  • Lessons Learned from the AS/400 Breach

    SB_PowerTech_WC_GenericGet actionable info to avoid becoming the next cyberattack victim.
    In “Data breach digest—Scenarios from the field,” Verizon documented an AS/400 security breach. Whether you call it AS/400, iSeries, or IBM i, you now have proof that the system has been breached.
    Watch IBM i security expert Robin Tatam give an insightful discussion of the issues surrounding this specific scenario.
    Robin will also draw on his extensive cybersecurity experience to discuss policies, processes, and configuration details that you can implement to help reduce the risk of your system being the next victim of an attack.

  • Overwhelmed by Operating Systems?

    SB_HelpSystems_WC_GenericIn this 30-minute recorded webinar, our experts demonstrate how you can:

    • Manage multiple platforms from a central location
    • View monitoring results in a single pane of glass on your desktop or mobile device
    • Take advantage of best practice, plug-and-play monitoring templates
    • Create rules to automate daily checks across your entire infrastructure
    • Receive notification if something is wrong or about to go wrong

    This presentation includes a live demo of Network Server Suite.


  • Real-Time Disk Monitoring with Robot Monitor

    SB_HelpSystems_WC_GenericYou need to know when IBM i disk space starts to disappear and where it has gone before system performance and productivity start to suffer. Our experts will show you how Robot Monitor can help you pinpoint exactly when your auxiliary storage starts to disappear and why, so you can start taking a proactive approach to disk monitoring and analysis. You’ll also get insight into:

    • The main sources of disk consumption
    • How to monitor temporary storage and QTEMP objects in real time
    • How to monitor objects and libraries in real time and near-real time
    • How to track long-term disk trends



  • Stop Re-keying Data Between IBM I and Other Applications

    SB_HelpSystems_WC_GenericMany business still depend on RPG for their daily business processes and report generation.Wouldn’t it be nice if you could stop re-keying data between IBM i and other applications? Or if you could stop replicating data and start processing orders faster? Or what if you could automatically extract data from existing reports instead of re-keying? It’s all possible. Watch this webinar to learn about:

    • The data dilemma
    • 3 ways to stop re-keying data
    • Data automation in practice

    Plus, see how HelpSystems data automation software will help you stop re-keying data.


  • The Top Five RPG Open Access Myths....BUSTED!

    SB_Profound_WC_GenericWhen it comes to IBM Rational Open Access: RPG Edition, there are still many misconceptions - especially where application modernization is concerned!

    In this Webinar, we'll address some of the biggest myths about RPG Open Access, including:

    • Modernizing with RPG OA requires significant changes to the source code
    • The RPG language is outdated and impractical for modernizing applications
    • Modernizing with RPG OA is the equivalent to "screen scraping"


  • Time to Remove the Paper from Your Desk and Become More Efficient

    SB_HelpSystems_WC_GenericToo much paper is wasted. Attempts to locate documents in endless filing cabinets.And distributing documents is expensive and takes up far too much time.
    These are just three common reasons why it might be time for your company to implement a paperless document management system.
    Watch the webinar to learn more and discover how easy it can be to:

    • Capture
    • Manage
    • And distribute documents digitally


  • IBM i: It’s Not Just AS/400


    IBM’s Steve Will talks AS/400, POWER9, cognitive systems, and everything in between

    Are there still companies that use AS400? Of course!

    IBM i was built on the same foundation.
    Watch this recorded webinar with IBM i Chief Architect Steve Will and IBM Power Champion Tom Huntington to gain a unique perspective on the direction of this platform, including:

    • IBM i development strategies in progress at IBM
    • Ways that Watson will shake hands with IBM i
    • Key takeaways from the AS/400 days


  • Ask the RDi Experts

    SB_HelpSystems_WC_GenericWatch this recording where Jim Buck, Susan Gantner, and Charlie Guarino answered your questions, including:

    • What are the “hidden gems” in RDi that can make me more productive?
    • What makes RDi Debug better than the STRDBG green screen debugger?
    • How can RDi help me find out if I’ve tested all lines of a program?
    • What’s the best way to transition from PDM to RDi?
    • How do I convince my long-term developers to use RDi?

    This is a unique, online opportunity to hear how you can get more out of RDi.


  • Node.js on IBM i Webinar Series Pt. 2: Setting Up Your Development Tools

    Profound Logic Software, Inc.Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. In Part 2, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Attend this webinar to learn:

    • Different tools to develop Node.js applications on IBM i
    • Debugging Node.js
    • The basics of Git and tools to help those new to it
    • Using as a pre-built development environment



  • Inside the Integrated File System (IFS)

    SB_HelpSystems_WC_GenericDuring this webinar, you’ll learn basic tips, helpful tools, and integrated file system commands—including WRKLNK—for managing your IFS directories and Access Client Solutions (ACS). We’ll answer your most pressing IFS questions, including:

    • What is stored inside my IFS directories?
    • How do I monitor the IFS?
    • How do I replicate the IFS or back it up?
    • How do I secure the IFS?

    Understanding what the integrated file system is and how to work with it must be a critical part of your systems management plans for IBM i.


  • Expert Tips for IBM i Security: Beyond the Basics

    SB PowerTech WC GenericIn this session, IBM i security expert Robin Tatam provides a quick recap of IBM i security basics and guides you through some advanced cybersecurity techniques that can help you take data protection to the next level. Robin will cover:

    • Reducing the risk posed by special authorities
    • Establishing object-level security
    • Overseeing user actions and data access

    Don't miss this chance to take your knowledge of IBM i security beyond the basics.



  • 5 IBM i Security Quick Wins

    SB PowerTech WC GenericIn today’s threat landscape, upper management is laser-focused on cybersecurity. You need to make progress in securing your systems—and make it fast.
    There’s no shortage of actions you could take, but what tactics will actually deliver the results you need? And how can you find a security strategy that fits your budget and time constraints?
    Join top IBM i security expert Robin Tatam as he outlines the five fastest and most impactful changes you can make to strengthen IBM i security this year.
    Your system didn’t become unsecure overnight and you won’t be able to turn it around overnight either. But quick wins are possible with IBM i security, and Robin Tatam will show you how to achieve them.

  • How to Meet the Newest Encryption Requirements on IBM i

    SB PowerTech WC GenericA growing number of compliance mandates require sensitive data to be encrypted. But what kind of encryption solution will satisfy an auditor and how can you implement encryption on IBM i? Watch this on-demand webinar to find out how to meet today’s most common encryption requirements on IBM i. You’ll also learn:

    • Why disk encryption isn’t enough
    • What sets strong encryption apart from other solutions
    • Important considerations before implementing encryption



  • Security Bulletin: Malware Infection Discovered on IBM i Server!

    SB PowerTech WC GenericMalicious programs can bring entire businesses to their knees—and IBM i shops are not immune. It’s critical to grasp the true impact malware can have on IBM i and the network that connects to it. Attend this webinar to gain a thorough understanding of the relationships between:

    • Viruses, native objects, and the integrated file system (IFS)
    • Power Systems and Windows-based viruses and malware
    • PC-based anti-virus scanning versus native IBM i scanning

    There are a number of ways you can minimize your exposure to viruses. IBM i security expert Sandi Moore explains the facts, including how to ensure you're fully protected and compliant with regulations such as PCI.



  • Fight Cyber Threats with IBM i Encryption

    SB PowerTech WC GenericCyber attacks often target mission-critical servers, and those attack strategies are constantly changing. To stay on top of these threats, your cybersecurity strategies must evolve, too. In this session, IBM i security expert Robin Tatam provides a quick recap of IBM i security basics and guides you through some advanced cybersecurity techniques that can help you take data protection to the next level. Robin will cover:

    • Reducing the risk posed by special authorities
    • Establishing object-level security
    • Overseeing user actions and data access




  • 10 Practical IBM i Security Tips for Surviving Covid-19 and Working From Home

    SB PowerTech WC GenericNow that many organizations have moved to a work from home model, security concerns have risen.

    During this session Carol Woodbury will discuss the issues that the world is currently seeing such as increased malware attacks and then provide practical actions you can take to both monitor and protect your IBM i during this challenging time.


  • How to Transfer IBM i Data to Microsoft Excel

    SB_HelpSystems_WC_Generic3 easy ways to get IBM i data into Excel every time
    There’s an easy, more reliable way to import your IBM i data to Excel? It’s called Sequel. During this webinar, our data access experts demonstrate how you can simplify the process of getting data from multiple sources—including Db2 for i—into Excel. Watch to learn how to:

    • Download your IBM i data to Excel in a single step
    • Deliver data to business users in Excel via email or a scheduled job
    • Access IBM i data directly using the Excel add-in in Sequel

    Make 2020 the year you finally see your data clearly, quickly, and securely. Start by giving business users the ability to access crucial business data from IBM i the way they want it—in Microsoft Excel.



  • HA Alternatives: MIMIX Is Not Your Only Option on IBM i

    SB_HelpSystems_WC_GenericIn this recorded webinar, our experts introduce you to the new HA transition technology available with our Robot HA software. You’ll learn how to:

    • Transition your rules from MIMIX (if you’re happy with them)
    • Simplify your day-to-day activities around high availability
    • Gain back time in your work week
    • Make your CEO happy about reducing IT costs

    Don’t stick with a legacy high availability solution that makes you uncomfortable when transitioning to something better can be simple, safe, and cost-effective.



  • Node Webinar Series Pt. 1: The World of Node.js on IBM i

    SB Profound WC GenericHave you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.
    Part 1 will teach you what Node.js is, why it's a great option for IBM i shops, and how to take advantage of the ecosystem surrounding Node.
    In addition to background information, our Director of Product Development Scott Klement will demonstrate applications that take advantage of the Node Package Manager (npm).
    Watch Now.

  • The Biggest Mistakes in IBM i Security

    SB Profound WC Generic The Biggest Mistakes in IBM i Security
    Here’s the harsh reality: cybersecurity pros have to get their jobs right every single day, while an attacker only has to succeed once to do incredible damage.
    Whether that’s thousands of exposed records, millions of dollars in fines and legal fees, or diminished share value, it’s easy to judge organizations that fall victim. IBM i enjoys an enviable reputation for security, but no system is impervious to mistakes.
    Join this webinar to learn about the biggest errors made when securing a Power Systems server.
    This knowledge is critical for ensuring integrity of your application data and preventing you from becoming the next Equifax. It’s also essential for complying with all formal regulations, including SOX, PCI, GDPR, and HIPAA
    Watch Now.

  • Comply in 5! Well, actually UNDER 5 minutes!!

    SB CYBRA PPL 5382

    TRY the one package that solves all your document design and printing challenges on all your platforms.

    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.

    Request your trial now!

  • Backup and Recovery on IBM i: Your Strategy for the Unexpected

    SB HelpSystems SC 5413Robot automates the routine tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:
    - Simplified backup procedures
    - Easy data encryption
    - Save media management
    - Guided restoration
    - Seamless product integration
    Make sure your data survives when catastrophe hits. Try the Robot Backup and Recovery Solution FREE for 30 days.

  • Manage IBM i Messages by Exception with Robot

    SB HelpSystems SC 5413Managing messages on your IBM i can be more than a full-time job if you have to do it manually. How can you be sure you won’t miss important system events?
    Automate your message center with the Robot Message Management Solution. Key features include:
    - Automated message management
    - Tailored notifications and automatic escalation
    - System-wide control of your IBM i partitions
    - Two-way system notifications from your mobile device
    - Seamless product integration
    Try the Robot Message Management Solution FREE for 30 days.

  • Easiest Way to Save Money? Stop Printing IBM i Reports

    SB HelpSystems SC 5413Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing.
    Manage your reports with the Robot Report Management Solution. Key features include:

    - Automated report distribution
    - View online without delay
    - Browser interface to make notes
    - Custom retention capabilities
    - Seamless product integration
    Rerun another report? Never again. Try the Robot Report Management Solution FREE for 30 days.

  • Hassle-Free IBM i Operations around the Clock

    SB HelpSystems SC 5413For over 30 years, Robot has been a leader in systems management for IBM i.
    Manage your job schedule with the Robot Job Scheduling Solution. Key features include:
    - Automated batch, interactive, and cross-platform scheduling
    - Event-driven dependency processing
    - Centralized monitoring and reporting
    - Audit log and ready-to-use reports
    - Seamless product integration
    Scale your software, not your staff. Try the Robot Job Scheduling Solution FREE for 30 days.

  • ACO MONITOR Manages your IBM i 24/7 and Notifies You When Your IBM i Needs Assistance!

    SB DDL Systems 5429More than a paging system - 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 efficiency.