logo
small logo
  • Products
  • Comprar
  • Suporte
  • About
  • Customer panel Suporte
    • en
    • de
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to connect to RavenDB
  • How to use stored procedures with multiple sets of data as a result

    8 de maio de 2020

    Often, when creating reports, we have to deal with databases that are far from ideal.

    read more
  • Connection to NosDB (NoSQL)

    11 de novembro de 2019

    NosDB is a prominent representative of the NoSQL databases. It is designed for use on

    read more
  • How to connect to SQLCe

    11 de novembro de 2019

    Microsoft SQL Server Compact Edition is a simple local relational database that doesn't require installation,

    read more
  • How to connect to VistaDB

    15 de novembro de 2019

    The Vista database will fall into the type of embedded databases. These databases differ from

    read more
  • How to connect to OracleDB from FastReport .NET

    15 de novembro de 2019

    First of all, you can use the ODBC connector. But it is fraught with a

    read more

How to connect to RavenDB

11 de novembro de 2019

Recently, the NoSQL database is gaining more and more popularity. They differ favourably from conventional relational databases and provide the following: high resilience, incredibly large amounts of data, good scalability, clustering.

One of the new NoSQL databases is RavenDB. This is a document-oriented database, like the popular MongoDB. But compared to the last, RavenDB is an open source database. This means you can use it in your apps for free and add functionality according to your wish.
Let's look at the way to connect the RavenDB database in your report. To do this, you need to use a plug-in connector from the supply of Fastreport.Net, which is located in the catalog of the installed program in the folder Extras\Connections\FastReport.RavenDB. We are compiling this project.
Now we move to the report designer and add a plug-in to the File->Options menu.

 

Once you've added fastReport.RavenDB.dll to the plugins, you need to reboot the designer and start building a connection.

 

In the list of available connections you can find new connector RavenDB.

 

Depending on your database settings, the connection may be secure or unprotected. In the first case, you need to enter the username and password.
Your database may be on a remote server or on a local computer, does not matter. We only specify the host URL and the name of the base. As a result, an unsecured connection line will look like this:

Url = http://desktop-9kdjgvm:9072/;Database=TestDatabase

Next, as usual let’s move to the table selection:

 

Unfortunately, we cannot use SQL queries editor. Although NoSQL provides the ability to write SQL alike queries, yet query building wizard cannot work with them. Therefore, parameterized queries, are also not available for us.
Please note that the essence of Companies has different subordinate entities that already have final data fields. This is specificity of document-oriented NoSQL databases, which have a hierarchy of data. Most often they use json-like documents that allows you to create a hierarchical design data shown in the figure above.

about product comprar
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
.NET FastReport Data Source

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Comprar
  • Download
  • Documentação
  • Depoimentos
  • Como desinstalar nossos produtos
  • FAQ
  • Tutorial Video
  • Forum
  • Support SLA
  • Articles
  • Our News
  • Informação sobre nós
  • Parceiros
  • Extended licensing
  • Contatos

© 1998-2023 by Fast Reports Inc.

  • Privacidade

Trustpilot