Difference between revisions of "Managing Connections"
(Added as2000 connection type) |
(→Custom Properties) |
||
| (32 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
| − | The '''Manage Connections''' form is available from the {{Menu| | + | The '''Manage Connections''' form is available from the {{Menu|FluenceXL|Connections}} ribbon item. It allows you to view, edit and delete existing connections for the workbook, and to create new connections when required. |
| − | + | ==Connecting to your data== | |
| − | One workbook can support multiple connections to different | + | One workbook can support multiple connections to different cubes or databases. Whenever FluenceXL detects you require a connection to a cube or database, you will have the opportunity to select an existing one or to create one as described below. |
| − | + | Any connections you have previously made will be displayed on the ''Recent Connections'' tab for easy access. | |
| − | + | To create a new connection open the Connection Manager from {{Menu|FluenceXL|Connections}} and select the ''New Connection'' tab. | |
| + | Here, choose the connection type and provide the appropriate detail. | ||
| − | === | + | ===Cube and Dimensional Connections=== |
| − | + | For cube and dimensional connection types you will need to specify the server or tenant address, and then select the the required database and cube ("database" and "cube" terminology will vary based on the connection type). | |
| − | [[Image: | + | [[Image:I4.png|450px|centre]] |
| − | + | ===Other Connections=== | |
| − | |||
| − | |||
| − | + | FluenceXL supports a wide variety of datasources including relational databases and big data providers. For these connection types you will typically only need to specify the Server or tenant address, and then the database which you want to connect to. | |
| − | + | ==Custom Properties== | |
| − | + | In the Manage Connections dialog, right click on a connection and you can set custom properties which will be applied in the connection string when the connection to the server is opened. | |
| − | |||
| − | |||
| + | From here you can also set up the query timeout to prevent long running queries from causing Excel to hang. This is applied to all grid and formula queries which use the connection. | ||
| − | [[ | + | [[File:ConnectionProp.PNG|400px|center]] |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| + | [[Category:Getting Started]] | ||
[[Category:Connections]] | [[Category:Connections]] | ||
Latest revision as of 17:08, 5 July 2023
The Manage Connections form is available from the FluenceXL > Connections ribbon item. It allows you to view, edit and delete existing connections for the workbook, and to create new connections when required.
Contents
[hide]Connecting to your data
One workbook can support multiple connections to different cubes or databases. Whenever FluenceXL detects you require a connection to a cube or database, you will have the opportunity to select an existing one or to create one as described below.
Any connections you have previously made will be displayed on the Recent Connections tab for easy access.
To create a new connection open the Connection Manager from FluenceXL > Connections and select the New Connection tab. Here, choose the connection type and provide the appropriate detail.
Cube and Dimensional Connections
For cube and dimensional connection types you will need to specify the server or tenant address, and then select the the required database and cube ("database" and "cube" terminology will vary based on the connection type).
Other Connections
FluenceXL supports a wide variety of datasources including relational databases and big data providers. For these connection types you will typically only need to specify the Server or tenant address, and then the database which you want to connect to.
Custom Properties
In the Manage Connections dialog, right click on a connection and you can set custom properties which will be applied in the connection string when the connection to the server is opened.
From here you can also set up the query timeout to prevent long running queries from causing Excel to hang. This is applied to all grid and formula queries which use the connection.
