Microsoft SQL SDT - BI for Visual Studio 2013

[Zanon]

Hi,
in our new development environment we:

• 1. installed Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 from http://www.microsoft.com/en-us/download ... x?id=42313 on standard windows 2012r2.
  
  2. restarted server
  
  3. installed dotConnect for MySQL professional version 8.3.313

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 ?

[Pinturiccio]

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.

[Zanon]

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

[Pinturiccio]

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

PublicKeyToken is 09af7300eec23701

everything works except entire SSRS section.

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.

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.

[Shalex]

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]

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.

[Zanon]

GREAT
thank you sooo much . you made my day