spheregen logo on transparent background

Sunsetting Legacy Software 

frustrated coworkers looking at computer

As technology evolves, software products continue to improve in usability, accessibility, and performance. Eventually, companies must face the inevitable question – should I keep maintaining my current system, or plan to upgrade and update? This question is not easy to answer, as either option typically involves cost and inconvenience. However, there are downsides to continue … Read more

How Your Organization Can Benefit from FHIR Standardization

Old woman and elder senior using laptop.

Payers understand the need for interoperability and standardization in exchanging and managing healthcare data. Fast Healthcare Interoperability Resources (FHIR) is a recommended standard for exchanging healthcare information and represents a significant leap in interoperability. FHIR-standardized data makes it possible for providers to access and share information from different sources, improving patient outcomes. In this blog … Read more

How to Estimate the Cost of Software Development

people estimating software development

Updated on May 26, 2023 When a company or individual looks to estimate the cost of software development, inevitably questions like “How much?” and “How long?” are asked. Two questions define the constraints that most clients experience in project work – “Can I afford this?” and “Can it be done in time to meet my … Read more

Guidelines for Migrating Mirth to Azure

tablet and cloud services

Do you want to maximize your existing Mirth experience while utilizing all that Azure Cloud has to offer? Migrating to the Cloud is a great way to ensure maximum uptime and provide access to the benefits of machine learning and artificial intelligence technologies. This guide will lead you through the steps necessary to migrate to … Read more

The Benefits of Azure Cloud Migration in Healthcare

secure cloud

Managing digital data is critical for healthcare organizations, which has created a need for secure and efficient healthcare information exchange (HIE) platforms. Mirth is a solution that meets this need, allowing healthcare providers to share patient data safely. However, it is essential to transition Mirth to a cloud-based system to stay current with changing technologies. … Read more

Update Existing Windows File Share Subscriptions to Use Common File Share Account

laptop on desk with sql server screen

Microsoft has introduced a new feature called Use file share account in Microsoft SQL Server Reporting services starting with SQL Server 2016. This new feature gives the flexibility to use a common file share account for windows file share subscriptions. To enable this new feature in the SSRS file share subscription, first, you need to … Read more

Part 2 – Issues and Challenges After Migration of Microsoft SQL

spheregen logo with tagline

Reviewed for accuracy on January 23, 2023 In Part-1, SSRS migration steps have been discussed. Many congratulations for SSRS migration but migration journey is not yet over. SSRS migration opens door for new issue and challenges due to feature update but also it welcomes new feature that comes with newer version of SSRS. Below mentioned … Read more

HIVE_BAD_DATA: Error Parsing Field Value for Field ERROR in AWS Athena

spheregen logo with tagline

Reviewed for accuracy on January 23, 2023 HIVE_BAD_DATA is generally related to bad data in source file or data type mismatch. I have experienced this error while working with JSON data read in AWS Athena. For example, I have below sample JSON data that is stored in s3 bucket {“id”:”jggdfdysf866″,”socialdata”:{“facebook”:”Facebook data details”,”twitter”:””}} {“id”:”676fdggdcdf4″,”socialdata”:”This is bad … Read more

PART 1 – Migration of Microsoft SQL Server Reporting Services to New Server

laptop on desk with sql server screen

Reviewed for accuracy on January 23, 2023 One of our clients was using SSRS2008R2 (Native Mode) and they decided to upgrade to SSRS2017. There are two methods available that can fulfil this upgrade. One by using some scripting and another one by physically moving ReportServer database to the new server. Physically moving ReportServer database to … Read more