PL 400 : create and use alternate key (Implement data synchronization)

Alternate key is not a new concept, it is available in the database which considers it as an alternative of primary key. Normally, a primary key is only one column in a table, but columns that can be replaced to a primary but not a primary key are called alternate keys. Whereas, primary key does not hold null values ​​and maintain uniqueness, but in alternate keys, it contains null values ​​with uniqueness.


Primary key is already implemented in all Microsoft Dataverse records, it maintains uniqueness by unique identifiers defined as GUIDs, but Microsoft also provides a alternate key to integrate with an external data store, we might be able to add a column to the external tables to contain a reference to the unique identifier in Dataverse.

With alternate keys, we can define column in Customer Engagement table to correspond to unique identifier  or unique combination of columns used by the external data store.

Common Requirements:
  • Link records from external system to Dataverse without modify external system schema.
  • Eliminate duplicate records.
Database Table columns supported for Alternate Key:
  • Decimal Number
  • Whole Number
  • Single Line of text
  • Datetime
  • Lookup
  • Option set
To Create the Alternate Key:

  • Login on https://make.powerapps.com portal
  • Go on Dataverse Table either enter directly by Dataverse option or Use Solution (Best practice to use solution).
  • Under the Dataverse table, Click on the Keys.



  • Click the Add Key options, Add Key popup will appear


For creation of Alternate key, A key must contain at least one column.

 Important points:

  • 16 columns per key
  • Total key size does not violate SQL based index constraints like 900 bytes per key.
  • 10 alternate keys par table definitions
  • Alternate keys use database indexes to enforce uniqueness and optimize lookup performance.
  • If the data within a column that is used in an alternate key will contain one of the following characters /,<,>,*,%,&,:,\\,? then retrieve (GET), update or upsert (PATCH) actions will not work.

Comments

Post a Comment

Popular posts from this blog

Exploring the Differences: Managed vs. Unmanaged Solutions in Dynamics CRM/Dataverse

Image
In Dynamics CRM/Dataverse, solutions are central to Application Lifecycle Management (ALM) , providing a structured way to manage, package, and distribute customizations across environments. Microsoft uses solutions to transfer apps and customizations by exporting them from one Dataverse environment and importing them into another.  Each solution is authored and maintained by a publisher and includes components like Power Apps (canvas and model-driven), flows, entities, forms, connectors, web resources, and configurations—excluding business data. Solutions streamline ALM practices within Microsoft Power Platform. In Dynamics CRM/Dataverse, there are two types of solutions: Managed and Unmanaged . When planning an implementation, it’s important to understand the advantages and disadvantages of each to make an informed decision. Let’s explore both types to determine the best approach for development and deployment. In Dynamics 365 CRM, a managed solution is a fully packaged solution ...
Read more

PCF vs. Web Resources: Choosing the Right Extensibility Tool for Dataverse

Image
Extensibility refers to the ability to be extended or augmented beyond the default capabilities of the platform. This involves customization but also includes more advanced techniques, such as coding, integration with external services, and the use of custom components. In the context of Power Platform and Dynamics CRM, the term "extend behavior" refers to the ability to customize and extend the functionality of the platform to meet specific business needs. Extensibility often requires technical skills, such as coding in JavaScript, C#, or using tools like Azure Logic Apps and Power Automate for complex integrations. Customization  is a subset of extensibility. Customization involves configuring and modifying existing elements within the platform to suit specific business needs. Extensibility, on the other hand, covers a wide range of functions and techniques, including customization and more advanced development and integration tasks, to extend the capabilities of the Power ...
Read more

Effective Strategies for Debugging Plugins in Dynamics CRM

Image
In a recent interview, I was asked about debugging plugins in Dynamics CRM. The interviewer specifically wanted to know my approach to plugin debugging. In response, I mentioned using the Plugin Registration Tool profiler. However, I later realized there are multiple methods to debug plugins in Dynamics CRM/Dataverse, each essential for efficient troubleshooting. Debugging plays a crucial role in development, and having a solid understanding of various debugging approaches can help streamline issue resolution in Dynamics 365. Here, I'll explore different techniques for debugging plugin code. There are below options to use in the plugin in Dynamics CRM/Dataverse ITracingService : In Dynamics CRM plugin development, ITracingService is a service provided within the plugin's execution context that logs information for tracing and debugging. It allows developers to capture real-time. Plugin Profiler : A plugin profiler in Dynamics CRM (or Dataverse) is a debugging tool in the Plugi...
Read more