Welcome!

Industrial IoT Authors: Elizabeth White, Stackify Blog, Yeshim Deniz, SmartBear Blog, Liz McMillan

Related Topics: Industrial IoT

Industrial IoT: Case Study

Secure File Transfer Saves Taxpayer Dollars in the State of Maryland

Adaptable Enterprise Solution with Role-based Access, XML translation and native IBM i Support

The IT Department philosophy at the Department of Labor, Licensing and Regulation for the State of Maryland is “Keep Infrastructure Simple and Easy to Manage.” This in mind, adapting to new state and federal requirements without reinventing the wheel or adding additional taxpayer cost is a constant challenge. GoAnywhere Director delivers at every turn for the State of Maryland’s Department of Labor, Licensing and Regulation (DLLR).

The Challenge
The main challenge for DLLR was transferring sensitive data in a secure and reliable fashion. In addition, each DLLR “trading partner” required different file formats such as fixed width, Excel, CSV or the increasingly popular XML format.

It was becoming very difficult to immediately develop and implement an efficient and reliable process for the growing number of new daily tasks. Manually handling these multiple file transfers left little time for training staff on new software and procedures. The evident need for an automated and secure managed file transfer solution came around the same time as a new Maryland State law. The new law would require DLLR Mortgage Lending licensees to register with a central federal agency. This new, high-visibility requirement was already on top of the many unique information transfer requests for other private entities and public agencies.

The Playing Field
Before the installation of GoAnywhere Director, DLLR developers manually downloaded and uploaded the Excel, CSV or fixed formatted files between the IBM i and their desktop computers. Performing these manual tasks across different PC’s and various platforms consumed DLLR IT staff time when they could be focused on other productive development tasks.

In addition, there were no central tracking or logging mechanisms recording completed requests, if a recipient received a file, or if a developer even sent the correct file. Attempts to go back and determine the source of an error were next to impossible.

Adding a New Player
Like many offices, adding more people was not a solution and neither was buying more hardware. The IBM i mid-range servers were more than capable of handling the traffic and the DB2 database could easily store the data. Using ad-hoc processes and placing additional tasks on each developer was not going to keep up with the increasing workload. The DLLR needed a solution that would accomplish their goals:

  • User-friendly solution capable of secure managed file transfers that does not require learning the small details surrounding file transfer protocols like SFTP, FTPS and FTP with PGP
  • An automated and secure file transfer solution that will run 100% natively on the IBM i without the need for other hardware and works with nightly backups
  • Easy data translation between the backend DB2 database and files formatted in fixed length, Excel, CSV or XML
  • Audit capability and proof of delivery for sensitive data
  • Secure online User access
  • Centralized job monitoring and logging
  • Good online and telephone support

The Relief Pitcher
Of the options on the market, GoAnywhere Director met all the DLLR’s requirements. GoAnywhere Director was easy and straightforward to implement and use. The ability to securely automate their processes natively from the IBM i allowed the development staff to return their focus to their regular development tasks.

GoAnywhere Director was selected over other products because, it could restart failed transfers and it easily ‘sliced & diced’ data between DLLR’s backend DB2 database and the many file formats used by DLLR’s trading partners; especially XML formatted files. GoAnywhere Director has increased DLLR’s productivity.

A Curve Ball
Adaptability in an enterprise class application is not always expected. Pursuant to requirements under a federal law passed in 2008 and conforming Maryland legislation passed in 2009, Maryland uses the Nationwide Mortgage Licensing System (NMLS), a web-based system, that allows state licensed mortgage companies and loan officers to apply for, amend, update or renew a license online for all participating state agencies using a single set of uniform applications. All mortgage licensees would now submit license applications and/or registrations to NMLS on a daily basis. The new requirements stipulated vast amounts of time-sensitive licensing data be sent securely in XML format. Required to comply with new laws and regulations, many organizations scrambled to meet these requirements. With just a few clicks and defining some GoAnywhere Director settings, the new data transmission requirements were not an issue for DLLR.

Back at the Clubhouse
GoAnywhere Director
continues to perform for the DLLR. The ease of use and flexibility of the application to perform so many tasks continues to provide greater return on their investment. “Not only does GoAnywhere automate the data translation and transfers,” smiles Joe, “it monitors itself and sends email notifications after each complete or failed transfer; not only to our development staff, but to our internal customers and trading partners. This confirmation gives everyone confidence that our business tasks are running flawlessly.”

More Stories By Dirk Zwart

Born in Canada and calling Nebraska home, Dirk primarily writes on the Technical side of the IT realm. Having written for years at Gateway Computer and as part of other large IT organizations, Dirk happily writes for Linoma Software. When not writing children's stories or stage scripts, you'll find Dirk out back in the vegetable garden or building yet another server for reasons unknown. Follow Dirk on Twitter, Facebook, or LinkedIn.

IoT & Smart Cities Stories
The deluge of IoT sensor data collected from connected devices and the powerful AI required to make that data actionable are giving rise to a hybrid ecosystem in which cloud, on-prem and edge processes become interweaved. Attendees will learn how emerging composable infrastructure solutions deliver the adaptive architecture needed to manage this new data reality. Machine learning algorithms can better anticipate data storms and automate resources to support surges, including fully scalable GPU-c...
A valuable conference experience generates new contacts, sales leads, potential strategic partners and potential investors; helps gather competitive intelligence and even provides inspiration for new products and services. Conference Guru works with conference organizers to pass great deals to great conferences, helping you discover new conferences and increase your return on investment.
Poor data quality and analytics drive down business value. In fact, Gartner estimated that the average financial impact of poor data quality on organizations is $9.7 million per year. But bad data is much more than a cost center. By eroding trust in information, analytics and the business decisions based on these, it is a serious impediment to digital transformation.
SYS-CON Events announced today that Silicon India has been named “Media Sponsor” of SYS-CON's 21st International Cloud Expo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Published in Silicon Valley, Silicon India magazine is the premiere platform for CIOs to discuss their innovative enterprise solutions and allows IT vendors to learn about new solutions that can help grow their business.
We are seeing a major migration of enterprises applications to the cloud. As cloud and business use of real time applications accelerate, legacy networks are no longer able to architecturally support cloud adoption and deliver the performance and security required by highly distributed enterprises. These outdated solutions have become more costly and complicated to implement, install, manage, and maintain.SD-WAN offers unlimited capabilities for accessing the benefits of the cloud and Internet. ...
Founded in 2000, Chetu Inc. is a global provider of customized software development solutions and IT staff augmentation services for software technology providers. By providing clients with unparalleled niche technology expertise and industry experience, Chetu has become the premiere long-term, back-end software development partner for start-ups, SMBs, and Fortune 500 companies. Chetu is headquartered in Plantation, Florida, with thirteen offices throughout the U.S. and abroad.
SYS-CON Events announced today that CrowdReviews.com has been named “Media Sponsor” of SYS-CON's 22nd International Cloud Expo, which will take place on June 5–7, 2018, at the Javits Center in New York City, NY. CrowdReviews.com is a transparent online platform for determining which products and services are the best based on the opinion of the crowd. The crowd consists of Internet users that have experienced products and services first-hand and have an interest in letting other potential buye...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. IoT Now explores the evolving opportunities and challenges facing CSPs, and it passes on some lessons learned from those who have taken the first steps in next-gen IoT services.
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...