| 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> |
| Section | ||||||
|---|---|---|---|---|---|---|
TARGIT BI for Microsoft Dynamics 365 BC - Cloud(Beta)TechnologyThe 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 BCData 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. LicensingThe 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 detailsWeb service URLThe 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. TenantThe 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. CompanyThe name of Dynamics 365 BC company in the tenant. Company name(s) must be entered exactly as named in BC. User NameThe BC user account. Web Service Access KeyThe 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. DownloadsWhen 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 TARGITIf 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
| ||||||
Video demo 2: Connecting using TARGIT BI Accelerator
| ||||||
| Multimedia | ||||||
| name | TARGIT-SSIS-for-Dynamics-365-BC.mp4 | width | 800
| 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>
|
...