Need information on data sources connectivity

other Xcelsius - Crystal Dashboard Design
1

HI All,

I am new to Xcelsius. Just need information what are the data sources we can connect through xcelsuis? how to conncet?

Can we connect MYSQL database through Xcelsuis?
Can we connect MS Access database?
Can we connect oracle databse?

Please let me know how to connect above sources. or you can provide me any documents.

Thanks,
Venkat

venkata_somisetty (BOB member since 2009-08-12)

2

Hi,

Data sources supported in Xcelcius2008 Enteprise are

BusinessObjects universes via Query As a Web Service, SAP BusinessObjects Web Intelligence and Crystal Reports via SAP BusinessObjects Live Office, Microsoft Excel 2003/2007, XML compliant databases, Microsoft SQL Server Reporting Services 2003, SOAP-based Web services, Adobe LiveCycle Data Services, Flash Variables

Bilahari

billu :india: (BOB member since 2009-11-09)

3

Thnk u Billu for your reply.

But i need information for my question.

Can we reach my requirement through xcelsius?

Thanks,
Venkat

venkata_somisetty (BOB member since 2009-08-12)

4

Hi venkata_somisetty,

Please check following thread on this…

xcelsius connectivity with mssql database

Bilahari

billu :india: (BOB member since 2009-11-09)

5

Yes, you can connect indirectly to all of those.

Various methods:

  1. via a Bob universe & QAAWS/liveoffice
  2. via flynet or similar
  3. via aspx or similar scripts that directly query database and return xml

These have all been discussed in this forum at great length. Just search and/or buy an xcelsius manual. That’s the way I learned.

debbie

Debbie :uk: (BOB member since 2005-03-01)

6

You can connect to any kind of data, however you either have to use a developed web service or model your database in a business objects universe.

Here is an example of calling a web service in Xcelsius. This is a simple example, you just need to access your database instead.

http://www.xcelsiusinfo.com/2010/03/03/beginners-guide-to-xcelsius-part-4/

ericvitale (BOB member since 2010-02-23)

7

Hello Venkat,

Using Flynet Web service generator you can connect to all of the above databases provided you have the Oledb or ODBC drivers installed on the machine where the Web service is to be hosted.

If you need further information you can contact us for a trial of the software.

Best Regards,

Ian Learmonth

ianlearmonth (BOB member since 2008-10-22)

8

Thanks to all for given indeed useful information.

Thanks,
Venkat

venkata_somisetty (BOB member since 2009-08-12)