![]() You need to import the Northwind.json data into your ArangoDB database using Json-Import module to view charts, reports and dashboards. One is BI project and one is Northwind database as JSON file. Info: The sample projects contains two files. C# Module gives you more oppurtinity to work with data using C# language.įigure 4: Query, Transform, Convert the data with ArangoDB C# Driver using C# Module AQL queries attempting to insert documents into a collection like this will. If you want to query, update, change, transform or do other changes to your data, you can allways use to C# Scripting Module wih ArangoDB Driver support. Since ArangoDB 3.8 there was a loophole for creating duplicate keys in the. You need more data transformation or changes? C# Module can help you to this job. Querying data with native ArangoDB query language will save your time, data loss and speed-up data visualization projects.įigure 3: ArangoDB Query (AQL) is the base for Charts With NucleonBI and native ArangoDB AQL support, you do not need to export your data into a CSV or Excel file for data visualization anymore. The result of queries is used for Reporting, Charting, PowerViews, Cross-Table Views, Single Web Pages and other visualiuation components.įigure : ArangoDB Query is base for the dashboards and data visualization. Nucleon BI Studio executes the ArangoDB Query (AQL) on then database and retrieves the results as an flat table and tree data format. It allows to merge two different type of data sources (RDBMS, Key-Value, Document) into a single DataSet for reportig, charting and other visualizations.įigure 1: Shows an DataSet item with native MongoDB QueryĭataSet items contains AQL script to retrieve data. Nucleon BI support also ArangoDB and RDBMS data combinations into an single DataSet. AQL is designed for advanced data quering and data mining. In the Import Data dialog box, locate and double-click the text file that you want to import, and click Import. On the Data tab, in the Get & Transform Data group, click From Text/CSV. Nucleon BI support native ArangoDB query languge (AQL) for data selection, projection, aggregation, filtering and sorting. You can import data from a text file into an existing worksheet. This article shows you how to use Nucleon BI Studio with ArangoDB and ArangoDB Query Language ( AQL). Business Intelligence with ArangoDB and AQL ![]()
0 Comments
Leave a Reply. |