Welcome!

XML Authors: Carmen Gonzalez, Liz McMillan, Ignacio M. Llorente, David Dossot, Yeshim Deniz

Related Topics: XML

XML: 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.

@ThingsExpo Stories
The Internet of Things will greatly expand the opportunities for data collection and new business models driven off of that data. In her session at @ThingsExpo, Esmeralda Swartz, CMO of MetraTech, discussed how for this to be effective you not only need to have infrastructure and operational models capable of utilizing this new phenomenon, but increasingly service providers will need to convince a skeptical public to participate. Get ready to show them the money!
The Internet of Things will put IT to its ultimate test by creating infinite new opportunities to digitize products and services, generate and analyze new data to improve customer satisfaction, and discover new ways to gain a competitive advantage across nearly every industry. In order to help corporate business units to capitalize on the rapidly evolving IoT opportunities, IT must stand up to a new set of challenges. In his session at @ThingsExpo, Jeff Kaplan, Managing Director of THINKstrategies, will examine why IT must finally fulfill its role in support of its SBUs or face a new round of...
One of the biggest challenges when developing connected devices is identifying user value and delivering it through successful user experiences. In his session at Internet of @ThingsExpo, Mike Kuniavsky, Principal Scientist, Innovation Services at PARC, described an IoT-specific approach to user experience design that combines approaches from interaction design, industrial design and service design to create experiences that go beyond simple connected gadgets to create lasting, multi-device experiences grounded in people's real needs and desires.
Enthusiasm for the Internet of Things has reached an all-time high. In 2013 alone, venture capitalists spent more than $1 billion dollars investing in the IoT space. With "smart" appliances and devices, IoT covers wearable smart devices, cloud services to hardware companies. Nest, a Google company, detects temperatures inside homes and automatically adjusts it by tracking its user's habit. These technologies are quickly developing and with it come challenges such as bridging infrastructure gaps, abiding by privacy concerns and making the concept a reality. These challenges can't be addressed w...
The Domain Name Service (DNS) is one of the most important components in networking infrastructure, enabling users and services to access applications by translating URLs (names) into IP addresses (numbers). Because every icon and URL and all embedded content on a website requires a DNS lookup loading complex sites necessitates hundreds of DNS queries. In addition, as more internet-enabled ‘Things' get connected, people will rely on DNS to name and find their fridges, toasters and toilets. According to a recent IDG Research Services Survey this rate of traffic will only grow. What's driving t...
Scott Jenson leads a project called The Physical Web within the Chrome team at Google. Project members are working to take the scalability and openness of the web and use it to talk to the exponentially exploding range of smart devices. Nearly every company today working on the IoT comes up with the same basic solution: use my server and you'll be fine. But if we really believe there will be trillions of these devices, that just can't scale. We need a system that is open a scalable and by using the URL as a basic building block, we open this up and get the same resilience that the web enjoys.
Connected devices and the Internet of Things are getting significant momentum in 2014. In his session at Internet of @ThingsExpo, Jim Hunter, Chief Scientist & Technology Evangelist at Greenwave Systems, examined three key elements that together will drive mass adoption of the IoT before the end of 2015. The first element is the recent advent of robust open source protocols (like AllJoyn and WebRTC) that facilitate M2M communication. The second is broad availability of flexible, cost-effective storage designed to handle the massive surge in back-end data in a world where timely analytics is e...
We are reaching the end of the beginning with WebRTC, and real systems using this technology have begun to appear. One challenge that faces every WebRTC deployment (in some form or another) is identity management. For example, if you have an existing service – possibly built on a variety of different PaaS/SaaS offerings – and you want to add real-time communications you are faced with a challenge relating to user management, authentication, authorization, and validation. Service providers will want to use their existing identities, but these will have credentials already that are (hopefully) i...
"Matrix is an ambitious open standard and implementation that's set up to break down the fragmentation problems that exist in IP messaging and VoIP communication," explained John Woolf, Technical Evangelist at Matrix, in this SYS-CON.tv interview at @ThingsExpo, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
How do APIs and IoT relate? The answer is not as simple as merely adding an API on top of a dumb device, but rather about understanding the architectural patterns for implementing an IoT fabric. There are typically two or three trends: Exposing the device to a management framework Exposing that management framework to a business centric logic Exposing that business layer and data to end users. This last trend is the IoT stack, which involves a new shift in the separation of what stuff happens, where data lives and where the interface lies. For instance, it's a mix of architectural styles ...
Cultural, regulatory, environmental, political and economic (CREPE) conditions over the past decade are creating cross-industry solution spaces that require processes and technologies from both the Internet of Things (IoT), and Data Management and Analytics (DMA). These solution spaces are evolving into Sensor Analytics Ecosystems (SAE) that represent significant new opportunities for organizations of all types. Public Utilities throughout the world, providing electricity, natural gas and water, are pursuing SmartGrid initiatives that represent one of the more mature examples of SAE. We have s...
P2P RTC will impact the landscape of communications, shifting from traditional telephony style communications models to OTT (Over-The-Top) cloud assisted & PaaS (Platform as a Service) communication services. The P2P shift will impact many areas of our lives, from mobile communication, human interactive web services, RTC and telephony infrastructure, user federation, security and privacy implications, business costs, and scalability. In his session at @ThingsExpo, Robin Raymond, Chief Architect at Hookflash, will walk through the shifting landscape of traditional telephone and voice services ...
The Internet of Things is tied together with a thin strand that is known as time. Coincidentally, at the core of nearly all data analytics is a timestamp. When working with time series data there are a few core principles that everyone should consider, especially across datasets where time is the common boundary. In his session at Internet of @ThingsExpo, Jim Scott, Director of Enterprise Strategy & Architecture at MapR Technologies, discussed single-value, geo-spatial, and log time series data. By focusing on enterprise applications and the data center, he will use OpenTSDB as an example t...
Explosive growth in connected devices. Enormous amounts of data for collection and analysis. Critical use of data for split-second decision making and actionable information. All three are factors in making the Internet of Things a reality. Yet, any one factor would have an IT organization pondering its infrastructure strategy. How should your organization enhance its IT framework to enable an Internet of Things implementation? In his session at Internet of @ThingsExpo, James Kirkland, Chief Architect for the Internet of Things and Intelligent Systems at Red Hat, described how to revolutioniz...
Bit6 today issued a challenge to the technology community implementing Web Real Time Communication (WebRTC). To leap beyond WebRTC’s significant limitations and fully leverage its underlying value to accelerate innovation, application developers need to consider the entire communications ecosystem.
The definition of IoT is not new, in fact it’s been around for over a decade. What has changed is the public's awareness that the technology we use on a daily basis has caught up on the vision of an always on, always connected world. If you look into the details of what comprises the IoT, you’ll see that it includes everything from cloud computing, Big Data analytics, “Things,” Web communication, applications, network, storage, etc. It is essentially including everything connected online from hardware to software, or as we like to say, it’s an Internet of many different things. The difference ...
Cloud Expo 2014 TV commercials will feature @ThingsExpo, which was launched in June, 2014 at New York City's Javits Center as the largest 'Internet of Things' event in the world.
SYS-CON Events announced today that Windstream, a leading provider of advanced network and cloud communications, has been named “Silver Sponsor” of SYS-CON's 16th International Cloud Expo®, which will take place on June 9–11, 2015, at the Javits Center in New York, NY. Windstream (Nasdaq: WIN), a FORTUNE 500 and S&P 500 company, is a leading provider of advanced network communications, including cloud computing and managed services, to businesses nationwide. The company also offers broadband, phone and digital TV services to consumers primarily in rural areas.
"There is a natural synchronization between the business models, the IoT is there to support ,” explained Brendan O'Brien, Co-founder and Chief Architect of Aria Systems, in this SYS-CON.tv interview at the 15th International Cloud Expo®, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
The major cloud platforms defy a simple, side-by-side analysis. Each of the major IaaS public-cloud platforms offers their own unique strengths and functionality. Options for on-site private cloud are diverse as well, and must be designed and deployed while taking existing legacy architecture and infrastructure into account. Then the reality is that most enterprises are embarking on a hybrid cloud strategy and programs. In this Power Panel at 15th Cloud Expo (http://www.CloudComputingExpo.com), moderated by Ashar Baig, Research Director, Cloud, at Gigaom Research, Nate Gordon, Director of T...