Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Introducing the New dotConnect Release With EF Core 9 and .NET 9 Support

The Devart team is happy to unveil the latest update to its dotConnect product line, which features support for EF Core 9, full.NET 9 compatibility, and a range of other enhancements. Key improvements in this release include: dotConnect stands out by providing robust data connectivity solutions built on the ADO.NET architecture and a comprehensive development framework with innovative technologies.

How to Connect to a Salesforce Database From Python With Devart Python Connector

At first glance, integrating Python with Salesforce looks simple—install a library, connect to an API, and start querying data. But the reality is far more complex. Salesforce’s API structure presents challenges that aren’t immediately obvious.

How to Use SSIS Conditional Split to Direct Data to Multiple Destinations

Mastering SSIS conditional split is essential for efficient data sorting. Whether you intend to direct data to different tables based on specific conditions or want to split it for optimization, this type of transformation will save your day. This technique can help you create customized datasets for different reports, handle files separately whenever your project requires such an approach, and optimize data flow for better performance.

Top 10 Common Transformations in SSIS

SQL Server Integration Services (SSIS) is a Microsoft tool mainly used for data integration and workflow automation in ETL processes. Transformations in SSIS are the essential mechanics behind your data flow, allowing you to clean and shape your data as it travels between systems — whether data warehouses, databases, or cloud storage. Some of these include changing data types, aggregating values, and enriching your data to ensure that it’s accurate and gets where it needs to go smoothly.

How to Consolidate Customer Data Into Excel Using Powerful Add-ins

Data consolidation in Excel is what tames the wild beast of disorganized customer data. Businesses generate a lot of information on many different platforms. Think of customer data in CRMs, sales figures across ERPs, inventory sitting in cloud databases, or social media interactions tracked by various analytics tools. Without consolidation, there is just no easy way to turn this into strategic assets.

Easy Magento Bulk Order Processing Using Excel and Add-in

Receiving a flood of orders in your Magento store is exciting, but handling each one separately is not that great. With Magento bulk order processing, you can quickly process shipments, create invoices, update tracking information, and modify the status of several orders at once. This will save you time and help you manage high volumes of orders without worrying about manual errors.

Delphi InterBase: Comprehensive Guide to Features, Installation, and Usage

Delphi InterBase is a well-known SQL database for developers who want to embed a lightweight database management system into their cross-platform applications. Its popularity comes from its high performance, fast data processing, and seamless integration with Delphi, offering a hassle-free setup without the administrative overhead of other systems. Now, the whole process is even easier if you use the right tools.

Best VCL UI Components for Delphi Developers

Working with Delphi UI components is essential to make your development life easier and more efficient. The Visual Component Library (VCL) is the backbone of Delphi’s RAD environment for Windows, providing many prebuilt UI components like buttons, tables, and text boxes. It also serves as a foundational framework for C++Builder. Plus, it inspired the Lazarus Component Library (LCL), which supports cross-platform development.

Supercharging FerretDB Performance with Coroot: A Success Story

At Coroot, we’re passionate about providing developers with the tools they need to build and maintain high-performing applications. Recently, we had the opportunity to help a team using FerretDB, the open-source document database offering MongoDB compatibility with a PostgreSQL backend, significantly improve their monitoring and performance. This is their story.

How to benchmark your database management system | Data & AI Masters | Canonical

In this talk Mohamed Nsiri will provide a step-by-step guide on how to perform a benchmark of a given database management system configuration. We will explain how to assess the performance impact of a change (in memory, cpu speed, etc.) and how to universally compare different setups. The workshop will cover various factors that can significantly impact the performances of your databases including number of concurrent users, workload pattern and more.