Mashup FAQ - Frequently Asked Questions - Database
- What are some of the ways we can address the security issues and concerns related to enterprise mashups that leverage external data sources?
- Are you putting Excel in the cloud, when you say repository? Where is this Repository? Google Docs, SharePoint?
- How do you address data quality used in mashups? End users can misinterpret results.
- Can I use unstructured data and a type of input for a mashup?
- Did you do any data scrubbing from the legacy sources?
- Can services be prepared from pretty much any data source including fixed length text files?
- Can you show database integration?
- How the Mashups are being handled for different devices display capacity (PC, iPhone, Blackberries, etc)?
- How do you assess the accuracy or reliability of the source data. How do you know you aren't being fed false data? What ESB security are you using.
- A lot of these use cases seems to be very “read” centric. How many use cases are there for updates of information, and what facilities (if any) are available for assured delivery / “transaction coordination” of the data update?
- The value (and potential risk) of disparate information sources may be larger than the sum of the parts. (your competitive analysis pattern) Are there any design patterns (or tools) for service providers to understand how their information is being used (in perhaps anticipated ways).
- What about how reliable an external resource can be if it's not under your control? What if Google suddenly changes their api or interface or eliminates it?
- We cant use XML, a programming language that originated on the internet to give the information metadata, and then use RSS and other languages to stream the data via syndication into one data aggregator.
- Are the Presto services exposed to other systems such as OpenESB?
- Can Mashups pull specific portions from Seibel eCRM, both from Seibel portal and/or data inside Seibel (oracle database)?
- Can we mashup two different databases...like SQLServer and Siebel ? I mean is it dependent on a particular technology?
- Will it cost a whole bunch to connect to SAP systems?
- Excel "apps" that is scalable, maintainable and secure could be built with MOSS (Microsoft Office SharePoint Server) deployment and give the power to end user. Why should we embrace Mashup?
- Do you have connectors to sources such as OLAP cubes?
- Mashups seem well suited for information centric / lightweight BI applications, but how do these solutions evolve over time or provide enterprise capabilities for inclusion of more complex business logic, or support for business processes, rules, event processing, etc.
- I don't understand the BI, we know that excel is THE solution used by the business users to do their job. I have difficulties to see mashups helping in any way?!?
- Can mashups access historical data to show trending, or do aggregations for large volumes of data?
- Can you only pull live data in via XLS files, or from SOA, JDBC, API, etc. and if you can, how?
- What level of SOA maturity is required as a prerequisite for effective enterprise mashups?
