Dear All,

Has anyone had experience of using SQLServer Reporting Services and
Ingres databases. We have traditionally used Ingres (just completed the
upgrade to Ingres 2006), but a few years ago SQLServer was introduced
because we couldn't run some third party software on Ingres.
Unfortunately, we're increasingly using SQLServer as we are buying more
applications than we used to, rather than building our own. In addition
our development tools are predominantly MS - VB/.NET etc and our
developers perceive SQLServer to be a better DBMS than Ingres. Recently
we started looking at SQLServer Reporting Services (SSRS). SSRS looks
very attractive to our developers and they are claiming that the lack of
an OLEDB data provider for Ingres means that SSRS works much better with
SQLServer than Ingres because of the limitations of ODBC. However,
reading the MS blurb shows SSRS can use .NET data providers as well as
OLEDB and ODBC. I'm under great pressure to use SQLServer rather than
Ingres for new developments, which in turn will eventually lead to a
head of steam to migrate our existing Ingres databases from Ingres to
SQLServer.

I don't think I can face being a being solely a SQLServer DBA.

Has anyone any experience of SSRS with Ingres ? In particular I'd like
to understand what the limitations are of using SSRS and Ingres and
whether the Ingres .NET data provider can be used with SSRS.

Many Thanks

Tony

Try some experiments with the Ingres .NET Data Provider 2.0 in the
Ingres2006 Release 2 download at
http://www.ingres.com/downloads/prod-cert-download.php.

Dave

"Tony Phillips" <TonyP@blahblah.co.uk> wrote in message
news:468A77F2.5070604@blahblah.co.uk...
> Dear All,
>
> Has anyone had experience of using SQLServer Reporting Services and
> Ingres databases. We have traditionally used Ingres (just completed the
> upgrade to Ingres 2006), but a few years ago SQLServer was introduced
> because we couldn't run some third party software on Ingres.
> Unfortunately, we're increasingly using SQLServer as we are buying more
> applications than we used to, rather than building our own. In addition
> our development tools are predominantly MS - VB/.NET etc and our
> developers perceive SQLServer to be a better DBMS than Ingres. Recently
> we started looking at SQLServer Reporting Services (SSRS). SSRS looks
> very attractive to our developers and they are claiming that the lack of
> an OLEDB data provider for Ingres means that SSRS works much better with
> SQLServer than Ingres because of the limitations of ODBC. However,
> reading the MS blurb shows SSRS can use .NET data providers as well as
> OLEDB and ODBC. I'm under great pressure to use SQLServer rather than
> Ingres for new developments, which in turn will eventually lead to a
> head of steam to migrate our existing Ingres databases from Ingres to
> SQLServer.
>
> I don't think I can face being a being solely a SQLServer DBA.
>
> Has anyone any experience of SSRS with Ingres ? In particular I'd like
> to understand what the limitations are of using SSRS and Ingres and
> whether the Ingres .NET data provider can be used with SSRS.
>
> Many Thanks
>
> Tony
>

Tony,



Just finished a MS course on Reporting Services and it's a powerful reporting tool our developers like it.



Our experience so far



We have ingres2006-9.1.0-123-com-win-x86-DotNet installed.



We can define Ingres connections in Server Explorer within Visual Studio, see tables etc, but unable to see the Ingres .Net Data provider as an option when we try to define a shared data source in Reporting Services. I don't think its a limitation of the Ingres data provider or Visual Studio, just Reporting Services, as VS can see the Ingres data provider, I may be wrong!. I'm going to trawl the MS forums to see it if anyone else mentions issues with 3rd party database integration with RS.



We have to use ODBC to connect to Ingres databases when using Reporting Services.



Another option we have tried is using web services to provide the data from Ingres which does work but in practice not very efficient.



If anyone knows different, please let us know.



Tony, your comments I can relate too.



Regards



Nigel.





________________________________

From: info-ingres-bounces@kettleriverconsulting.com on behalf of Tony Phillips
Sent: Tue 7/3/2007 5:23 PM
To: info-ingres@kettleriverconsulting.com
Subject: [Info-Ingres] Ingres and SSRS



Dear All,

Has anyone had experience of using SQLServer Reporting Services and
Ingres databases. We have traditionally used Ingres (just completed the
upgrade to Ingres 2006), but a few years ago SQLServer was introduced
because we couldn't run some third party software on Ingres.
Unfortunately, we're increasingly using SQLServer as we are buying more
applications than we used to, rather than building our own. In addition
our development tools are predominantly MS - VB/.NET etc and our
developers perceive SQLServer to be a better DBMS than Ingres. Recently
we started looking at SQLServer Reporting Services (SSRS). SSRS looks
very attractive to our developers and they are claiming that the lack of
an OLEDB data provider for Ingres means that SSRS works much better with
SQLServer than Ingres because of the limitations of ODBC. However,
reading the MS blurb shows SSRS can use .NET data providers as well as
OLEDB and ODBC. I'm under great pressure to use SQLServer rather than
Ingres for new developments, which in turn will eventually lead to a
head of steam to migrate our existing Ingres databases from Ingres to
SQLServer.

I don't think I can face being a being solely a SQLServer DBA.

Has anyone any experience of SSRS with Ingres ? In particular I'd like
to understand what the limitations are of using SSRS and Ingres and
whether the Ingres .NET data provider can be used with SSRS.

Many Thanks

Tony

_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres

Hi Nigel,

Thanks for the reply. Our software people are going to start the
install of SSRS for our production system soon, so anything you find
would be useful. I did put a post on the msdn forum for SSRS and the
only reply I receieved include the following link:

http://msdn2.microsoft.com/en-us/library/ms159219.aspx

which looks to be the place this is done, but lacks detail.

I haven't tried emailing Ingres Corp. to see if they have any advice -
I'll try that in a day or two. Unfortunately, I'm on a 5 day oracle
course next week (things are going from bad to worse !!).

Regards

Tony



Nigel J Kavanagh wrote:
> Tony,
>
>
>
> Just finished a MS course on Reporting Services and it's a powerful
> reporting tool our developers like it.
>
>
>
> Our experience so far
>
>
>
> We have ingres2006-9.1.0-123-com-win-x86-DotNet installed.
>
>
>
> We can define Ingres connections in Server Explorer within Visual
> Studio, see tables etc, but unable to see the Ingres .Net Data provider
> as an option when we try to define a shared data source in Reporting
> Services. I don't think its a limitation of the Ingres data provider or
> Visual Studio, just Reporting Services, as VS can see the Ingres data
> provider, I may be wrong!. I'm going to trawl the MS forums to see it if
> anyone else mentions issues with 3rd party database integration with RS.
>
>
>
> We have to use ODBC to connect to Ingres databases when using Reporting
> Services.
>
>
>
> Another option we have tried is using web services to provide the data
> from Ingres which does work but in practice not very efficient.
>
>
>
> If anyone knows different, please let us know.
>
>
>
> Tony, your comments I can relate too.
>
>
>
> Regards
>
>
>
> Nigel.
>
>
>
>
>
> ------------------------------------------------------------------------
> From: info-ingres-bounces@kettleriverconsulting.com on behalf of Tony
> Phillips
> Sent: Tue 7/3/2007 5:23 PM
> To: info-ingres@kettleriverconsulting.com
> Subject: [Info-Ingres] Ingres and SSRS
>
> Dear All,
>
> Has anyone had experience of using SQLServer Reporting Services and
> Ingres databases. We have traditionally used Ingres (just completed the
> upgrade to Ingres 2006), but a few years ago SQLServer was introduced
> because we couldn't run some third party software on Ingres.
> Unfortunately, we're increasingly using SQLServer as we are buying more
> applications than we used to, rather than building our own. In addition
> our development tools are predominantly MS - VB/.NET etc and our
> developers perceive SQLServer to be a better DBMS than Ingres. Recently
> we started looking at SQLServer Reporting Services (SSRS). SSRS looks
> very attractive to our developers and they are claiming that the lack of
> an OLEDB data provider for Ingres means that SSRS works much better with
> SQLServer than Ingres because of the limitations of ODBC. However,
> reading the MS blurb shows SSRS can use .NET data providers as well as
> OLEDB and ODBC. I'm under great pressure to use SQLServer rather than
> Ingres for new developments, which in turn will eventually lead to a
> head of steam to migrate our existing Ingres databases from Ingres to
> SQLServer.
>
> I don't think I can face being a being solely a SQLServer DBA.
>
> Has anyone any experience of SSRS with Ingres ? In particular I'd like
> to understand what the limitations are of using SSRS and Ingres and
> whether the Ingres .NET data provider can be used with SSRS.
>
> Many Thanks
>
> Tony
>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres@kettleriverconsulting.com
> http://www.kettleriverconsulting.com...fo/info-ingres
>
>
> ------------------------------------------------------------------------
>
> ************************************************** ***************************************
> To view the terms under which this email is distributed, please go to http://www.hull.ac.uk/legal/email_disclaimer.html
> ************************************************** ***************************************