SphereGen Admin

Author Archives

  • Oracle Roles and Uses

    Administration of large numbers of objects is difficult. Oracle roles allow you to localize the administration of objects. Oracle roles are most helpful when large numbers of users will need the same system and object privileges. Think of an Oracle role like a database user that nobody uses. You create the Oracle role using the […]

  • Data Modelling using SQL Developer Data Modeler

    Overview:-> Data modeling is a process used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations. Therefore, the process of data modeling involves professional data modelers working closely with business stakeholders, as well as potential users of the information system. Why is Data Modeling Important? Data modeling is probably […]

  • Power BI

    With the explosion of data in last few years, organizations want to analyze their data from different perspectives and want to understand their scattered data with meaningful information in lesser time. To address that, business analysts require new trends and analytical approach that can help them in effective decision making. Due to this, the importance […]

  • Persisting Mockup Edits using the ContentEditable attribute and CouchDB

    At SphereGen we aim to be always responsive to your needs as a client. One of the areas where your feedback is critical is in the area of UI mockups. Many a times you would like to change the text or the labels on the UI.  We want to capture this feedback asap and implement […]

  • Custom Web Service Connections from Mirth Connect

    Mirth Connect is the Swiss Army knife of open source integration engines with specific Healthcare support for HL7 message integration. Mirth has out of the box connectors for FTP, HTTP (GET/POST), JMS, SMTP, LLP and Web Services but if the out of the box capabilities is not sufficient, we can use the “JavaScript Writer” destination to create our own custom connector.

    In the open source version of Mirth Connect, there is no support for secure HTTPS. This is available from Mirth in their commercial offering but in this blog entry, I’m going to take you through using the JavaScript writer destination to create our own simple HTTPS sender.

  • Parsing Continuity of Care (CCD) using Mirth and MDHT

    Mirth Connect is the Swiss Army knife of open source integration engines with specific Healthcare support for HL7 message integration. A Continuity of Care (CCD) Document is an XML file containing a patient summary clinical document. Mirth has support for CCD and CDA documents in their commercial offering but you can also use the open source Model Driven Health Tools library from the Open Health Tools project for free if you have some time and patience.

    In this blog entry, I’m going to take you through the process to integrate the MDHT libraries into an existing Mirth Connect installation and then create a very simple channel to parse a CCD document and extract information from it. Specifically, we will:

    • Download and install the MDHT Run-time JARS
    • Configure and add code to a channel in Mirth to load the content of a CCD document
    • Extract fields from the CCD document and populate the channel variables map
  • Mirth Connect with Microsoft Azure Queue Storage

    Mirth Connect is the Swiss Army knife of open source integration engines with specific Healthcare support for HL7 message integration (though it works just as well when dealing with many types of data formats outside of HL7). Windows Azure enables you to build, deploy, scale and manage applications across a global network of Microsoft-managed data centers.

    Mirth Connect uses the concept of channels and queues to ingest, filter, transform and send messages from one system to another. It has built in support for many protocols such as file systems, FTP sites, databases and web services. In this blog post I’m going to demonstrate how we can extend the built-in capabilities to use Mirth Connect to send messages directly to a Windows Azure Queue:

    Windows Azure Queue storage is a service for storing large numbers of messages that can be accessed from anywhere in the world via authenticated calls using HTTP or HTTPS. A single queue message can be up to 64KB in size, a queue can contain millions of messages, up to the 100TB total capacity limit of a storage account.

    By pairing an on-premise or cloud hosted the instance of Mirth Connect with Azure queues we are able to scale by having one or more instances (or channels within an instance) of Mirth Connect pushing messages to the queue while having an independent number of queue consumers receiving messages and performing business activities on them. We are also able to eliminate a single point of constraint and failure providing greater resiliency.

  • Competencies Based Interviews

    Introduction: The recruitment process has always been the most critical aspect for the growth of any engineering or non-engineering industry. A good and efficient resource can help the organization to set and achieve high growth whereas the vice-versa is also not false. With augmenting demand of deserving candidates in companies, the interview process has also […]

  • Enterprise Java Flex Applications – Architectural Approaches

    Rich internet application is becoming the new face of web based enterprise applications and flex is coming up as a unanimous choice in this category. In this article, I presented few architectural approaches to use flex in Java environment to develop web based enterprise solutions. Also, I tried to capture few advantages and challenges involved […]

  • 10 effective ways to become a good programmer

    A good programmer is someone who always looks both ways before crossing a one-way street.  ~Doug Linder Working as a software programmer in IT industry, one thing that drives us daily to the work place; is that fun and passion lies in programming. But to make that programming a fun and to get an eternal […]

  • Cloud Computing and Software-as-a-Service (SaaS)

    Introduction Around the year 1960, after successfully installed the 1st packet switching based network (ARPANET), Sir J.C. R. Licklider envisioned the concept of ‘Intergalactic Computer Network’ where he talked about a complex net which connects all computers in the world and encircled the globe. This was the first vision of global net. In the same […]

  • Hibernate inverse attribute – Insight

    After exploring many articles and notes on ‘inverse’ attribute used in Hibernate, I realized that, although the attribute is simple to understand, the explanation, most of the times, is more complicated and ambiguous. So, I decided to give one more try to put simple words and examples to explain it. Hibernate supports bi-directional relationships in […]

  • Windows Azure

    Windows Azure Whether application runs on a local system, or over the Internet (commonly referred to as cloud), or both, some kind of application platform is required. An application platform can be thought of as anything that provides developer-accessible services for creating applications. Microsoft’s Windows Azure platform (originally known as the Azure Services Platform) is […]

  • Platform as a service

    Platform as a service In the recent years, we have been hearing a lot about Service Oriented Architecture. It started with Software as a Service (SaaS), where companies provided the applications in form of services over the internet instead of desktop applications. With this, it was not required to install the application on a system […]

  • USB Pot Luck?

    As we travel more and more, we increasingly use USB based devices to add functionality to our laptops or other devices.  In the course of traveling to our office in Pune, India, I decided to bring along a variety of devices.  This included a Casio camera, a Motorola Slvr, a WD Passport Essential, a WD […]