Devart Blog

JSON Support in Entity Framework v4 – v6 in dotConnect for Oracle, MySQL, and PostgreSQL

Posted by on December 8th, 2016

Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data – json data type in MySQL (since MySQL 5.7.8), and json and jsonb data types in PostgreSQL (json introduced in PostgreSQL 9.2, and jsonb introduced in PostgreSQL 9.4).

In Oracle, some JSON-related functionality was added in version 12c. Oracle Database currently does not offer a specific data type, and you should store JSON in usual CLOB and NCLOB columns.

Among other improvements, the new versions of dotConnect for Oracle, dotConnect for MySQL, and dotConnect for PostgreSQL offer support of JSON-related functionality of these databases in Entity Framework. In Entity Framework v4, v5, and v6, you can call database-specific JSON-related functions and operators in LINQ to Entities queries.

Let’s see how to do it on a simple examples:

Read the rest of this entry »

How to import data to Excel using ODBC

Posted by on December 6th, 2016

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. Microsoft provides a great number of tools for data management and for cloud-stored data in particular. Microsoft Excel is one of the most popular products for data management. However, it works locally on a user’s machine. Is there any chance to access data in the cloud? The answer is yes. Here ODBC comes into the action. Let’s see how to use ODBC driver for NetSuite as a connectivity solution between NetSuite ERP and MS Excel.
Read the rest of this entry »

Review Assistant Migration Issues

Posted by on November 18th, 2016

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 SQLite for this purpose. This article describes the problems you may encounter when migrating from SQLite to SQL Server and how to solve them.

Read the rest of this entry »

Use VirtualDataSet to access objects list via TDataSet interface

Posted by on November 18th, 2016

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.

Read the rest of this entry »

PASS Summit 2016 Wrap-Up!

Posted by on November 8th, 2016

A look back at PASS Summit 2016

We were leaving Seattle inspired. PASS Summit 2016 has ended two weeks ago and we are already looking forward to what is next in 2017. By the way, organizers welcome you to register for PASS Summit 2017. Read the rest of this entry »

How to automatically generate SQL Server documentation

Posted by on November 2nd, 2016

In this blog post, we will learn how to quickly create a comprehensive documentation of an SQL Server database using dbForge Documenter for SQL Server, a database documentation generator from Devart.

There are a lot of benefits you get when generating database documentation automatically using dbForge Documenter for SQL Server. You don’t have to spend hours retrieving and writing technical information from scratch. Documenter builds an accurate and error-free documentation in just a few minutes. Besides, the documentation tool from Devart provides a rich set of features for customizing documentation output to meet your specific requirements.

Documenter presents documentation in an easy to view format, so you can share it with your boss or clients, other developers, DBAs, testers, project managers, business executives or other related persons.

The following example demonstrates how to generate documentation for the AdventureWorks2012 sample database.

Read the rest of this entry »

Devart was the Gold Sponsor of SQLSaturday #538 Sofia

Posted by on October 18th, 2016

Devart was the GOLD sponsor of SQLSaturday #538, that was held on 15 October 2016 in Sofia, Bulgaria.

Mihail Mateev, Genoveva Andreeva, and other team members and volunteers, we would like to say THANK YOU very much for organizing this amazing conference.

We had a great time while communicating with the audience and demonstrating our tools for SQL Server. We also had a great opportunity to share thoughts and ideas, discuss challenges with the community professionals and our friends from Poland, Slovenia, Bulgaria and Ukraine! Read the rest of this entry »

Be ready to meet Devart at PASS Summit 2016

Posted by on October 11th, 2016

Where?

We are more than happy to announce that our team is going to attend PASS Summit 2016. The event will take place on October 25 – 28 in Seattle, WA, USA.

What?

Whether you are a data novice or a professional, PASS Summit is the place to find industry-leading speakers, in-depth training, technical tips and tricks, and connections to take your career to the next level. Read the rest of this entry »

Installation & Configuration of Devart ODBC Driver for QuickBooks

Posted by on August 3rd, 2016

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.

Read the rest of this entry »

Tidy SQL with dbForge SQL Complete

Posted by on August 1st, 2016

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. Read the rest of this entry »