Microsoft SQL SDT - BI for Visual Studio 2013

Microsoft SQL SDT - BI for Visual Studio 2013

Postby Zanon » Tue 13 Jan 2015 19:52

Hi,
in our new development environment we:
in result we have dotConnect in "Analysis Services" but not in "Reporting services".

After following part of procedure described in : http://forums.devart.com/viewtopic.php?t=14895 especially for the conf files RSPreviewPolicy.config and RSReportDesigner.config the dotConnect option appear in the designer under "Shared Data Sources" but if you do some reports, the preview does not working giving some error like : "An attempt has been made to use a data extension Devart.Data.MySql that is either not registered for this report or is not supported"
could you give us some hints what else we could do to fix this ?
Zanon
 
Posts: 3
Joined: Tue 13 Jan 2015 19:33

Re: Microsoft SQL SDT - BI for Visual Studio 2013

Postby Pinturiccio » Thu 15 Jan 2015 15:18

Unfortunately, SSDT-BI for Visual Studio 2013 is currently not supported. We will notify you when the corresponding support is implemented.
As a temporary workaround, please use the dotConnect for MySQL SSIS components in VS 2008, 2010, or 2012.
Pinturiccio
Devart Team
 
Posts: 1891
Joined: Wed 02 Nov 2011 09:44

Re: Microsoft SQL SDT - BI for Visual Studio 2013

Postby Zanon » Tue 20 Jan 2015 21:37

Hi ,
we just made a fresh installation of:
MS SDT-BI FOR VISUAL STUDIO 2012 ( SSDTBI_VS2012_x86_ENU.exe )
on : MS Windows standard 2012 r2 .
After restart we installed newly released drivers: dcmysql83pro-8.3.333.exe
everything works except entire SSRS section.

After manual intervention and adding:
Code: Select all
         <CodeGroup
               class="UnionCodeGroup"
               version="1"
               PermissionSetName="FullTrust"
               Name="Devart.Data.MySql"
               Description="Code group for Devart.Data.MySql.ReportingServices data processing extension">
            <IMembershipCondition
               class="UrlMembershipCondition"
               version="1"
               Url="C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\Devart.Data.MySql.ReportingServices.dll"
            />
         </CodeGroup>
just before line
Code: Select all
</PolicyLevel>
in file :
Code: Select all
c:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\RSReportDesigner.config

and adding
Code: Select all
<Extension Name="Devart.Data.MySql" Type="Devart.Data.MySql.ReportingServices.MySqlConnectionWrapper, Devart.Data.MySql.ReportingServices, Version=8.3.333.2, Culture=neutral, PublicKeyToken=09af7300eec23701" />
to section [DATA] and
Code: Select all
<Extension Name="Devart.Data.MySql" Type="Devart.Data.MySql.ReportingServices.Design.MySqlQueryDesigner, Devart.Data.MySql.ReportingServices.Design, Version=8.3.333.2, Culture=neutral, PublicKeyToken=09af7300eec23701" />
to section [Designer] in file
Code: Select all
c:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\PrivateAssemblies\RSPreviewPolicy.config

SSRS part looks like working .
my 3 questions comming from this point are:
    1. What is correct value for PublicKeyToken ? i just copy something i have read somewhere.
    2. When you are going to implement this manual procedure in your installation scripts ?
    3. When we are going to have full support for MSSQL 2014 and according SSDT-BI for VS2013

Regards
p.s. don't get my posts as offense. dotConnect is really great product!!! we just like to be on the edge of technology :)
Zanon
 
Posts: 3
Joined: Tue 13 Jan 2015 19:33

Re: Microsoft SQL SDT - BI for Visual Studio 2013

Postby Pinturiccio » Mon 26 Jan 2015 16:26

Zanon wrote:1. What is correct value for PublicKeyToken ? i just copy something i have read somewhere.

PublicKeyToken is 09af7300eec23701

Zanon wrote:everything works except entire SSRS section.

Zanon wrote:2. When you are going to implement this manual procedure in your installation scripts ?

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Zanon wrote:3. When we are going to have full support for MSSQL 2014 and according SSDT-BI for VS2013

We are investigating the issue and will notify you about the result as soon as possible, but we can't tell any timeframe at the moment.
Pinturiccio
Devart Team
 
Posts: 1891
Joined: Wed 02 Nov 2011 09:44

Re: Microsoft SQL SDT - BI for Visual Studio 2013

Postby Shalex » Wed 25 Mar 2015 14:07

The new build of dotConnect for MySQL will include the following improvements:
  • Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
  • SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013
We will notify you when the corresponding build is available for download.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: Microsoft SQL SDT - BI for Visual Studio 2013

Postby Shalex » Thu 26 Mar 2015 17:34

New build of dotConnect for MySQL 8.3.379 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=2&t=31497.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: Microsoft SQL SDT - BI for Visual Studio 2013

Postby Zanon » Wed 03 Jun 2015 09:59

GREAT :)
thank you sooo much . you made my day :)
Zanon
 
Posts: 3
Joined: Tue 13 Jan 2015 19:33


Return to dotConnect for MySQL