Click here to close now.

Welcome!

XML Authors: Pat Romanski, Carmen Gonzalez, Elizabeth White, VictorOps Blog, Hovhannes Avoyan

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
SYS-CON Events announced today that Liaison Technologies, a leading provider of data management and integration cloud services and solutions, 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. Liaison Technologies is a recognized market leader in providing cloud-enabled data integration and data management solutions to break down complex information barriers, enabling enterprises to make smarter decisions, faster.
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.
Participants will reach the final if their IoT solution is liked. A community vote will determine the best solutions submitted in each country, after which an expert jury will select the national winners and the best international IoT solution. Each country's best solution can win a national marketing campaign worth up to €30,000 and become a partner in Deutsche Telekom's participating markets. The winning international solution can become partner of Deutsche Telekom Group across all eight countries and reach out to a potential of 10,8 million business customers. Deutsche Telekom Group has a...
Recent technology advances in miniaturization has positioned the wearables as the pinnacle of technology convergence with the human body. We inquire if wearables are mere standard miniaturized devices extended with the connectivity and present our views on considerations like design, applications, performance, efficiency, interoperability, usage scenarios, human device interaction and consequent trade-offs enabling wearables to impart optimal value.
WebRTC Summit has announced today that Peter Dunkley has been named summit chair of WebRTC Summit 2015 New York. The 4th International WebRTC Summit will take place on June 9-11, 2015, at the Javits Center in Manhattan, New York. @ThingsExpo anticipates 90% of WebRTC companies & developers will monetize their products & services through IoT by 2016. Peter Dunkley is Technical Director at Acision. He graduated from The University of Edinburgh in 2000 with a BSc (Hons) in Computer Science. After graduation Peter worked on a PSTN switch developing signalling stacks for SS7, ISDN and simi...
In this session we look at creating interactive communications via the web by adding messaging, file transfer, and group communication (group chat and audio/video conferencing) into the web experience. We will also discuss potential applications of this technology in areas including B2B, B2C, P2P, and gaming. Peter is Technical Director at Acision. He graduated from The University of Edinburgh in 2000 with a BSc (Hons) in Computer Science. After graduation Peter worked on a PSTN switch developing signalling stacks for SS7, ISDN and similar protocols and creating advanced routing and serv...
SYS-CON Events announced today that ProfitBricks, the provider of painless cloud infrastructure, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY., and the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. ProfitBricks is the IaaS provider that offers a painless cloud experience for all IT users, with no learning curve. ProfitBricks boasts flexible cloud servers and networking, an integrated Data Center Designer tool f...
SYS-CON Events announced today that kintone has been named “Bronze 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 City, NY, and the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. kintone promotes cloud-based workgroup productivity, transparency and profitability with a seamless collaboration space, build your own business application (BYOA) platform, and workflow automation system.
SYS-CON Events announced today that Dyn, the worldwide leader in Internet Performance, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. Dyn is a cloud-based Internet Performance company. Dyn helps companies monitor, control, and optimize online infrastructure for an exceptional end-user experience. Through a world-class network and unrivaled, objective intelligence into Internet conditions, Dyn ensures traffic gets delivered faster, safer, and more reliably than ever.
SYS-CON Events announced today that Open Data Centers (ODC), a carrier-neutral colocation provider, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place June 9-11, 2015, at the Javits Center in New York City, NY. Open Data Centers is a carrier-neutral data center operator in New Jersey and New York City offering alternative connectivity options for carriers, service providers and enterprise customers.
SYS-CON Events announced today that On the Avenue Marketing Group, a sales and marketing firm that utilizes events to market and sell products to consumers, will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. On the Avenue Marketing Group (OTA) is a sales and marketing firm that utilizes events to market and sell products to consumers. On behalf of our clients, we attend thousands of fairs, festivals, expos, concerts, conferences, and sporting events annually, helping them reach millions of individuals ...
SYS-CON Events announced today that ActiveState, the leading independent Cloud Foundry and Docker-based PaaS provider, has been named “Silver Sponsor” of SYS-CON's DevOps Summit New York, which will take place June 9-11, 2015, at the Javits Center in New York City, NY. ActiveState believes that enterprises gain a competitive advantage when they are able to quickly create, deploy and efficiently manage software solutions that immediately create business value, but they face many challenges that prevent them from doing so. The Company is uniquely positioned to help address these challenges thro...
SYS-CON Events announced today that Vitria Technology, Inc. will exhibit at SYS-CON’s @ThingsExpo, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. Vitria will showcase the company’s new IoT Analytics Platform through live demonstrations at booth #330. Vitria’s IoT Analytics Platform, fully integrated and powered by an operational intelligence engine, enables customers to rapidly build and operationalize advanced analytics to deliver timely business outcomes for use cases across the industrial, enterprise, and consumer segments.
SYS-CON Events announced today that Alert Logic, the leading provider of Security-as-a-Service solutions for the cloud, has been named “Bronze Sponsor” of SYS-CON's 16th International Cloud Expo® and DevOps Summit 2015 New York, which will take place June 9-11, 2015, at the Javits Center in New York City, NY, and the 17th International Cloud Expo® and DevOps Summit 2015 Silicon Valley, which will take place November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA.
The WebRTC Summit 2015 New York, to be held June 9-11, 2015, at the Javits Center in New York, NY, announces that its Call for Papers is open. Topics include all aspects of improving IT delivery by eliminating waste through automated business models leveraging cloud technologies. WebRTC Summit is co-located with 16th International Cloud Expo, @ThingsExpo, Big Data Expo, and DevOps Summit.
SYS-CON Events announced today that Akana, formerly SOA Software, has been named “Bronze Sponsor” of SYS-CON's 16th International Cloud Expo® New York, which will take place June 9-11, 2015, at the Javits Center in New York City, NY. Akana’s comprehensive suite of API Management, API Security, Integrated SOA Governance, and Cloud Integration solutions helps businesses accelerate digital transformation by securely extending their reach across multiple channels – mobile, cloud and Internet of Things. Akana enables enterprises to share data as APIs, connect and integrate applications, drive part...
SYS-CON Events announced today that CommVault has been named “Bronze 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 City, NY, and the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. A singular vision – a belief in a better way to address current and future data management needs – guides CommVault in the development of Singular Information Management® solutions for high-performance data protection, universal availability and sim...
SYS-CON Events announced today that SafeLogic has been named “Bag Sponsor” of SYS-CON's 16th International Cloud Expo® New York, which will take place June 9-11, 2015, at the Javits Center in New York City, NY. SafeLogic provides security products for applications in mobile and server/appliance environments. SafeLogic’s flagship product CryptoComply is a FIPS 140-2 validated cryptographic engine designed to secure data on servers, workstations, appliances, mobile devices, and in the Cloud.
BroadSoft on Tuesday announced that it is a recipient of the 2014 Frost & Sullivan Market Leadership Award in the Hosted/Cloud Internet Protocol (IP) Telephony market for Latin America. According to Frost & Sullivan market research, the Latin America (LATAM) hosted/cloud Internet Protocol (IP) telephony market, including integrated unified communications and collaboration (UC&C) applications, is currently experiencing a rapid growth trajectory and is expected to exhibit a tenfold rise in annual revenues in the 2013-2020 period. With more than 600 cloud deployments internationally, BroadSoft w...
SYS-CON Events announced today that StorPool Storage will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. StorPool is distributed storage software that allows service providers, enterprises and other cloud builders to run data storage on standard x86 servers, instead of using expensive and inefficient storage arrays (SAN).