It is possible to link data connections together. This can have the following benefits.
...
There are use cases for linked data connections to be used within a single Organisation, however it is often used in conjunction with Organisations to provide additional security.
How to tell if my data connection is linked?
When you open a linked data connection, if you notice that a table has a hashed line around it then this table is from the linked data connection.
...
These objects also come from the ‘parent’ data connection so cannot be edited or deleted here.
...
If you see such a structure this is the first indication that you are working on a linked data connection or a ‘child’ connection.
If you now look at the connection tab,
...
We can’t see any of connection details. If we want to change any of the specifics about the connection to the database then we would have to edit the parent data connection. In this example that is a connection called Ad Spend. You may not be allowed to edit the parent, and the parent may even be in another organisation.
Creating a Linked Data Connection
The parent data connection is created and maintained as any other data connection. When you decide that you want this data connection to become a parent data connection, you tick the ‘Can Have Child Connections’ box on the Connection screen.
...
| Note |
|---|
Always make sure you do join your tables back to the content of the main data connection. If the admin in the parent connection creates a user restriction for you, all your queries will fail with a SQL error (this is intended) until you link back to the main structure. |
Exporting / Import A Child Connection
You cannot currently export / import child connections.
Using a Child Data Connection
It makes no difference to the user in the Edit Chart screen, the child data connection is presented to the user, without making them aware of which objects come from the parent and which from the child.
Linked Data Connections + Organisations
If we are giving one of our tenants the ability to create data connections then we probably do not want to.
...
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
It is very important that all of the security related details are configured in the top level organisation. |
Worked Example
I have my 2 organisations - Organisation 1 is the Owning Organisation.
...