Connection issue - SAP DataSphere

[kirankumar440]

Hello All,

The connections (The trail system for DataSphere ) gives error when I try to expand it in the – Graphical CV Editor

The same connections are working fine , in the DataFlow creation Editor .

Could you please explain , why ?

Thanks

Kiran

[TuncayKaraca]

Hi Kiran,

You can use the objects from connection data source while creating a graphical view. These objects would be remote tables, even if you drag & drop the object into the graphical editor view the object/table first will be imported into SAP Datasphere as a remote table then you can use it as a remote table in the graphical view. It will be same as you go Data Builder > Import Remote Tables from the connection and use it later in the graphical view.

You got error and probably the connection you are using is enable for Remote Tables! You are able to use the connection for Data Flows since it's enabled for Data Flows.  Go to Connections > Edit > Features and see enabled the functionality of the connection. 

Regards,
Tuncay

[RamSubramaniyan]

TuncayKaraca - Thanks for elaborating. So, to be able to use objects from Source > Connections directly in the View builder, the following are pre-requisites.

- Remote table connection should exist to be able to use/import remote tables. Eventually, remote tables will be deployed

- 'Remote Tables' in Connection > Features should be Enabled

Regards, Ram

[kirankumar440]

Thanks Tuncay for the clarification. So thats a trail system which in the control of SAP , So now how can proceed further if we want to consume them our hands on exercises, I think we will not have access to Edit the connection properties ?

[TuncayKaraca]

@RamSubramaniyan Yes, your summary is correct.

[TuncayKaraca]

@kirankumar440You are welcome. I don't know about the trail system.  You can create local tables and use then in the graphical view. You can create data flow to read data from the connection and put data into the local table.

[RamSubramaniyan]

Hello!

When you are attempting to build a View (graphical / SQL), I think we dont intend to see source system connections within 'Connections' as you would see in a Data flow builder. Intent of usage of Views is different to why one would use Rep. or Data Flows.

In my case, I dont see any options under 'Sources > Connections' to connect to the source objects directly because the idea is that a View is built on top of deployed local tables(and remote tables, views if you will) present in the 'Repository'

At least, I dont see a connection error but I think in your case it may be an intermittent issue in the Guided Experience edition. So, please consider building views based on your repo. objects within Datasphere.

Experts can add / clarify if required.

[TuncayKaraca]

@RamSubramaniyan @kirankumar440 You can use the tables from the connections in the graphical view but it will be imported as a remote table first.