How to Write a Cross-Connection Query Correctly

Blog Posts
1

Apr 15, 2019 3:39:13 PM by Winnie Wu

This is a companion discussion topic for the original entry at https://blog.toadworld.com/how-to-write-a-cross-connection-query-correctly#
2

@Winnie.Wu, hello!

Hope you're doing great despite the current COVID19 situation.

Came across your blog post while searching for a way to use Toad for Oracle to query data from SAP HANA, so hope you can answer my question in relation to cross-connection query: can this be done using Toad for Oracle v.10.5.1.3? I need to query data from SAP HANA, what is the correct syntax for this, especially for SAP HANA connection?

Thanks in advance!

4

Hi @lesliematura
This article is only for Toad Data Point cross-query, it doesn't apply for Toad for Oracle. I am not familiar with Toad for Oracle, but as I know, Toad Data Point also supports "SAP HANA connection", if you need any information about "using TDP to connect to HANA", please feel free to ask your question on this forum, thanks.

1 Like
5

Hey thanks so much @Winnie.Wu! I'll check if we have Toad Data Point from our software center to download it, it will surely be very useful for us :ok_hand: :+1:

6

Hi lesliematura,
You're welcome. :grinning: