logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Database access on public web server?
Options View
Previous Topic Next Topic
mcapozzi
#1 Posted : Tuesday, February 14, 2012 11:54:11 PM(UTC)
Rank: Newbie

Groups: Registered, Customer
Joined: 2/14/2012(UTC)
Posts: 3
Location: Sayville
Hello,
I just purchased the pro version of DD. For some reason I can't post on the Premium boards (not sure what links the two if not simply email address), so I'm posting here!

I was wondering: When I deploy DD as an ASP.NET web application, I notice that I will need database connectivity directly from the public web server. Most of my users don't find that acceptable, so I end up having to create a separate ASP.NET web service to handle all of my database calls. Then, I put the web service inside of the firewall and the public website out in the DMZ. Everyone is happy. What can be done with DD to allow users to see dashboards, but not allow access to their database? Is this even possible?

Thanks!

-Mike-
Back to top
berkay
#2 Posted : Wednesday, February 15, 2012 9:45:34 AM(UTC)
Rank: Advanced Member

Groups: Registered, Administrators
Joined: 6/8/2011(UTC)
Posts: 168
Location: Turkey

Was thanked: 6 time(s) in 6 post(s)
Hello Michael,

Firstly , i promoted your forum account to premium.

DD can not be access metadata over web service. You should access from public web server.

But i suggest to encrypt connection string.

you can view from here

Regards.

Berkay ERKOY
Development & Support Team
www.dynamicdashboards.net
Back to top
WWW
mcapozzi
#3 Posted : Wednesday, February 15, 2012 4:15:50 PM(UTC)
Rank: Newbie

Groups: Registered, Customer
Joined: 2/14/2012(UTC)
Posts: 3
Location: Sayville
berkay;2214 wrote:
Hello Michael,

Firstly , i promoted your forum account to premium.

DD can not be access metadata over web service. You should access from public web server.

But i suggest to encrypt connection string.

you can view from here

Regards.



Berkay,

Thanks! After much thinking I realized that it would probably make sense to simple create a local access database or install SQLExpress on a server inside the network that the web server can access for DD and it's metadata. Then, for any critical database production server, I can simply still make the web service to make calls to the relevant data.

-Mike-
Back to top
berkay
#4 Posted : Wednesday, February 15, 2012 8:29:26 PM(UTC)
Rank: Advanced Member

Groups: Registered, Administrators
Joined: 6/8/2011(UTC)
Posts: 168
Location: Turkey

Was thanked: 6 time(s) in 6 post(s)
You are welcome.

Regards.
Berkay ERKOY
Development & Support Team
www.dynamicdashboards.net
Back to top
WWW
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


This page was generated in 0.061 seconds.