Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML
<script>
  AJS.toInit(function(){
    if (AJS.params.remoteUser == ''){
      AJS.$('#header').hide();
      AJS.$('#main-header').hide();
    }
  });
</script>
<iframe id="topheader" src="https://www.targit.com/layouts/targit13/doc_confluence.aspx" scrolling="no" style="width:100%;height:467px;overflow:hidden;scrolling:no;"></iframe>

Video demo 3: Connecting using SQL Server Integration Services

800

This content has moved to our community pages. Please use the following link to visit the new page:

TARGIT BI for Microsoft Dynamics 365 BC - Cloud

Best Regards,

The TARGIT BI Acceleration Team

Section

TARGIT BI for Microsoft Dynamics 365 BC - Cloud

(Beta)

Technology

The Beta version is available for SQL Server Integration Services and SQL Server Editions of BI Accelerator for Dynamics 365 BC. SQL Server versions 2012 through 2019 are supported.

Adding the TARGIT extension to Dynamics 365 BC

Data extraction from 365 BC to SQL Server is done using a web service implemented as a Dynamics 365 BC Extension combined with custom SSIS tasks developed by TARGIT. Installation of the Extension and the necessary user setup is demonstrated in the video below. The Extension currently uses codeunit 50101. If this codeunit has been otherwise utilized by other updates to your BC installation, please contact TARGIT for assistance.

When the extension (.app file) has been successfully installed and a web service access key has been generated for a user account, a connection can be made to BC using Accelerator and/or using SQL Server Integration Services custom tasks. The two additional video demos below show how to enter the necessary information to establish connection and extract data in each case.

Licensing

The use of TARGIT for Dynamics 365 BC (cloud) is currently licensed as part of BI Accelerator. This means that a valid TARGIT license containing at least one business area for TARGIT BI Accelerator for Dynamics BC is required. The license must be set up at a TARGIT Server available for connection from BI Accelerator or the TARGIT SSIS Connection Manager.

Login details

Web service URL

The web service URL is the common access point for accessing BC. Currently, the URL is http://api.businesscentral.dynamics.com/v1.0. The URL may change with future updates of BC or the TARGIT Extension web service.

Tenant

The tenant identifies the unique account used for Dynamics 365 BC. The tenant ID can be found in the Help & Support section of your Dynamics 365 environment.

Company

The name of Dynamics 365 BC company in the tenant. Company name(s) must be entered exactly as named in BC.

User Name

The BC user account.

Web Service Access Key

The web service access key is generated from the user administration interface in BC and relates to a specific user account.

Record Batch Size (SSIS only)

The Record Batch Size specifies the number of transactions extracted in each batch when running the SSIS package. Changing the batch size has impact on performance. Typically, a batch size between 10000 and 30000 is recommended. BI Accelerator defaults the batch size automatically, currently at 30000 transactions.

TARGIT Server (SSIS only)

The TARGIT Server is the machine name or IP where the TARGIT Server is running. The TARGIT Server needs to be healthy and the licensing information current and valid for the data extraction to run.

Downloads

When using BI Accelerator, separate download of the SSIS tasks is not necessary as BI Accelerator will automatically add the components during configuration.

TARGIT Web Service Extension for Dynamics 365 BC (.app)

TARGIT SSIS Data Reader for Dynamics 365 BC - SQL Server 2012

TARGIT SSIS Data Reader for Dynamics 365 BC - SQL Server 2014

TARGIT SSIS Data Reader for Dynamics 365 BC - SQL Server 2016

TARGIT SSIS Data Reader for Dynamics 365 BC - SQL Server 2017

TARGIT SSIS Data Reader for Dynamics 365 BC - SQL Server 2019

TARGIT BI Accelerator for Dynamics BC / NAV

Contacting TARGIT

If you have questions, issues or other feedback, please write us at bia@targit.com or contact our Account Management or Support teams for assistance.

Video demos

Video demo 1: Adding the TARGIT extension to Dynamics 365 BC

Multimedia
nameTARGIT-Extension-for-Dynamics-365-BC-Installation.mp4
width100%

Video demo 2: Connecting using TARGIT BI Accelerator

Multimedia
nameTARGIT-BIA-for-Dynamics-365-BC.mp4
width800

Multimedia
nameTARGIT-SSIS-for-Dynamics-365-BC.mp4
width




HTML
<style type="text/css">
      #title-text { display: none;} 
      #breadcrumbs, #footer, #likes-and-labels-container, #comments-section { display:none; }	

div.theme-default .ia-splitter #main {
    margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
    display: none;
}
div#main {
    margin-left: 0px !important;
}
div#footer {
  margin-left: 0px !important;
}

.columnLayout.two-equal
{
padding-left: 20px;
padding-right: 20px
}

#main #content
{
padding-right:0px;
}

div#main
{
padding:0px;
}
#page
{
overflow-x: hidden;
}
iframe#topheader
{
border:0px;
}
.contentLayout2 .columnLayout
{
margin-bottom:0px;
}

#workflow-page-message
{
margin-bottom: 0px;
}


.columnLayout.two-equal
{
width: 85%;
margin: auto;
}
   </style>
<script src="//cep.targit.com/bundle/beacon"></script>

<div class="Footer" style="background-color: #1d252d;width:100%;">
    <div class="loop" style="padding-top:69px;padding-bottom:72px;text-align:center;">
        <img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/TARGIT_OODA-jigsaw-start-screen.svg" style="margin-bottom:32px;width:100px;">
        <div style="font-size:24px;line-height:32px;letter-spacing:0.6px;color:#fff;">
            Courage to Act
        </div>
    </div>
    <div style="width:100%;background-color:#121a23;">
        <div style="width:1080px;margin:auto;padding-bottom:20px;padding-top:20px;">
            <div style="float:left;font-size:13px;color:#8a9298;">
                <div style="margin-top:5px;display:inline-block;padding-right:30px;color:#8a9298;">
                    © 2019 TARGIT. All Rights Reserved.
                </div>
                <a style="margin-top:5px;display:inline-block;text-decoration:none!important;color:inherit;font-size:13px;" href="https://www.targit.com/en/personal-data-policy">Personal Data Policy</a>
            </div>
            <div style="float:right;">
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase" href="https://www.targit.com/en/meet-targit/meet-the-targit-team/contact-targit">CONTACT</a>
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase"  href="https://www.targit.com/en/meet-targit/targit-news/news-list">PRESS</a>
                <a style="vertical-align:super;font-size:13px;letter-spacing:0.6px;margin-right:36px;color:#fff;text-decoration:none!important;text-transform:uppercase"  href="https://www.targit.com/en/meet-targit/targit-career/jobs">CAREERS</a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://twitter.com/targit" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/twitterfooter.png"></a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://www.linkedin.com/company/targit" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/linkedinfooter.png"></a>
                <a style="margin-right: 36px !important;text-decoration: none !important;color: inherit;" href="https://www.facebook.com/TARGIT.BI.Suite" target="_blank"><img src="https://targitmedia.azureedge.net/Resources/MainSite/Images/fbookfooter.png"></a>
            </div>
            <div style="float:none;clear:both;"></div>
        </div>
    </div>
</div>

...