Hello, we're looking to test ReportNet against a Manufacturing application written in Progress 4GL. To connect to Progress we will use an ODBC from Datadirect (I'm not sure what version yet ...). I'd like to know if one of you have some experience with Progress and ReportNet ? And if they want to share some of their experiences. We have applications like Progress Webspeed, Progress OpenEdge and others. My concern about Progress is the ODBC. I'm talking about record locking, SQL, performance ... Thanks! Regards, Steve
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cognos ReportNet with Progress Database 9.1d via ODBC
- Thread starter stevev
- Start date
Stevev,
Welcome to Cognos Solutions forum.
I can offer some experience in a similar situation to yours; I report against a Progress 9.1d DB using Cognos and ODBC. However, it is an Openlink driver, rather than Datadirect. We had some fun in setting it up, due to our boxes working as a cluster and the need to link the libraries.
The good feature about Progress and the Openlink driver is that I can run one report against two progress databases.
However, there are some limitations of the driver in comparison to that of Progress, although few that have limited reporting. The main gripe I have is that I cannot have both outer joins and equi-joins in the same report. To get around this, I stage data in a SQL server datamart (more a datacart).
That notwithstanding, I can recommend Openlink in light of their excellent support.
You'll find that the speed of ODBC in comparison to Progress is somewhat disappointing, but then I'm sure that won't come as a great surprise.
I'm afraid I can't comment on ODBC & record locking, as I use a side-ways copy of the trading data. This is due to our having record locking issues with our trading system - not written in the most efficient manner, I guess.
You might get some feedback in the Progress forum (but perhaps you've already posted there....)
lex
soi la, soi carré
Welcome to Cognos Solutions forum.
I can offer some experience in a similar situation to yours; I report against a Progress 9.1d DB using Cognos and ODBC. However, it is an Openlink driver, rather than Datadirect. We had some fun in setting it up, due to our boxes working as a cluster and the need to link the libraries.
The good feature about Progress and the Openlink driver is that I can run one report against two progress databases.
However, there are some limitations of the driver in comparison to that of Progress, although few that have limited reporting. The main gripe I have is that I cannot have both outer joins and equi-joins in the same report. To get around this, I stage data in a SQL server datamart (more a datacart).
That notwithstanding, I can recommend Openlink in light of their excellent support.
You'll find that the speed of ODBC in comparison to Progress is somewhat disappointing, but then I'm sure that won't come as a great surprise.
I'm afraid I can't comment on ODBC & record locking, as I use a side-ways copy of the trading data. This is due to our having record locking issues with our trading system - not written in the most efficient manner, I guess.
You might get some feedback in the Progress forum (but perhaps you've already posted there....)
lex
soi la, soi carré
- Thread starter
- #3
Hello drlex,
thanks for the reply. We are looking at different kind of solution. Cognos has release with ReportNet an engine called Composite Software, look . So we may look at this solution to extract information from our Progress database and use it in ReportNet. I'll keep you updated when we start our testing ...
Regards, steve V.
thanks for the reply. We are looking at different kind of solution. Cognos has release with ReportNet an engine called Composite Software, look . So we may look at this solution to extract information from our Progress database and use it in ReportNet. I'll keep you updated when we start our testing ...
Regards, steve V.
- Status
Similar threads
- Locked
- Question
- Locked
- Question