koziavin
00717a92fb
All checks were successful
Deploy Static Site / deploy (push) Successful in 6m6s
220 lines
22 KiB
HTML
220 lines
22 KiB
HTML
<!DOCTYPE html>
|
||
<html lang="en">
|
||
|
||
<head>
|
||
<title>Connect a BI system to ELMA365 On-Premises (with Power BI as an example)</title>
|
||
<meta name="generator" content="Help+Manual" />
|
||
<meta name="keywords" content="" />
|
||
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
|
||
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
|
||
<meta name="viewport" content="width=device-width, initial-scale=1.0">
|
||
<meta name="description" content="You can connect BI systems to BRIX On-Premises. They allow you to build reports and visualize data and analytics. Below you can find a step-by-step guide for connecting a..." />
|
||
<meta name="picture" content="" />
|
||
<meta property="og:type" content="website" />
|
||
<meta property="og:title" content="Full documentation for BRIX365 platform. Low-code developer guide. User guide. Admin guide. Developer guide." />
|
||
<meta property="og:url" content="https://brix365.com/en/help" />
|
||
<meta property="og:image" content="" />
|
||
<link rel="icon" href="favicon.png" type="image/png" />
|
||
|
||
<link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;500;600;700&display=swap" rel="stylesheet" />
|
||
<link rel="stylesheet" href="./jquery-ui.min.css" />
|
||
<link rel="stylesheet" href="default.css" />
|
||
<link rel="stylesheet" href="./search-yandex.css" />
|
||
<link rel="stylesheet" href="./article.css" />
|
||
<link rel="stylesheet" href="./glossary.css" />
|
||
<link rel="stylesheet" href="./theme.css" />
|
||
<script type="text/javascript" src="jquery.js"></script>
|
||
<script type="text/javascript" src="helpman_settings.js"></script>
|
||
<script type="text/javascript" src="helpman_topicinit.js"></script>
|
||
|
||
<script type="text/javascript" src="highlight.js"></script>
|
||
<script type="text/javascript">
|
||
$(document).ready(function(){highlight();});
|
||
</script>
|
||
</head>
|
||
|
||
<body>
|
||
|
||
<script>!function(e,t,c,n,r,a,m){e.ym=e.ym||function(){(e.ym.a=e.ym.a||[]).push(arguments)},e.ym.l=1*new Date;for(var s=0;s<document.scripts.length;s++)if(document.scripts[s].src===n)return;a=t.createElement(c),m=t.getElementsByTagName(c)[0],a.async=1,a.src=n,m.parentNode.insertBefore(a,m)}(window,document,"script","https://mc.yandex.ru/metrika/tag.js"),ym(83179930,"init",{clickmap:!0,trackLinks:!0,accurateTrackBounce:!0,webvisor:!0})</script><noscript><div><img alt=""src=https://mc.yandex.ru/watch/83179930 style=position:absolute;left:-9999px></div></noscript>
|
||
|
||
<header class="header elma-365">
|
||
<div class="container">
|
||
<a class="header__logo" href="https://brix365.com/en/help">
|
||
<img src="./logo-en.svg" alt="header logo">
|
||
</a>
|
||
<!-- <div class="hero__search-form" id="search-panel">
|
||
<form class="search-form" onsubmit="ym(83180416,'reachGoal','poisk')">
|
||
<label class="search-form__label">
|
||
<span id="reset-search" class="search__icon"></span>
|
||
<input class="search-form__input" type="text">
|
||
</label>
|
||
<input class="search-form__submit" type="submit" value="Submit">
|
||
</form>
|
||
</div> -->
|
||
|
||
<div class="hero__search-form" id="search-panel"> <form class="search-form"> <label class="search-form__label"> <span id="reset-search" class="search__icon"></span> <input class="search-form__input" type="text"> </label> <input class="search-form__submit" type="submit" value="Submit"> </form> </div>
|
||
<div class="hero__search">
|
||
<a href="#" id="search-icon" class="hero__search-icon">
|
||
<img src="search-icon-white.svg" alt="search string">
|
||
</a>
|
||
<a href="#" id="side-menu-icon" class="hero__side-icon">
|
||
<img src="side_menu.svg" alt="side menu">
|
||
</a>
|
||
</div>
|
||
<div class="header__navi">
|
||
|
||
<ul class="header__list"><li><span class="solution-select"><span class="solution-select__selected"></span><svg width="7" height="4" viewBox="0 0 7 4" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1 1L3.5 3.5L6 1" stroke="white" stroke-linecap="round" stroke-linejoin="round"/></svg><ul class="solution-select__list"><li><a class="project-link" href="https://brix365.com/en/help/platform/get-trial.html">Platform</a></li><li><a class="project-link" href="https://brix365.com/en/help/ecm/ecm-functions.html">ECM</a></li><li><a class="project-link" href="https://brix365.com/en/help/crm/crm_overview.html">CRM</a></li><li><a class="project-link" href="https://brix365.com/en/help/service/service-functions.html">Service</a></li><li><a class="project-link" href="https://brix365.com/en/help/projects/projects-functions.html">Projects</a></li><li><a class="project-link" href="https://brix365.com/en/help/business_solutions/-elma365-store.html">Business Solutions</a></li></ul></span></li><li><a href="https://api.brix365.com/en/" target="_blank">API</a></li><li><a href="https://tssdk.brix365.com/" target="_blank">SDK</a></li></ul>
|
||
|
||
|
||
</div>
|
||
</div>
|
||
|
||
</header>
|
||
|
||
|
||
|
||
|
||
<main class="main container">
|
||
|
||
<aside class="sidebar" id="sidebar">
|
||
<div class="sidebar__header">
|
||
<a class="header__logo" href="https://brix365.com/en/help">
|
||
<img src="./logo-light-en.svg">
|
||
</a>
|
||
<span class="sidebar__close elma-365-close" id="close"></span>
|
||
</div>
|
||
<div class="sidebar__wrapper" id="side-menu">
|
||
|
||
</div>
|
||
</aside>
|
||
|
||
<article class="article" id="article">
|
||
<div class="article-inner">
|
||
<div class="content">
|
||
<header class="article__header">
|
||
<div class="article__bread" style="display:flex; gap:10px;">
|
||
<span id="subcategory" class="search-res__item-category search-res__item-category_subcategory subcategory article__badge"></span>
|
||
|
||
<div class="topic__breadcrumbs">
|
||
<p><a href="elma365-on-premises.html">BRIX On-Premises</a> > Other / Connect a BI system to ELMA365 On-Premises (with Power BI as an example)</p>
|
||
</div>
|
||
|
||
</div>
|
||
<div class="topic__title"><h1 class="p_Heading1"><span class="f_Heading1">Connect a BI system to BRIX On-Premises (with Power BI as an example)</span></h1>
|
||
</div>
|
||
|
||
</header>
|
||
<section class="article__content">
|
||
<div class="scroll-top-inner">
|
||
<a href="#h1-article" class="scroll-top"></a>
|
||
</div>
|
||
<!-- Placeholder for topic body. -->
|
||
<p style="line-height: 1.20; background: #ffffff; margin: 7px 0 16px 0;"><span style="font-size: 15px; font-family: Inter; color: #212529;">You can connect BI systems to BRIX On-Premises. They allow you to build reports and visualize data and analytics. Below you can find a step-by-step guide for connecting a BI system with </span><span style="font-size: 15px; font-family: Inter; font-weight: bold; color: #212529;">Power BI</span><span style="font-size: 15px; font-family: Inter; color: #212529;"> as an example.</span></p>
|
||
<p class="p_CodeExample" style="page-break-inside: avoid;"><span class="f_CodeExample">начало внимание</span></p>
|
||
<p style="line-height: 1.20; background: #ffffff; margin: 7px 0 16px 0;"><span style="font-size: 15px; font-family: Inter; color: #212529;">Note that editing data directly can cause undesired operation of the whole application. Use connection to a BI system only to read data.</span></p>
|
||
<p class="p_CodeExample" style="page-break-inside: avoid;"><span class="f_CodeExample">конец внимание</span></p>
|
||
<h2 class="p_Heading2"><span class="f_Heading2">Install BRIX</span></h2>
|
||
<p style="line-height: 1.20; background: #ffffff; margin: 7px 0 16px 0;"><span style="font-size: 15px; font-family: Inter; color: #212529;">Install the BRIX server to </span><span style="font-size: 15px; font-family: Inter; font-weight: bold; color: #212529;">Ubuntu</span><span style="font-size: 15px; font-family: Inter; color: #212529;">. Read more about it in the <a href="elma365-on-premises.html" class="topiclink">BRIX On-Premises</a> article.</span></p>
|
||
<h2 class="p_Heading2"><span class="f_Heading2">Prepare the initial data</span></h2>
|
||
<p style="line-height: 1.20; margin: 0 0 11px 0;"><span style="font-size: 15px; font-family: Inter;">After successfully installing the BRIX server, you need to get the PostgreSQL database login and password and forward the port that will be used to connect to the database. This step needs to be performed for BRIX Standard if the PostgreSQL database is within MicroK8s. For BRIX Enterprise with a database outside MicroK8s, this preparation step is not required.</span></p>
|
||
<ol style="list-style-type:decimal">
|
||
<li value="1" style="line-height: 1.20; margin-top: 0; margin-right: 0; margin-bottom: 11px;"><a id="preparationstepone" class="hmanchor"></a><span style="font-family: Inter;">Get the login and password to the PostgreSQL database by running the following command:</span></li></ol>
|
||
<p class="p_CodeExample" style="page-break-inside: avoid;"><span class="f_CodeExample">echo postgres:$(sudo kubectl get secrets postgres -o jsonpath='{.data.postgresql-password}' | base64 -d)</span></p>
|
||
<ol style="list-style-type:decimal">
|
||
<li value="2" style="line-height: 1.20; margin-top: 0; margin-right: 0; margin-bottom: 11px;"><span style="font-family: Inter;">Create a file with the following content. Note that each space and indent matters!</span></li></ol>
|
||
<p class="p_CodeExample" style="page-break-inside: avoid;"><span class="f_CodeExample">apiVersion: v1</span><br />
|
||
<span class="f_CodeExample">kind: Service</span><br />
|
||
<span class="f_CodeExample">metadata:</span><br />
|
||
<span class="f_CodeExample"> name: postgres-external</span><br />
|
||
<span class="f_CodeExample"> namespace: default</span><br />
|
||
<span class="f_CodeExample">spec:</span><br />
|
||
<span class="f_CodeExample"> type: NodePort</span><br />
|
||
<span class="f_CodeExample"> ports:</span><br />
|
||
<span class="f_CodeExample"> - port: 5432</span><br />
|
||
<span class="f_CodeExample"> nodePort: 30432</span><br />
|
||
<span class="f_CodeExample"> selector:</span><br />
|
||
<span class="f_CodeExample"> statefulset.kubernetes.io/pod-name: postgres-0</span></p>
|
||
<p style="line-height: 1.20; margin: 0 0 11px 0;"><span style="font-family: Inter;">To create a file using the Ubuntu Server terminal:</span></p>
|
||
<ol style="list-style-type:decimal"><ul style="list-style-type:circle">
|
||
<li style="line-height: 1.20; margin-top: 0; margin-right: 0; margin-bottom: 11px;"><span style="font-family: Inter;">Launch the terminal-based text editor Nano. To do that, enter </span><code><b>nano</b></code><span style="font-family: Inter;">.</span></li><li style="line-height: 1.20; margin-top: 0; margin-right: 0; margin-bottom: 11px;"><span style="font-family: Inter;">Copy and paste the code into the editor. Close the editor by clicking </span><span style="font-family: Inter; font-weight: bold;">Ctrl + X</span><span style="font-family: Inter;">.</span></li><li style="line-height: 1.20; margin-top: 0; margin-right: 0; margin-bottom: 11px;"><span style="font-family: Inter;">Save the changes by clicking </span><span style="font-family: Inter; font-weight: bold;">Y</span><span style="font-family: Inter;">.</span></li><li style="line-height: 1.20; margin-top: 0; margin-right: 0; margin-bottom: 11px;"><span style="font-family: Inter;">Enter the name of the file, for example, </span><code><b>pgportforward.yaml</b></code><span style="font-size: 15px; font-family: Inter;">.</span></li></ul></li></ol>
|
||
<ol style="list-style-type:decimal">
|
||
<li value="3" style="line-height: 1.20; margin-top: 0; margin-right: 0; margin-bottom: 11px;"><span style="font-family: Inter;">Run the following command, passing the file you created:</span></li></ol>
|
||
<p class="p_CodeExample" style="page-break-inside: avoid;"><span class="f_CodeExample">sudo kubectl apply -f pgportforward.yaml</span></p>
|
||
<ol style="list-style-type:decimal">
|
||
<li value="4" style="line-height: 1.20; margin-top: 0; margin-right: 0; margin-bottom: 11px;"><span style="font-family: Inter;">Now you can connect to the database from another machine in the network via the IP address and port 30432.</span></li></ol>
|
||
<h2 class="p_Heading2"><span class="f_Heading2">Install Power BI</span></h2>
|
||
<ol style="list-style-type:upper-roman">
|
||
<li value="1" class="p_Heading2"><span style="font-family: Inter;">Download Power BI and deploy it on the client machine following the instructions.</span></li><li value="2" class="p_Heading2"><span style="font-family: Inter;">Establish connection with the BRIX server using the PostgreSQL database.</span></li><li value="3" class="p_Heading2"><span style="font-family: Inter;">Enter the server’s address, port 30432, the database name, and the PostgreSQL login and password that you obtained on the preparation step (<a href="bi-elma365.html#preparationstepone" class="topiclink">step 1</a>).</span></li><li value="4" class="p_Heading2"><span style="font-family: Inter;">When the connection is successfully established, get the list of tables in the BRIX database.</span></li><li value="5" class="p_Heading2"><span style="font-family: Inter;">Choose the tables you want to create a report for.</span></li><li value="6" class="p_Heading2"><span style="font-family: Inter;">Load the tables to Power BI. If data in table rows is displayed in an incorrect format, go to the </span><span style="font-family: Inter; font-weight: bold;">Transform</span><span style="font-family: Inter;"> tab, click the </span><span style="font-family: Inter; font-weight: bold;">Parse</span><span style="font-family: Inter;"> option, and select </span><span style="font-family: Inter; font-weight: bold;">JSON</span><span style="font-family: Inter;">.</span></li><li value="7" class="p_Heading2"><span style="font-family: Inter;">Configure which fields need to be displayed in columns using the</span><span style="font-size: 15px; font-family: Inter;"> </span><img alt="bi-interface-icon" width="20" height="17" style="margin:0;width:20px;height:17px;border:none" src="bi-interface-icon.png"/><span class="f_ImageCaption"> </span><span style="font-size: 15px; font-family: Inter;">button</span><span style="font-family: Inter;">.</span></li><li value="8" class="p_Heading2"><span style="font-family: Inter;">Set connection between tables if you need to make a selection from two or more.</span></li><li value="9" class="p_Heading2"><span style="font-family: Inter;">In the </span><span style="font-family: Inter; font-weight: bold;">Report</span><span style="font-family: Inter;"> view, select the data visualization format: table, chart, or map.</span></li><li value="10" class="p_Heading2"><span style="font-family: Inter;">Create a report and display it as a PDF file or publish it using the Power BI features.</span></li></ol>
|
||
<p style="line-height: 1.20; margin: 7px 0 16px 0;"><span style="font-family: Inter;">If you stop using Power BI, you need to close the port that is used to connect to the PostgreSQL database. This can be done with one of the commands below.</span></p>
|
||
<p style="line-height: 1.20; margin: 7px 0 16px 0;"><span style="font-family: Inter;">To delete the </span><span style="font-family: Inter; font-weight: bold;">postgres-external</span><span style="font-family: Inter;"> service, run the following command:</span></p>
|
||
<p class="p_CodeExample" style="page-break-inside: avoid;"><span class="f_CodeExample">sudo kubectl delete service postgres-external</span></p>
|
||
<p style="line-height: 1.20; margin: 7px 0 16px 0;"><span style="font-family: Inter;">To delete the </span><span style="font-family: Inter; font-weight: bold;">postgres-external</span><span style="font-family: Inter;"> service using the </span><code><b>pgportforward.yaml</b></code><span style="font-family: Inter;"> file, run:</span></p>
|
||
<p class="p_CodeExample" style="page-break-inside: avoid;"><span class="f_CodeExample">sudo kubectl delete -f pgportforward.yaml</span></p>
|
||
|
||
<div class="bottom-nav">
|
||
|
||
<a id="prev-link" class="topic__navi_prev" href="nginx-elma365-.html">
|
||
<span class="bottom-nav__arrow bottom-nav__arrow--prev"></span> <span
|
||
class="bottom-nav__link">nginx-elma365-.html</span>
|
||
</a>
|
||
|
||
|
||
<a id="next-link" class="topic__navi_next" href="elma365-stack.html">
|
||
<span class="bottom-nav__link">elma365-stack.html</span> <span
|
||
class="bottom-nav__arrow bottom-nav__arrow--next"></span>
|
||
</a>
|
||
|
||
</div>
|
||
<!-- добавляет на страницу строку блок Была ли статья полезной? -->
|
||
<div class="feedback" id="feedback"><div class="feedback-help"><span><b>Was this helpful?</b></span><form action="" method="POST" class="feedback-form" id="feedback-form"><div class="feedback__popup feedback__popup-response" id="feedback__popup_thx" style="display: none;">Thanks for your feedback!</div><div class="feedback__popup" id="feedback__popup_why" style="display: none;"><div class="feedback__popup-header">Please specify why:</div><input type="radio" name="category" id="bad_recommendation" value="bad_recommendation"><label for="bad_recommendation">Recommendations did not help me</label><input type="radio" name="category" id="difficult_text" value="difficult_text"><label for="difficult_text">Article is hard to understand</label><input type="radio" name="category" id="no_answer" value="no_answer"><label for="no_answer">Didn`t answer my question</label><input type="radio" name="category" id="bad_header" value="bad_header"><label for="bad_header">Content does not match the topic</label><input type="radio" name="category" id="other_reason" value="other_reason"><label for="other_reason">Other</label></div><div class="feedback__popup" id="feedback__popup-other" style="display: none;"><div class="feedback__popup-header">How we can improve it?</div><textarea class="feedback__textarea" name="other" id=""></textarea><input type="submit" class="feedback__other-btn" value="Submit"></div><div class="feedback-form__btn-group"><input type="radio" name="useful" id="feedback__useful_yes" value="true"><label for="feedback__useful_yes"><img src="like.svg" class="small-img" alt="like"><spanclass="feedback-form__btn-group_yes-btn">Yes</spanclass="feedback-form__btn-group_yes-btn"></label><input type="radio" name="useful" id="feedback__useful_no" value="false"><label for="feedback__useful_no"><img src="dislike.svg" class="small-img" alt="dislike"><spanclass="feedback-form__btn-group_no-btn">No</spanclass="feedback-form__btn-group_no-btn"></label></div><select name="category"><option disabled="">Please specify why</option><option value="bad_recommendation" selected="">Recommendations did not help me</option><option value="difficult_text">Article is hard to understand</option><option value="no_answer">Didn`t answer my question</option><option value="bad_header">Content does not match the topic</option><option value="other_reason">Other</option></select><input type="submit"></form></div><div class="found_typo"><p style="margin: 0px; margin-top: 16px !important;"><span><b>Found a typo?</b></span> Select it and press <i>Ctrl+Enter</i> to send us feedback</p></div></div>
|
||
|
||
</section>
|
||
</div>
|
||
<aside class="article__sidebar" style="display:none">
|
||
<input type="checkbox" />
|
||
<div class="article__arrow"></div>
|
||
<div class="table-of-contents elma365-right" id="toc2Content">
|
||
<h3 class="h3-toc">In this topic</h3>
|
||
<nav id="toc2"></nav>
|
||
</div>
|
||
</aside>
|
||
</div>
|
||
</article>
|
||
</main>
|
||
<footer class="footer">
|
||
<div class="footer-container">
|
||
<div class="footer-mobile">
|
||
|
||
<ul class="footer-mobile__list"><li><a href="https://brix365.com/en/" target="_blank">BRIX</a></li><li><a href="https://tssdk.brix365.com/en/latest/" target="_blank">SDK</a></li><li><a href="https://api.brix365.com/en/" target="_blank">API</a></li></ul><ul class="footer-mobile__list"><li><a href="https://brix365.com/en/help/platform/get-trial.html">Platform</a></li><li><a href="https://brix365.com/en/help/ecm/ecm-functions.html">ECM</a></li><li><a href="https://brix365.com/en/help/service/service-functions.html">Service</a></li><li><a href="https://brix365.com/en/help/projects/projects-functions.html">Projects</a></li></ul>
|
||
|
||
|
||
</div>
|
||
<div class="footer-wrap">
|
||
|
||
<div><span class="mobile-question-popup">Send feedback</span><form method="POST" action class="question__popup question-xs" id="question__popup"><div class="question-wrap"><span class="close"></span><span class="title">Ask a question</span><label for="help_question" style="display: none;"></label><textarea name="help_question" id="help_question"></textarea><input type="submit" value="Send"></div></form><div class="hidden fade-in question-success-xs">Sent</div></div>
|
||
|
||
<div class="footer-flex-b">
|
||
<span class="footer-copy">© 2025 BRIX</span>
|
||
<ul class="footer-list">
|
||
|
||
<li class="footer-item">
|
||
<a href="#" class="arrow-top" style="display: block;"></a>
|
||
</li>
|
||
|
||
</ul>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
</footer>
|
||
<iframe name="hmnavigation" style="display:none!important"></iframe>
|
||
<script src="./jquery-ui.js"></script>
|
||
<!--script src="//cdn.jsdelivr.net/npm/featherlight@1.7.14/release/featherlight.min.js" type="text/javascript" charset="utf-8"></script-->
|
||
<script src="./jquery.tocify.min.js"></script>
|
||
<script src="./TypoReporter.min.js"></script>
|
||
<script src="./google-search.js"></script>
|
||
<script src="./main.js"></script>
|
||
</body>
|
||
|
||
</html>
|