Today, we use the following tools/methods for reporting: SAS and all off it's flavors of access, Tableau against Oracle data, excel against SQL server and SSAS cubes.
We are looking into purchasing an appliance to house millions of rows of transaction data for a New Project. It looks like the appliance we might go with is Exadata .
What I would like know is whether SQL server, cubes and Excel work or don't work with Exadata. Like for example:
- how well can we do pass-through for SQL server tables and cubes
- Can excel directly access the Exadata appliance
My point in all of this is to see how we would leverage an appliance in our reporting team.
I appreciate your reply. Thanks!