Progress v9.1C database connection for SQL Server 2005 ETL-tool

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

plupos - 10 Apr 2006 10:44 GMT

Hello,

I'm evaluation SQL Server 2005 to use it as an ETL-tool. We need to connect
to a Progress v9.1C database as datasource. SQL Server 2005 operates on the
.NET platform, I'm not aible to connect to progress from the datasource tab
in the ETL-tool part of SQL Server 2005 (there is no ADO.NET or OLE-DB
connection availble). Could you please help me to solve this problem?

Greetings,
Paul Siteur

Vriendelijke groet,
Paulus

Paul Siteur
IBN-groep
ICT Applicatiebeheerder / Cognos ontwerper

Hockeyweg 5
5405 NC Uden
tel. 0413-33 44 37
e-mail psiteur@ibn-groep.nl
www.ibn-groep.nl

Reply to this Message

Tim Dot NoSpam - 08 May 2006 12:48 GMT

If Progress has an ODBC client, install it on the machine you'll run
Integration services from (that's your development machine and the
deployment server) and use the OLEDB connection for ODBC as your data
source.

> Hello,
>
[quoted text clipped - 22 lines]
> e-mail psiteur@ibn-groep.nl
> www.ibn-groep.nl

Reply to this Message