We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Dashboard Designer Data sources

Thread ID:

Created:

Updated:

Platform:

Replies:

142068 Jan 17,2019 09:23 AM UTC Jan 17,2019 12:49 PM UTC Dashboard Platform 1
loading
Tags: Dashboard Designer
William Niemand
Asked On January 17, 2019 09:23 AM UTC

Good day

I'm hoping someone can point me in the right direction.  I've been tasked to test out the Dashboard Server and Designer for my company.  I've tried to work through the documentation, but in many instances I'm not seeing the same functionality and UIs as referenced in the documentation.  The main issue I have at present is figuring out a way to connect to SQL and MySQL data sources respectively.  

I'm running the latest Dashboard trial on my work laptop.

In the designer datasource view I only see:
  • Amazon Redshift
  • MS SQL
  • PostgreSQL
How can I add MySQL to the available data sources? I already have a ODBC DSN set upon my localhost machine.  

The other issue we have is our company uses AD authentication for MS SQL.  So I can't use my normal username and password to connect to MS SQL.  It would have to be integrated security.  How can we setup a data source with integrated security?    

Any advice would be appreciated,
William

Rajavel Ramabalan [Syncfusion]
Replied On January 17, 2019 12:49 PM UTC

Hi William Niemand, 
 
Thank you for using Syncfusion products. 
 
Please find the responses for your queries. 
 
S. No 
Query 
Response 
In the designer datasource view I only see: 
  • Amazon Redshift
  • MS SQL
  • PostgreSQL
 
To have other data sources, you need to configure intermediate DB for extract mode support. Please find the procedure in the following help link to configure it. Once configure please refresh the designer page to reload available data sources.  
 
How can I add MySQL to the available data sources? I already have a ODBC DSN set upon my localhost machine.   
We did not include MySQL yet. We are working on it and will be available in our next public release. 
Our company uses AD authentication for MS SQL.  So I can't use my normal username and password to connect to MS SQL.  It would have to be integrated security.  How can we setup a data source with integrated security?     
Currently we have support for name and password Authentication only in web based dashboard designer. We will consider this as feature request,  
 
Let us know if you have any concerns on this. 
 
Regards, 
Rajavel R. 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon