m-Power Gains New ETL Capabilities

July 8, 2014 Alex Woodie

The m-Power development tool from mrc is gaining new extract, transform, and load (ETL) features with the goal of giving customers better business intelligence capabilities.

Despite the growth of “big data” and the accelerating pace of development of big data solutions, nothing so far has replaced good old ETL when it comes to moving data from transactional systems into data warehouses for analysis. In fact, if anything, the need for ETL has increased due to the ever-growing volumes of data organizations are tasked with managing.

The folks at mrc are looking to give their customers a leg up on ETL functionality with the July release of m-Power, its Java-based development tool for creating Web-based apps that run on IBM i and other platforms.

The new ETL functionality in m-Power allows customers to pull data from multiple databases, transforms it into the necessary format, and then loads it into a centralized data warehouse. Once the data has landed, users can leverage m-Power’s existing functionality to create BI applications, such as reports and dashboards, over that data.

The Chicago-based company says the new ETL enhancement will be particularly useful for companies that are struggling with moving data between on-premise and cloud-based applications. It will also help companies that adhere to regulations mandating the long-term storage of certain types of data.

“As businesses use an ever-increasing number of data sources, data integration and reporting becomes more complex,” Tyler Wassell, mrc’s manager of software development, says in a press release. “This new enhancement gives m-Power users a simple method for integrating data and creating reports over disparate sources.”

Sponsored By
LINOMA SOFTWARE

You can win the battle to meet data security compliance requirements!

When it comes to your current FTP processes:

        • Have you wondered if there's a more automated, cost-effective way to exchange
           data that keeps HIPAA, PCI DSS, GLBA and SOX compliance auditors happy?
        • Are you looking for a better way to protect sensitive files from a data breach?
        • Would you like to streamline your processes, and thus give your programmers
           more time for other projects?

GoAnywhere, Linoma Software's managed file transfer software suite, solves all of these challenges and more. With GoAnywhere, your organization can secure, automate, and encrypt the data transfers with your trading partners, customers, vendors, employees and internal systems. It supports multiple platforms and all popular protocols, including FTP/S, SFTP, HTTP/S, AS2, SCP, and more.

The GoAnywhere managed file transfer suite, with an optional NIST-certified FIPS 140-2 encryption module, is comprised of three products: GoAnywhere Director, GoAnywhere Services and GoAnywhere Gateway.

GoAnywhere Director automates and secures file transfers using a centralized approach with a single point of control. It can connect to almost any system (internal or external) using standard protocols. GoAnywhere Director can also encrypt and compress files using popular Open PGP encryption, GPG, ZIP, GZIP and TAR standards.

GoAnywhere Services is a secure FTP server (and optional web server) that allows trading partners and employees to connect to your system and exchange files in a secure environment. As an on-premise solution, it includes SFTP, FTPS, and FTP servers with extensive management controls and audit log reporting. A secure HTTPS server can also be enabled for performing ad-hoc file transfers through an intuitive browser-based interface or through its Secure Mail module that includes a plugin for Outlook 2010.

GoAnywhere Gateway is both a reverse proxy and forward proxy, providing an additional layer of network security when exchanging data with your trading partners. By placing GoAnywhere Gateway in your DMZ (public network segment), your sensitive data and servers will remain safely protected in your private network. Its enhanced reverse proxy service does not require inbound ports to be opened into your private network which is essential for compliance with PCI DSS and strict security policies. In addition, it can work with GoAnywhere Services for load balancing to help provide increased capacity by sharing the workload among servers.

GoAnywhere can be installed onto IBM System i, IBM System p (AIX), IBM System (Mainframe), Windows, Linux, UNIX, HP-UX, Mac OS and Solaris platforms.

Take a brief video tour of Linoma Software's GoAnywhere MFT solution,
watch our customer success stories,
or visit our website at www.GoAnywhere.com

IT Does Its Part For U.S. Job Growth In June The Geezer’s Guide To Free-Form RPG, Part 4: Prototypes and Procedure Interfaces

Table of Contents

Recent Posts

Subscribe

Pages

Search