| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
SQL Data Tables (Administrators)
Revision as of 18:17, 16 March 2012 by Antonio.remedios (talk | contribs) (Created page with "XLCubed can query your relational databases directly. Similar to Grids, the relational query can be seamlessly built into an interactive report using [[Relational Slice...")
XLCubed can query your relational databases directly. Similar to Grids, the relational query can be seamlessly built into an interactive report using Relational Slicers and dynamic Excel ranges.
Inserting a Relational Data Table
- Select the XLCubed > Insert Data Table > SQL... button from the XLCubed ribbon.
- Select the type of connection you want to create - for this example we are using Microsoft SQL Server:
- Type the server name and select the authentication type with which to connect.
- Click Connect and you should then see all the databases on the server to which you have access. Select the desired database and click OK to continue.
- Select the destination cell for your statement and then build up your query by dragging tables and views into the main tab.
- As you pick the fields you will see the SQL statement build up in the lower half of the screen. You may also type the SQL statement directly. Click OK when finished.
- The relational table will be inserted at the point you selected.
See Also
- Query Tables for a similar feature in XLCubed 6.5 and previous versions.
