JavaScript Required

We're sorry, but we doesn't work properly without JavaScript enabled.

Looking for an Expert Development Team? Take two weeks Trial! Try Now

Table As A Service: Create Data Integration Strategy

Data Integration Strategy

What is TAAS

Table as a service is a very convenient way of high frequency, high volume data exchange, Dynamics 365 finance and operations, without the need of worrying about the supporting architecture, speed and efficiency. I can make my data be stored and arranged as per any need, without sticking to a fixed metadata, beforehand – as compared to conventional DBMS definition. Your Table exists as an API, whereby you can call the API and enforcing PUT, POST and delete actions thereby.

Data Integration Strategy

Table as a service as a storage

Azure table storage exists as a patterned NoSql data in Azure, resulting in a schema-less design.

Table storage generally comprises of following components:

Look at the following example, that comes from a TAAS on a successful creation:

<content type = “application/xml”> <m:properties> <d:PartitionKey>RecId</d:PartitionKey> <d:RowKey>2121212313</d:RowKey> <d:TimeStamp m:Type=”Edm.DateTime”>2019-12-22T06:06:06.673110727</d:TimeStamp> <d:AcqMethod>Test3</d:acqMethod> <d:Description>Test desc</d:Description> <m:properties> </content>

The above example results from an attempt to write into a table, with fields AcqMethod and Description. PartitionKey and RowKey are evidently unqiue key pair. Here the record exists as a property (starting from to ). The table does not have any fixed schema as contrary to our concept of RDBMS.

Creating a table storage

Step 1:

Navigate to ~\Home\All services\Storage accounts\admin storage account. Choose from ‘Tables’.

Step 2:

Create a new table → give a table name(avoid using ‘_’ or special characters). Press OK to to continue.

This would result in creating your table. See the adjoining URL, implying that it exists as an endpoint API.

Data Integration Strategy

Step3:

Shared access signature (SAS):

A shared access signature is an easy way common palette of data access for various modes of data storages: Blob, Queues, tables or containers.

Navigate to left hand pane → Shared access signature → Generate SAS and Connection string button. Tick on ‘Table’ → to create Keys for Table. Also click on the necessary allowed permissions:

Data Integration Strategy

This will generate the following access key/connection strings:

Data Integration Strategy

Querying your table from Postman:

Copy the ‘Table service SAS URL’ → Open postman → paste it in the browser → amend to include the table name you have created between ? and the last ‘\’ → do a ‘GET’ → Send

It will result in the records of the table as an XML’s key value pair dataset:

Data Integration Strategy

Note: how the name of the table has been given at the end of the SAS key.

Viewing from Azure browser

You can download Azure browser from:

https://go.microsoft.com/fwlink/?LinkId=708343&clcid=0x4009

You can install the storage explorer. It’s an ultimate tool to upload, download, maintain and query your storage contents – just like the older days of SSMS.

Browse down to → on the left hand pane Subscription name → Storage accounts → created table:

Data Integration Strategy

You can query quite easily using query button from above:

Data Integration Strategy

Using logic apps: integration

Logic apps could be used successfully as a messenger exposing your Table Services to expose, interpret/Parse and consume data. You can expose your table as a service and then write a trigger to be fired when the data comes to your table as a HTTP request.

Steps:

The logic app gives the following outcome, when fired from Postman:

Data Integration Strategy

Conclusion

Over expertise of dynamics 365 for finance and operations team share this document related on Table As A Service: Create Data Integration Strategy. This team owns the knack help to grow your business in the best possible manner.

NSS Note

Some of our clients

team