English |
---|
With Replica 365 you can replicate Business Central (“BC”) tables to Azure Table Storage (“ATS”). In ATS you can store large amounts of data. You can use ATS to query on this set of data using applications like Excel and PowerBI. ATS scales it’s tables automatically as your demand increases. Replicating your BC tables to ATS will lower the impact on your BC environment, so that your BC environment is not experiencing a significant load when a lot of data is requested for reports. Because the BC data is already available in ATS, reports will also be loaded faster. From ATS you can also use the data as a source for your BI environment, for example in Azure SQL or in your Data Warehouse. Use the Replica 365 page to configure the tables that you want to be replicated. |
...
English | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Prerequisites
Business Central Setup
Select fieldsFor each Table you can select the desired fields you want to Replicate.
|
Dutch | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Voorwaarden
Business Central Setup
Select fieldsFor each Table you can select the desired fields you want to Replicate.
|
English |
---|
Schedule ExportsTo automatically schedule Exports from BC to ATS, you can use BC’s Job Queue.
Best practicesSome suggestions and best practices regarding the configuration of Replica 365:
PowerBI Reports - Querying on Azure Table StorageIt is possible to connect directly to Azure Table Storage using Microsoft PowerBI.
|
...