Installation of SQL developer and connecting to ATP database using SQL developer

 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 path where your cloud wallet is located and select the service as "<abc>.high". Here, "abc" refers to the specific environment you are working with.



  • Click on the "Test" button to verify the connection.





  • Once the connection is successful, click on "Connect".

Accessing the ATP connection

  • Now you will see the ATP connection listed under "Oracle Connections."





  • Select "Individual Statements," and it will automatically populate a sample select statement for you. Feel free to experiment and run queries.


I hope this has been helpful. Happy coding!

Comments

Post a Comment

Popular posts from this blog

Error: Number of included segments do not match

Introduction In this blog, we tackle a crucial issue encountered during the reprocessing of an X12 EDI message. We will get into the root cause of the problem and provide you with a solution to overcome it. Error: An output message of the component "Unknown " in receive pipeline "Microsoft.BizTalk.Edi.DefaultPipelines.EdiReceive, Microsoft.BizTalk.Edi.EdiPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" is suspended due to the following error:       Error encountered during parsing. The X12 transaction set with id '103465910' contained in functional group with id '02', in interchange with id '000000009', with sender id '4532345856     ', receiver id '8038025150     ' is being suspended with following errors: Error: 1 (Miscellaneous error) 4: Number of included segments do not match . The sequence number of the suspended message is 1.  Root Cause: The issue stems from a mismatch in the number of se...
Read more

REST API Calls with Query Parameters in BizTalk: A Step-by-Step Guide

Image
 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...
Read more

EDI X12 Trading partner configuration in BizTalk

Image
 Introduction In this blog post, we will explore the process of setting up trading partner configuration in BizTalk. This involves creating parties, configuring agreements, and testing the solution. Let's dive into the details. Steps Creating parties in BizTalk To begin, we need to create two parties - one for our company and another for our trading partner. Let's start by creating the party for our company named "Vipin." Follow these steps: Connect to the BizTalk Admin console. Right-click on "Party" and select "New" -> "Party." Name the party as "Vipin" and click on OK Creating the party will also create the profile for you. Next, let's create the party for our trading partner, "ABCCompany" by following the same steps. Understanding the X12 File Now, in order to configure the agreement, we need to have a sample X12 EDI message that "ABCCompany" will be sending to our company, "Vipin." Let...
Read more