| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Managing Connections"
(Added as2000 connection type) |
(Added relational db information) |
||
| Line 1: | Line 1: | ||
| − | The '''Manage Connections''' form is available from the {{Menu|XLCubed|Connections}} ribbon or menu item. | + | The '''Manage Connections''' form is available from the {{Menu|XLCubed|Connections}} ribbon or menu item. It allows you to view, edit and delete existing connections for the workbook, and to [[Creating Connections|create new connections]] when required. |
| − | + | One workbook can support multiple connections to different cubes or databases. | |
| − | + | ==Cube Connections== | |
| − | + | *To make a connection select {{Menu|XLCubed|Connections}} and press ''Add'' | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | *To make a connection select XLCubed | ||
[[Image:I5.png|20px|left]] | [[Image:I5.png|20px|left]] | ||
| Line 25: | Line 19: | ||
:: ''Analysis Services Cube file:'' Browse to locate the local cube file | :: ''Analysis Services Cube file:'' Browse to locate the local cube file | ||
:: ''XLCubed Connection:'' Type the URL of the XLCubed Web Edition server to connect to | :: ''XLCubed Connection:'' Type the URL of the XLCubed Web Edition server to connect to | ||
| − | |||
[[Image:I4.png|350px|centre]] | [[Image:I4.png|350px|centre]] | ||
| − | |||
*Once connected, select the required database on the left, then select relevant cube on the right to add the connection. | *Once connected, select the required database on the left, then select relevant cube on the right to add the connection. | ||
* Add additional connections to the workbook as required. | * Add additional connections to the workbook as required. | ||
| + | |||
| + | ==Database Connections== | ||
| + | |||
| + | *To make a new relational connection select {{Menu|XLCubed|Connections}}, switch to the {{Menu|Database Connections}} tab and select ''Add'' | ||
| + | *Select the server type from the first dropdown, then enter the server name in the next box (or select the file for Access connections) | ||
| + | *If necessary, enter the log in details, then click the ''Connect'' button | ||
| + | *Select the database from the list | ||
| + | |||
| + | ===Custom OLEDB and ODBC connections=== | ||
| + | |||
| + | *Follow the instructions above, but select either {{Menu|Custom OLEDB Connection}} or ''Custom ODBC Connection'' from the first dropdown as appropriate | ||
| + | *Either type in a connection string or choose the Excel range which contains the connection string | ||
| + | *Click the ''Connect'' button | ||
| + | *Select the database from the list | ||
==See Also== | ==See Also== | ||
Revision as of 16:40, 12 August 2014
The Manage Connections form is available from the XLCubed > Connections ribbon or menu item. It allows you to view, edit and delete existing connections for the workbook, and to create new connections when required.
One workbook can support multiple connections to different cubes or databases.
Contents
[hide]Cube Connections
- To make a connection select XLCubed > Connections and press Add
- The display shows any recent connections, which can quickly be re-used by selecting and pressing OK
- For a new connection, select the New Connection tab, choose the server type and specify the appropriate detail as below:
- Analysis Services Server: Type the server name
- Analysis Services Server 2000: Type the AS2000 server name
- Analysis Services Cube file: Browse to locate the local cube file
- XLCubed Connection: Type the URL of the XLCubed Web Edition server to connect to
- Once connected, select the required database on the left, then select relevant cube on the right to add the connection.
- Add additional connections to the workbook as required.
Database Connections
- To make a new relational connection select XLCubed > Connections, switch to the Database Connections tab and select Add
- Select the server type from the first dropdown, then enter the server name in the next box (or select the file for Access connections)
- If necessary, enter the log in details, then click the Connect button
- Select the database from the list
Custom OLEDB and ODBC connections
- Follow the instructions above, but select either Custom OLEDB Connection or Custom ODBC Connection from the first dropdown as appropriate
- Either type in a connection string or choose the Excel range which contains the connection string
- Click the Connect button
- Select the database from the list
