B2B-Data-Exchage
Robust Financial Data Exchange Solution with Informatica B2b Data Exchange
THE CUSTOMER
The customer, headquartered in Texas, is among the largest banking institutions in the US with over 130 branches and 1,300 automated teller machines (ATMs), offering a large portfolio of services including banking, financing, investment and insurance services to consumers and businesses.
The customer is at the forefront of electronic financial and banking services, offering its customers a complete online banking experience by deploying best-of-breed information technologies and design & implementation practices. Being at the forefront, a key advantage is to provide the most client friendly applications.
THE PROBLEM
The customer wanted to migrate from its GlobalPay third party application to an in-house developed application. The GlobalPay application had been implanted with yesterday’s technology and no longer met the client friendly requirements given the latest available technology.
Given the rapid pace at which enterprise software tools, development environments and technologies evolve, the customer wanted to bring development and maintenance in-house, so that its own IT department could easily maintain and extend the applications as needed, and thereby keep offering the most client friendly applications and keep adding increasingly more sophisticated financial services to its services offerings.
Core to its roadmap was the ability to exchange data between NACHA (National Automated Clearing House Association) and EDI-X12-4010 820 data formats. The IT department had selected the Informatica B2B Data Exchange product stack for the migration of the application, but ran into database connectivity issues with the Informatica B2B Data Exchange 10.2HF2 installer and consequently the risk of derailment of the roadmap became a big concern.
THE CHALLENGE
Possibly facing a host of other negative consequences next to roadmap derailment, the challenge was to debug and resolve the connectivity issues promptly. The customer’s IT department lacked the necessary expertise in debugging the database connection issues as well as experience in using the Informatica B2B Data Exchange product stack, since it had only recently started to use the stack.
THE SOLUTION
The customer brought in PartnerBO (Informatica Silver partner) because of its expertise in developing complex on-premise and cloud hybrid B2B data exchange solutions with Informatica products. We were able to quickly establish the cause of the problem to be a bug in the Informatica B2B Data Exchange DX 10.2HF2 installer and narrowed this further down with the Informatica technical support engineering team to failure when SSL encryption is enabled for Microsoft SQL Server 2016 databases running on Microsoft Windows Server 2016 platforms.
It was going to take a while for Informatica to resolve the bug, given that it occurred on an older version of Microsoft products. Since the IT department had a fixed timeline to accomplish their mission, we proposed to implement a workaround that would allow them to continue their development unimpeded, while at the same time keeping SSL encryption in place. This workaround involved deep knowledge of the files and settings involved with the DX 10.2HF2 installer.
Taking advantage of PartnerBO’s deep expertise with Informatica’s Data Integration product family including Cloud B2B Gateway, B2B Managed File Transfer, B2B Data Exchange, B2B Data Transformation (Data Processor), and PowerCenter, the IT department engaged our Informatica consultants to assist with the implementation of the NACHA/EDI-X12 data exchange module. This involved orchestration between Informatica PowerCenter, Data Transformation, and Managed File Transfer in the Informatica B2B Data Exchange product stack.
NACHA to EDI –X12 Transformation Using Data Transformation (Data Processor), Data Exchange and Managed File Transfer
THE RESULTS
Our workaround and implementation of the NACHA/EDI-X12 data exchange module worked flawlessly, which not only allowed the IT department to continue its application development, but significantly sped up their development timelines. As a result they were able to roll out the new application much ahead of schedule and continue to take full advantage of Informatica’s platform to implement new features and applications in-house.
CONCLUSIONS
We were able to quickly identify the cause of the database connectivity issues and promptly implement a workaround without compromising SSL security. In addition we implemented the NACHA/EDI-X12 data exchange core functionality for the customer in record time and transfer our knowledge on the use of the Informatica B2B Data Exchange product stack to the customer’s IT team. This enabled the IT team to maintain their tight deadlines for the GlobalPay application and continue to develop ever more sophisticated applications and services, core to their ability to grow their business.
___________________________________________________________________________________________________________________________________________
About PARTNERBO
PartnerBO is a data management and analytics System Integration & Solution hospital, transforming the way companies manage and leverage data. Through strong partnerships, innovative and purpose-built solutions, PartnerBO helps companies in their data integration journey. Informatica products PartnerBO provides consulting for are Informatica cloud (IICS), cloud b2b gateway, Informatica B2B managed file transfer, data exchange, Informatica B2B data transformation, Powercenter, & Informatica DIH.
At PartnerBO we support your growth through System & Data integration, focusing on increasing your strength from inside your organization. We help you empower yourself with new capabilities such as data quality, data management, cloud data integration, big data architecture, hospital-wide data quality governance, data security, and data archiving.
Our Intelligent Data Platforms are a powerful combination of metadata intelligence and artificial intelligence, fully integrated across all aspects of data management. PartnerBO helps you in your journey to leverage cloud, big data, data management, governance, archiving transformations, data asset monetization, and data-driven decisions, for your business growth goals.
A few of recent project and services provided to customer include:
Proactive monitoring for Informatica B2B Eco system: including Data exchange , managed file transfer and related powercenter monitoring. The system would continuously check for health, notify and fix issues automatically when detected.
End to end X12 Solution in the healthdomain for customer in need of migration to cloud communication with their customers, with managed file transfer, IICS CDI, and Data Transformation (aka DT/ DP).
Creation of multi node complex B2B Environment for a financial arena customer, with automated fail overs, automated patching and code deployment, scaling their IT operations to the next level.
Industrial analytics integration connecting factory machines to the cloud via TDM, BDM, IICS CAI with salesforce, reflecting operational analytics such as OEE Availability, performance and quality in tableau.
Visit us at www.partnerbo.co or contact us via email at sales@partnerbo.co
