Connecting to SQL databases

NOTE: Flexmonster Data Compressor is considered deprecated, so the approach described below is not recommended for connecting to SQL databases.
To see the relevant way of connecting to relational databases, refer to this article.

Anyone who has made reports or pivot tables with relational databases has faced a problem with finding a suitable component that performs all required functions quickly. Flexmonster offers a solution to this problem with Flexmonster Data Compressor – a server-side tool that increases data loading speeds from the server to the user’s browser.

Advantages of Flexmonster Data Compressor:

• Easily converts responses from databases with only a few lines of code
• Streams large datasets with minimal delay to users
• Available for various platforms and databases

Alphabets with special characters will be displayed correctly because the Data Compressor uses UTF-8 encoding. Ensure that your content-type HTTP header also has UTF-8 encoding with the following line of code:

header('Content-type: text/html; charset=utf-8');

Supported databases

• Oracle
• MySQL
• Microsoft SQL Server
• PostgreSQL
• Other ADO.NET / ODBC / JDBC databases

To connect to MongoDB, use the Flexmonster MongoDB Connector. If you use other NoSQL databases or data warehouses please refer to our Connecting to other data sources tutorial.

Guides

Flexmonster Data Compressor is available for .NET, Java, PHP, and Node.js. Follow detailed tutorials for each technology:

• Connecting to a relational database with .NET
• Connecting to a relational database with .NET Core
• Connecting to a relational database with Java
• Connecting to a relational database with PHP
• Connecting to a database with Node.js