Skip to Content
avatar image
Former Member

​Can Crystal Dashboards be connected to SQL Server directly?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 13, 2017 at 09:57 PM

    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/

    Add comment
    10|10000 characters needed characters exceeded