How To

Cloud-based CRM systems are becoming incredibly popular in these days. This trend is quite clear. The usage of cloud services does not require a deployment and costly specialized software domestic support, which ultimately reduces a company’s total expenses. (more…)

In this article, we will discuss how to access data using ODBC driver in Microsoft Excel. We will examine in detail the data retrieving process.
Cloud technologies develop rapidly, more and more data is stored in the cloud. (more…)

Starting from version 3.5, Review Assistant uses Microsoft’s SQL Server as an engine for its back-end database. The previous versions of Review Assistant have been using SQLitefor this purpose. This article describes the problems you may encounter when migrating from SQLite to SQL Server and how to solve them.

(more…)

TVirtualDataSet is a virtual dataset that can be used as an intermediate between data stored in an application and data-aware controls used in forms. TVirtualDataSet behaves the same way as any other TDataSet descendant and, therefore, it is compatible with all data-aware controls. However, it does not store data in memory. Work with TVirtualDataSet is implemented by means of events occurring during data exchange between an application and controls. As a result, you can choose a variety of entities as a data storage source: arrays, lists, records, XML files, etc. (more…)

In this blog post, we will learn how to quickly create a comprehensive documentation of an SQL Server database using SQL documentation tool from Devart. (more…)

The article describes installation and configuration of Devart ODBC Driver for QuickBooks on Windows, as well as authorization and connection to a QuickBooks account, and provides a demo sample of retrieving QuickBooks account data using Microsoft SQL Server Management Studio.

(more…)

In this article, we will talk about how to keep SQL code clean and highly readable. We will also discuss how to stop suffering from messy and unformatted code. In addition, we will talk about how to force all team members to adhere generally accepted coding standards with no efforts. (more…)

The VirtualQuery component allows executing SQL queries to sources that are not a database, but a TDataSet or any its descendant. It also allows you to connect to several data sources at a time and work with them using SQL queries as with a single data source. Thus, work in heterogeneous environment is implemented, when execution results of queries to different sources can be retrieved in a single data set. (more…)

This article will demonstrate how to get live currency exchange rates with the help of Python and dbForge Data Generator for SQL Server.

Currency exchange rate is the reference information used in the translation of monetary values from one currency to another. The exchange rate expresses the value of one currency in terms of another. (more…)

For the purpose of this tutorial, we will use a test project from the “Entity Framework 6 Support for Oracle, MySQL, PostgreSQL, SQLite, DB2, and Salesforce” blog article. We will update this project so that it could be used with Entity Framework Core 1 (Entity Framework 7). (more…)