Integration Basics

Introduction: Welcome to this article where we will delve into the essential concepts of OAuth authentication. Explanation: Let's begin by considering a scenario: Imagine you want to log in to a different website, but instead of creating new credentials, you opt to use your Google account. As a security measure, Google will ask for your permission before proceeding. Once you grant consent, Google will generate an authorization code specifically for the website in question. This code serves as a token, conferring limited access to certain resources. For instance, it may grant the website access to your email ID, first name, and last name, crucial pieces of information required for successful user registration. This token empowers the website to securely obtain your basic details. Whenever the website needs to retrieve this information, it sends a request to Google, including the authorization token.  Conclusion: By understanding the underlying mechanism of OAuth, we have seen how it...

 Introduction: Welcome to this blog where we will explore message assignment shapes and learn how to assign values to different fields in a message variable. Step-by-Step Guide: 1.             Start by creating a new BizTalk project and solution named "POCMessageAssignment." 2.             Create a strong name key file (snk) and name it "POCMessageAssignment.snk." Refer to this snk file in your project. 3.             In the deployment tab of the project, set the application name as "POCMessageAssignment" and save the project. 4.             Add a new schema to the project named "SourceA" with the following fields •              IdentificationNumber (distinguish this field) •   ...

 Issue: When using orchestration, the message is sent to a message box. Then, a send port is responsible for sending the message to a file location. However, if the file location does not exist, the message fails with an error. Here's the specific error message: "A message sent to adapter 'FILE' on send port 'POCScope.SP' with URI 'D:\Developer\Vipin\POCScope\OUT%MessageID%.xml' is suspended. Error details: The FILE send adapter cannot open the file D:\Developer\Vipin\POCScope\OUT{9463D718-72F2-4BB3-8761-E1A60F2AF7C8}.xml for writing. Details: The system cannot find the path specified. MessageId: {BF023C95-B69B-4A34-B124-642EF5895712} InstanceID: {15D7188F-D9C7-48D5-9748-DCA7201948E4}" Furthermore, the exception handling block written in the orchestration does not execute. Root cause: The issue arises because the error occurs at the send port, which is outside the scope of the orchestration code. The orchestration has already dropped the file onto ...

Scenario When attempting to convert XML to JSON format using the map in the BizTalk send port, I encountered an issue. The output I received was not in the expected format. Please note that the XML format would be then converted to the corresponding JSON format by means of a JSON encoder. Expected format     < Order >         < CustomerPO > 1234 </ CustomerPO >         < DeliveryDate > 0610202312:00 </ DeliveryDate >         < OrderSource > Sales Order </ OrderSource >         < LineItems >             < LineItem >                 < ItemNumber > 1111 </ ItemNumber >                 < OrderQuantity > 2 </ OrderQuantity >                 < UnitOfMeasure > CASE </ Unit...

 Error: I encountered the following error while testing a BizTalk map in Visual Studio: Error Exception Caught: Cannot load source/destination schema: POCSinglePointAPI.Schemas.SinglePointRequest.  Either the file/type does not exist, or if a project dependency exists, the dependent project is not built. C:\Users\c-vJayanarayanan\source\repos\POCSinglePointAPI\POCSinglePointAPI.Maps\CanonicalSalesOrder_TO_SinglePointRequest.btm 1 Solution: Right click on the map project and build the solution After successfully building the solution, the test map should function properly.

 Error I encountered the following error while attempting to deploy a BizTalk project using Visual Studio: Login failed for user "abc" Solution I faced this issue after downloading the project from Azure DevOps. Under the deployment tab of the project, an incorrect server name was specified, leading to the error. To resolve this problem, I followed these steps: I corrected the server name to the appropriate value. I attempted another deployment after making the necessary change. The deployment was successful without any further issues. By ensuring the correct server name was used, I was able to resolve the login failure error and proceed with the deployment smoothly. Please make sure that you change the server name in all the dependent projects as well.

 Introduction In this blog, I will provide a comprehensive guide on how to call a REST API that requires query parameters. We'll walk through the necessary steps to set up the environment and make successful API calls. Solution High Level Steps 1. API Overview: We will be using an open API for demonstration purposes. The API endpoint we'll be working with is: https://randomuser.me/api/?results=1 2. Schema Creation: Create a schema named "SourceA" that matches the structure of the messages you'll be dropping in the receive location. To create a JSON response schema, follow these steps: capture the JSON response by running a test in Postman, and then utilize a JSON schema generator to create the desired JSON schema. 3. Field Promotion: In the SourceA schema, promote the field called "results." This field will serve as the variable for the query parameter. 4. Receive JSON Pipeline: Develop a receive JSON pipeline that can receive JSON messages and convert t...

 Introduction In this blog, I am going to delve into the details of downloading SQL developer from Oracle website and installing it on our machine, and then connecting to an ATP database. Step by Step Guide Downloading SQL Developer from Oracle Website On the website, you will come across multiple versions of SQL Developer. Choose the appropriate version for your needs, then accept the license agreement and proceed to download the zip file. For reference, we have chosen the following version: https://www.oracle.com/database/sqldeveloper/technologies/download/ After downloading the zip file, extract its contents. Next, run the " sqldeveloper " application as an administrator. Creating a New Connection Click on the plus icon to create a new connection. Provide a name for the connection, such as " ATP ," and enter the corresponding username and password. Select the connection type as " Cloud Wallet " and click on the " Browse " button. Specify the p...