| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Managing Connections"
| Line 1: | Line 1: | ||
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 create new connections when required. | 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 create new connections when required. | ||
| + | |||
| + | ==Connecting to your data== | ||
One workbook can support multiple connections to different cubes or databases. Whenever XLCubed 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. | One workbook can support multiple connections to different cubes or databases. Whenever XLCubed 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. | ||
==Cube Connections== | ==Cube Connections== | ||
| − | + | <!--the following span is for the sidebar menu--><span id="Connection_Manager"> </span> | |
*To make a connection select {{Menu|XLCubed|Connections}} and press ''Add'' | *To make a connection select {{Menu|XLCubed|Connections}} and press ''Add'' | ||
| Line 35: | Line 37: | ||
===Custom OLEDB and ODBC connections=== | ===Custom OLEDB and ODBC connections=== | ||
| − | *Follow the instructions above, but select either | + | *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 | *Either type in a connection string or choose the Excel range which contains the connection string | ||
*Click the ''Connect'' button | *Click the ''Connect'' button | ||
Revision as of 16:59, 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.
Contents
[hide]Connecting to your data
One workbook can support multiple connections to different cubes or databases. Whenever XLCubed 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.
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
