Skip to Content
0

​Can Crystal Dashboards be connected to SQL Server directly?

Jun 13, 2017 at 06:06 PM

39

avatar image
Former Member

Can Crystal Dashboards be connected to SQL Server directly without having to create a universe? And not through Data connection in Excel?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mike Taylor Jun 13, 2017 at 09:57 PM
0

No, the most common way is to use ASP to convert your SQL query into a simple XML format. Unfortunately there isn't an "SQL" direct connection.

Here is a tutorial with an ASP script. You just make the file and set the connection credentials and query and it should output your XML. Then you pick this up from CDD.

https://xcelsius.files.wordpress.com/2008/05/xml_data_button.pdf

Mike

http://youtube.battleshipcobra.com/

Share
10 |10000 characters needed characters left characters exceeded