LogoLogo
API Documentation
Version 1.19.5 and Older
Version 1.19.5 and Older
  • DecisionRules Documentation
  • API
    • API Introduction
    • API Keys
      • Solver API Keys
      • Management API keys
      • BI API keys
    • Rule Solver API
    • Management API
      • Deprecated Endpoints
    • Console Logs API
    • Business Intelligence API
      • Deprecated Endpoints
    • Datacenters & Locations
      • Global Cloud
      • Regional Cloud
    • Apache Kafka Solver API
    • Endpoint Settings
    • Archive
      • Rule Flow Solver API (DEPRECATED)
  • Decision tables
    • Decision Tables Introduction
    • Table Designer
    • Input & Output JSON Model
      • Simple Editor
      • JSON Editor
      • Binding to Model
    • Supported Data Types
    • Operators and Functions
      • Basic operators
      • Date operators
      • Functions
        • Logical Functions
        • Math Functions
        • Date and Time Functions
        • Text Functions
        • Data Functions
        • Array Functions
        • Integration functions
        • Functions and JSON
    • Export & Import of Decision Tables
      • Export Decision Table
      • Import Decision Table
      • File Structure of JSON Format
      • Managing Decision Table in Excel/Google Sheets
      • Deprecated Formats: XLSX v.1 and CSV
    • Table Operations
      • Filter Values
      • Valid Values
      • Sorting
  • Decision Trees
    • Decision Trees Introduction
    • Decision Tree Designer
    • Export & Import Decision Trees
      • Export Decision Tree
      • Import Decision Tree
  • Scripting Rules
    • Scripting Rule Introduction
    • Custom functions in Scripting Rules
    • Calling external API within ScriptingRules
    • Use Rule Variables in Scripting Rules
    • Call Embedded Rules in Scripting Rules
    • Export & Import Scripting Rules
      • Export Scripting Rule
      • Import Scripting Rule
    • Tips
  • Rule Flow
    • Rule Flow Designer
    • Rule Flow Mapping
    • Rule States in Rule Flow
    • Warnings & Errors
    • Rule Flow Limits
    • Export & Import Rule Flows
      • Export Rule Flow
      • Import Rule Flow
  • Workflow
    • Workflow Introduction
    • Workflow Designer
    • Workflow Nodes Overview
    • Workflow Limits
  • Other
    • Rule Alias
    • Execution Strategy
    • Rule State
    • Rule Versioning
    • Favorite Rules
    • Rule Variables
    • Rule Comparison
      • Decision Table Comparison
      • Decision Tree Comparison
      • Scripting Rule Comparison
    • Rule Tags
    • Rule Dependencies
    • Test Bench
    • Single Sign-On (SSO)
    • Event timeline
    • Rule Lock
    • Rule Migration Strategies
    • Changes in Version 1.19.0 (10/2024)
  • Organizations
    • Introduction
      • Access to Organization
    • Structure
      • Organization Roles
      • Members
      • Teams
      • Spaces
      • Space Roles
      • Policies
      • Settings
  • Teamwork
    • Dashboard
    • Folders
    • Spaces
    • Manage Spaces
    • Share Rules Between Spaces
    • Users & Roles
    • Teamwork Indicator
  • SDK and Integrations
    • Languages / Frameworks
      • SQL Server
      • Oracle PL/SQL
      • PostgreSQL
      • JavaScript
      • Java Spring Example
      • PHP Library
      • Python Library
      • .NET Library
      • Google Tag Manager
    • Excel Add-in
  • Business Intelligence
    • Audit Logs
    • Create a Power BI Report
    • Connect Power BI to Business Intelligence API
    • Connecting from Power BI (deprecated)
    • Connect DecisionRules to Power BI Using Our Custom Connector
  • Billing
    • Invoices & Billing
    • Change Product Plan
    • Billing Information
    • Plan Limits Explained
  • Regional Cloud
    • Regional Cloud
    • Region Specific API URLs
  • On-Premise / Docker
    • Environment Variables
    • Redis Connection Modes
    • Setup Single Sign-On (SSO)
      • Set up Microsoft Entra ID SSO
      • Set up Google SSO
    • DecisionRules Application
      • Minimal Requirements
      • DecisionRules Server
      • DecisionRules Client
      • DecisionRules Business Intelligence
      • Networking Between Docker Containers
    • Docker Showcase App
      • Showcase
      • Showcase + Business Intelligence
    • AWS Setup
      • AWS ECS/Fargate
      • Cache - Amazon ElastiCache
    • Microsoft Azure Setup
      • Database - Azure CosmosDB
      • Cache - Azure Cache for Redis
      • Azure Container Apps
    • Azure Red Hat OpenShift
    • Google Kubernetes Engine (GKE)
    • Kubernetes Setup
      • Kubernetes Setup with Business Intelligence
    • Logging options
    • CD/CI Pipelines
      • Azure DevOps CICD Pipelines
      • Using Migration script (old way)
    • Offline License
  • Terms & Conditions
    • Terms and Conditions
    • Privacy Policy
    • Service Level Agreement
      • Community Support
      • Standard Cloud (SaaS)
      • Silver SLA
      • Gold SLA
      • Custom SLA
    • Sub-Processor List
  • Roadmap 🚲 🗺️
  • Release Notes
    • Public Cloud
    • On-Premise / Private Cloud
Powered by GitBook
On this page
  • How to Connect PowerBI and DecisionRules
  • Step 1 - MongoDB
  • Step 2 - BI Connector
  • Step 3 - ODBC Driver
  • Step 4 - Power BI Connection

Was this helpful?

  1. Business Intelligence

Connecting from Power BI (deprecated)

This tutorial describes how to connect DecisionRules data stored in your own (on-premise) MongoDB database from Power BI to visualize or analyze it.

Was this helpful?

This way of loading rule solver data to Power BI is no longer recommended. We have provided the which can be used to achieve the same goal in a much easier way. Check out the tutorial.

How to Connect PowerBI and DecisionRules

To aproach DecisionRules data (Rule Engine statistics, Rule Input/Output data etc.) seated in MongoDB database we recomend to use/setup BI Connector and MongoDB ODBC Driver for BI Connector.

The MongoDB ODBC Driver for BI Connector provides connectivity between a SQL client and the MongoDB Connector for BI. The ODBC driver enables users to create a Data Source Name (DSN) and connect a variety of BI tools to the BI Connector. It includes the BI Connector authentication plugin, which implements the client side of MongoDB-supported authentication mechanisms.

Step 1 - MongoDB

In section Security - Database Access create new User, e.g. "dbReportUser" with Role "readAnyDatabase".

In section Security - Network Access also setup IP address of host that will aproach your MongoDB database (value 0.0.0.0/0 means Any host).

Step 2 - BI Connector

The MongoDB Connector for BI allows you to use your BI tool of choice to visualize, discover, and report against MongoDB data using standard SQL queries. There are two options how to put it between ODBC Driver and MongoDB:

A) MongoDB BI Connector running in Cloud

If you run your DecisionRules on MongoDB Atlas (MongoDB Cloud Services), just edit configuration of MongoDB database (in Additional Settings - Advanced Settings) and switch on the option "Enable Business Inteligence Connector".

Then choose option Connect - Connect Business Intelligence Tool and see the essential parameters for MongoDB ODBC Driver.

B) MongoDB BI Connector running localy

Run the downloaded .msi file and follow the wizard instructions to install the files. The binaries install into a bin directory (e.g. C:\Program Files\MongoDB\Connector for BI\2.14\bin) inside the installation directory. You can delete the old binaries.

To start BI Connector localy with necessary parameters for connecting DecisionRules MongoDB use following example of configuration file:

Inside this file you have to edit variable "mongodb: net: uri" by string you will find in your MongoDB, where you have tu choose option Connect - Connect your application and select DRIVER "Node.js" and its VERSION "2.2.12 or later". The underlined text (see picture bellow) "mongodb://.....27017" is the value you have to writedown into the variable "mongodb: net: uri" (in the file "mongosqld-config-for-DecisionRules.yml" file). Do not forget to edit also variable "username" and "password" that you have created in Step 1.

Last very important variable in "mongosqld-config-for-DecisionRules.yml" file is "schema: path". For DecisionRules MongoDB you can use following template of database objects definition:

You are now ready to launch the BI Connector, but remember, if your MongoDB instance uses authentication, your BI Connector instance must also use authentication. The user that connects to MongoDB via the mongosqld program must have permission to read from all the namespaces you wish to sample data from.

In Command Prompt go to the directory where the BI Connector has been installed (and where you put also the "mongosqld-config-for-DecisionRules.yml" and "schemaDecisionRules.drdl" files) and write "mongosqld --config mongosqld-config-for-DecisionRules.yml" and press Enter. You should see something like this:

Step 3 - ODBC Driver

Download and install the suitable ODBC Driver for MongoDB from:

Start the Microsoft ODBC Data Sources program (choose the program version, 64-bit or 32-bit, which is appropriate for your system and ODBC driver version), select System DSN, then click Add and choose the MongoDB ODBC ... Unicode Driver from the list of available drivers. Click OK.

The following ODBC parameters are required:

  • Data Source Name: A name of your choice

  • TCP/IP Server: The Hostname specified in the MongoDB Connect BI Tool dialog (MongoDB BI Connector running in Cloud) or IP address (bindIp variable) defined in momgosqld configuration file (MongoDB BI Connector running localy)

  • Port: The Port number specified in the MongoDB Connect BI Tool dialog (in MongoDB BI Connector running in Cloud the default is 27015, in MongoDB BI Connector running localy it is defined by variable port in n momgosqld configuration file)

  • Database: The name of the DecisionRules database (the default is Decision)

  • User: Enter either the user specified in the MongoDB Connect BI Tool dialog (in our example it is dbReportUser). The user is specified in the following format: Username?source=AuthDB where AuthDB is the authentication database for the user: - If AuthDB=admin you can omit "?source=admin" string - If you are using Username and Password (SCRAM-SHA-1) authentication, the expected authenticating database is "admin" - If you are using LDAP (PLAIN) authentication, the expected authenticating database is "$external" (EXAMPLE: myTestUser?source=$external)

  • Password: The password that corresponds to the specified User (in our example it is dbReportUser).

Click Test to validate the ODBC connection. If the connection is successful, click OK to add the DSN. If the connection fails, check to make sure your database user is correctly authenticated for the database named in the connection.

Step 4 - Power BI Connection

I you named your System DSN "DecisionRules_MongoDB" or "MongoDB_via_localBIconnector" (as mentioned above) you can immediately use our Power BI Template Files - see bellow:

Just download one of these files (depending of your BI Connector solution) and open it. If you will see following Warning: There are pending changes in your queries that haven't been applied. Choose "Apply Changes".

In the Model section you should see the following tables and their relationships:

In the Report section you should see the prepared visualizations like "Dashboard", "API Calls per Time", "API Calls per Rule" or report of particular rule called "Client Profitability 2" (in this case of reporting a specific rule you will not see any data, this report and its data source are in template only for your inspiration how you can connect and visualize data about a particular rule). See bellow several expamples from the eppTec Power BI Template File:

We prefer to run the MongoDB BI Connector localy (it means on your local server/PC). It does not matter if your DecisionRules MongoDB is installed in your Cloud or on your local server, you have to first download and install (Prerequisite: has been installed on your host) the suitable BI Connector for MongoDB from:

To help you get started MongoDB BI Connector (mongosqld.exe file), a sample of named example-mongosqld-config.yml is included with the installation package. To learn how to start BI Connector with a configuration file, refer to the mongosqld documentation section on the .

Visual C++ Redistributable for Visual Studio 2015
configuration file
Configuration File
Business Intelligence API
Connect Power BI to BI API
MongoDB BI Connector DownloadMongoDB
Logo
Releases · mongodb/mongo-bi-connector-odbc-driverGitHub
Logo
851B
mongosqld-config-for-DecisionRules.yml
6KB
schemaDecisionRules.drdl
1MB
eppTec_RuleEngine_Reports_BIconn_running_in_Cloud.pbix
1MB
eppTec_RuleEngine_Reports_BIconn_running_localy.pbix
Using MongoDB BI Connector running in Cloud
Using MongoDB BI Connector running localy
Dashboard overall
Dashboard for particular User
All API Calls in particulat Time Period
The most called Rules
Example of reporting output values for a particular Rule
Example of reporting dependencies between output and input values for a particular Rule