by Vivek Agarwal | Sep 26, 2023 | AWS, Blog, Cloud, Data Management
Navigating the world of data engineering tools can often be a complex undertaking. Deciding when to use one solution over another, such as Amazon EMR versus AWS Glue, often hinges on careful consideration and understanding of these services’ specific features...
by Vamsi Gumma | Apr 25, 2023 | Azure, Blog, Cloud, Data Management, Microsoft
Capturing changes from the data sources for implementing an incremental data load is a common requirement in data engineering pipelines. One of the cool features of Azure Data Factory is CDC (Change Data Capture). This can be implemented using various options...
by XTIVIA | Aug 11, 2020 | Blog, Data Management
The field of data privacy is getting another installation of data protection laws with the introduction of Brazil’s General Law for the Protection of Personal Data — in Portuguese, Lei Geral de Proteção de Dados (LGPD), Law No. 13.709/2018. The LGPD follows...
by XTIVIA | Jan 31, 2020 | Applications, Blog, Data Management
Islands of automation are no stranger to the modern enterprise. The ever-expanding nature of IT infrastructure is introducing new technologies and architectural paradigms, often antiquating critical solution platforms, thereby creating a disconnect between business...
by XTIVIA | Sep 3, 2019 | Blog, Data Management
Organizations are trying to “organize” the flood of data in their ecosystems when they should be voracious consumers of information and demanding a ubiquitous flow of data. Companies who can capitalize on the untapped potential of pervasive data are...
by XTIVIA | Aug 29, 2019 | Blog, Data Management
Overview of Data Quality It is an undeniable fact that corporations and individuals today are heavily dependent on data since decisions based on the data are proven to be more successful. Organizations are investing in improving the quality of their data. Here are...
by Abdul Wahab Khan | Jul 30, 2019 | Blog, Data Management
Data Modeling Overview Data Modeling is the process of designing the data objects of an enterprise (or for a specific project on a smaller scale) based on the business requirements. The process covers many aspects of the design: relationships between different...
by XTIVIA | Jun 20, 2019 | Blog, Cloud, Data Management, Databases
In the face of SQL Server 2008’s end of life, there’s been a lot of buzz around utilizing SQL Server on Azure Virtual Machine (VM). As one of the many ways of continuing support for your SQL Server Database, we’d like to elaborate on what exactly...
by Kathleen Long | Jun 11, 2019 | Blog, Cloud, Data Management, Databases
SQL Server 2008\2008 R2’s retirement is inching closer; now is the best time to weigh your options and decide on the next course of action. Do you migrate your SQL Server database to an Azure environment or do you keep an on-premise system and upgrade to SQL...
by Brad Patterson | Nov 8, 2017 | Blog, Data Management
I often use the Informix Developer Edition for ARM on my Raspberry Pi for quick prototyping and proof-of-concept (POC) experiments as the Informix Developer Edition has all of the features of the full Enterprise Edition, including native JSON and Time Series...