Showing posts with label Toad. Show all posts
Showing posts with label Toad. Show all posts

Connect to IBM DB2 Database Using Toad

We can use Toad to explore the DB2 Database Structures. Before using Toad we need to configure IBM DB2. To configure it open the Configuration Assistant as shown in the below figure.


Then you will get a window as shown below. Select TCP/IP as the Protocol and click Next.


After that we have to provide the details of the Host and the Service.


Insert those information and click on Retrieve button to get the Port Number.


Then follow the instructions as shown in below figures.


Then launch the Toad for DB2 as shown in the below figure.


After that create a new connection right click on the Connection Manager and select Create as in the below figure.


Then you will get a window as shown below.


You can see the available databases in the Database alias.


Then provide login details and the category.

tablename_WriteToDataDestination: Mashup Exception Data Source Error Couldn't refresh the entity...

 Once a Dataflow is created and published on Fabric, got the below error while refreshing the Dataflow. tablename_ WriteToDataDestination: M...