Simplify Your ETL With Lozen

You have invested hundreds of thousands or even millions of dollars in your ETL tools and process. It is up and running and doing its job.  There are tradeoffs in terms of additional MIPS consumption and constant maintenance, but you do not want to rip and replace what you already have. Can Lozen help, even if you already have ETL in place?

There are several ways Lozen can help simplify your ETL — and possibly reduce processing costs.  Here are some examples:

  • Leveraging Lozen on cloud or desktop systems allows the use of familiar and usually less costly tools to access the data hosted on
    IBM zSystems
  • Portions of the ETL process can be replaced by Lozen using industry-standard file access protocols and methods
  • Developing or leveraging existing processes, tools, and techniques in your cloud and desktop systems relieves the need to utilize increasingly scarce IBM zSystems expertise for the entire ETL process

Leverage Familiar Tools

Lozen leverages NSF to “mount” IBM zSystems VSAM and sequential files in the local filesystem of your Linux and Windows servers and desktops.

All applications and processes running on those systems will access those files with standard file Open/Read/Write/Close commands.  This can be as simple as a command line “copy” or an application “File…Open” to read the file.

For more advanced access, you can leverage the Lozen API or our support for popular data integration tools (such as MuleSoft) to read or write VSAM records by key or to start a keyed browse operation to read only a portion of the records.

Given this support on non-zSystems platforms, it is a simple and straightforward matter to minimize the tasks associated with extracting data on IBM zSystems, then copying the extract to another platform.  You can see that portions of your existing ETL processes can be augmented or replaced by your familiar non-zSystems server and desktop tools.

Strategic Replacement

If you have existing data in files that are being processed by applications in the cloud (or vice versa), you could also replace components of ETL with Lozen to streamline the data movement (the “Load” or “L” in “ETL”).

You can continue to use your ETL solution to extract the data from whatever source it is in and transform it, so it is in the format you want (the “Extract” and “Transform” part of “ETL”).  Or you can simply do the extract and let Lozen do the data transfer, code page (e.g. EBCDIC to ASCII), and data format transformation in a single step.

Reduce Costs

To the extent you leverage Lozen, you can also offload the processing for the “L” or the “TL” to a zIIP processor, rather than your general purpose processor.  This saves processing costs that are currently charged to your ETL process.


Lozen provides new flexibility, ease of use, and potential cost savings compared to existing ETL solutions.  By leaving the IBM zSystems data in place, while easily accessing it from non-zSystems platforms, you can reduce the load on your IBM zSystems processing, your IBM zSystems support, and your development personnel.

Visit our YouTube channel to watch a Lozen ETL demo and to watch our “Simplify Your ETL and Reduce Costs” webinar.

Learn More

To learn more about how to unlock the power of real-time, read-write
IBM zSystems data access with Lozen:

Latest Blog Posts

Introducing VirtualZ Consulting Services

Introducing VirtualZ Consulting Services

Many enterprises are modernizing their mainframe applications and are planning to take advantage of the latest innovations in AI.  It is estimated that over 70% of enterprise data resides on the mainframe, making that mainframe data crucial to modernizing applications...

Simplify Your Change Data Capture With Lozen

Simplify Your Change Data Capture With Lozen

If you were designing a brand-new data access solution for your organization today, Lozen™ could play a prominent role in creating a lower-cost, high-performance solution.  Because Lozen’s real-time, read-write approach lets you leave data where it is (securely on the...

Lozen OpenAPI Connector with Microsoft Azure Logic Apps

Lozen OpenAPI Connector with Microsoft Azure Logic Apps

Lozen™ offers several connectors to enable no-code, real-time, read-write mainframe data access to a broad range of applications.  Connectors are valuable extensions to Lozen, providing Lozen customers with simple and secure access to mainframe data from an increasing...