SQL Server Integration Service (SSIS) : SSIS is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating, merging data, etc. It makes it […]
Posts Tagged ‘XML’
Episerver – Handling an SVG image type and displaying it using a Path tag
Recently, I came across a requirement from a client that needed all SVG media types to render using the internal XML <Path> in the DOM, rather than using the standard <Img> tag. This was a tricky one and there wasn’t very much information about how to accomplish this, as its not necessarily a common request. […]
Update Member Relationship in OneStream XF
In my previous blog post, I demonstrated how members meeting the appropriate criteria could be deleted from an OneStream XF application with a XML file. In this blog, I will demonstrate how a member relationship “parent / child” can be deleted and more importantly changed using a XML file which is a necessary part of […]
Mass Delete Members in OneStream XF
During one of my previous projects, we needed to delete approximately 200 accounts that were distributed throughout a large Account dimension. This blog discusses how we solved it. One approach would have been to delete each account one time. Obviously, that wasn’t appealing as it is time-consuming and can be prone to error. Another approach […]
Maximo Hover Dialogs – How to Modify Fields
As clients look to extend and refine the use of Maximo, one of the useful newer tools is the Maximo hover dialog information. They are not difficult to modify and can give you a quick way to view the items that are important to your business. To get started, we will first take a look […]
An Easy Way to Write HL7(TDS) Messages in XML Format in IIB
The Perficient project lead handling an Enterprise Integration project at one of the largest healthcare providers in the country called me one afternoon and asked me to find a quick solution to write HL7 messages in XML format as some vendors that were being integrated needed the messages in XML. I knew that the solution […]
Creating XML Files Using Hierarchical Stage in IBM Datastage
XML files, being the most popular way for data transportation, could be the most sought ought way by many clients for moving the data around. Hence, it becomes inevitable for one to know how to create/parse/transform XML files in an ETL tool like IBM datastage. In this blog, we will look at how we could […]
Solving Transformation and Routing of an EDI 837 Health Claim
Health Level Seven International (HL7) is a not-for-profit, ANSI-accredited standard-developing organization dedicated to providing a comprehensive framework and related standards for the exchange, integration, sharing, and retrieval of electronic health information that supports clinical practice and the management, delivery, and evaluation of health services. We use these standards to communicate and exchange information at the […]
Integrating Datapower XI 52 with Operational Decision Manager
In recent times, the need to follow government regulations and identify fraud to avoid financial loss as become more prominent. This forced companies in financial and health care domains to implement stricter business processes. The need to adapt and build better business process requires to use Business Rules Management System (BRMS) which will allow to […]
DataPower’s handling of RESTful services via JSON
In the IBM DataPower world, JSON is the representational format used by the RESTful façade exposed by the appliance. Starting with firmware version 3.8, there has been a gradual increase in the number of ways that JSON payload is handled. DataPower services that will handle and process JSON messages include: Multi-Protocol Gateway (MPGW) XML Firewall Web […]
DataPower Configuration Management tool
DCM (DataPower Configuration Manager) is an open source tool published by IBM for automating and simplifying the configuration and management of IBM DataPower appliances (with the exception of the XC10). It can be used standalone OR within IBM UrbanCode Deploy platform. Business partners, clients or anyone else for that matter can contribute enhancement or fixes […]
Automating REST services using Soap UI Pro
“A Web service is a method of communication between two electronic devices over a network. It is a software system designed to support interoperable machine-to-machine interaction over a network.” There are various tools available to test web services. Some of them are Soap UI, Soap UI Pro, Test Maker, Web Inject etc. The most common tool we use is Soap UI. Soap-UI […]