 |
|
|
|
Next: IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B..
|
| Author |
Message |
External
Since: May 22, 2006
Posts: 16
|
(Msg. 1) Posted: Fri Aug 15, 2008 8:49 am
Post subject: SSIS package Informix to SS 2005
Archived from groups: microsoft>public>sqlserver>odbc (more info?)
|
|
|
Hello -
We are running Sql Server 2005 in a Windows Server 2003 environment.
I have been unable to create an SSIS package to copy four tables from an
Informix database; nor am I able to manually import from this DB. This is a
DB created by Avaya and they gave me an OpenLink ODBC driver which does not
work for this. I keep getting a licensing error complaining about not having
an ole license. I have contacted both OpenLink and Avaya on numerous
occasions and have run into a bunch of morons.
I can, however create a connection and see all of the tables in BIDS. I can
also import the tables into Access. I need to delete the tables and
re-import them daily. Any suggestions on how to do this will be greatly
appreciated!
(Also, I'm curious that the only DB sources are DataReader, Excel, Flat
File, OLE DB, Raw File and XML. I don't quite understand why BIDS doesn't
have an ODBC DB Source.)
Again, any help will be greatly appreciated!
--
Sheldon |
|
| Back to top |
|
 | |
|
OpenLink Technical Suppor
|
External
Since: Aug 19, 2008
Posts: 2
|
(Msg. 2) Posted: Tue Aug 19, 2008 1:48 am
Post subject: RE: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Sheldon,
First, I feel the need to explain the situation --
You are using Avaya CMS and, along with it, an OEMed version of the OpenLink
Multi-tier ODBC Driver for Informix.
As I said this is an OEMed product and as such comes with restrictions --
i) It is licensed solely for use with Avaya's CMS application and
therefore your use of it with any other ODBC client application is in breach
of this license agreement and therefore illegal.
That is - if you are using the driver via SSIS, Access, Excel, etc,
etc, or any other non-Avaya CMS ODBC application then you are using the
driver illegally.
ii) Avaya themselves are your point of contact for technical support for
this product.
OpenLink would be more than happy to assist but this would require you to
evaluate and purchase a non-OEMed version of the driver with the license
restrictions (above) removed.
In order to proceed down this route you should contact sales DeleteThis @openlinksw.com
Second, the missing license you refer to is oledb_lt.lic which is a license
for the OpenLink Single-tier OLE DB Provider for ODBC.
Since this OLE DB Provider is not OEMed to Avaya and is a totally separate
product to the Multi-tier ODBC Driver for Informix it therefore requires its
own license file.
Once again you should contact sales DeleteThis @openlinksw.com if you need further
clarification.
Regards,
Garry M. Biggs
Technical Support
OpenLink Software
http://www.openlinksw.com
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda
Universal Data Access & Virtual Database Technology
"Sheldon" wrote:
> Hello -
>
> We are running Sql Server 2005 in a Windows Server 2003 environment.
>
> I have been unable to create an SSIS package to copy four tables from an
> Informix database; nor am I able to manually import from this DB. This is a
> DB created by Avaya and they gave me an OpenLink ODBC driver which does not
> work for this. I keep getting a licensing error complaining about not having
> an ole license. I have contacted both OpenLink and Avaya on numerous
> occasions and have run into a bunch of morons.
>
> I can, however create a connection and see all of the tables in BIDS. I can
> also import the tables into Access. I need to delete the tables and
> re-import them daily. Any suggestions on how to do this will be greatly
> appreciated!
>
> (Also, I'm curious that the only DB sources are DataReader, Excel, Flat
> File, OLE DB, Raw File and XML. I don't quite understand why BIDS doesn't
> have an ODBC DB Source.)
>
> Again, any help will be greatly appreciated!
> --
> Sheldon |
|
| Back to top |
|
| |
External
Since: Sep 30, 2008
Posts: 1
|
(Msg. 3) Posted: Tue Sep 30, 2008 12:20 pm
Post subject: RE: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Gary,
How can you call the ODBC access via SSIS, Access, Excel, etc. illegal?
This is the whole purpose of ODBC access into the CMS database. The idea is
to enhance meager reporting capabilities of Avaya's CMS system by utilizing
another reporting package (in this example, it's probably MS Reporting
Services).
Our company also uses Avaya CMS, and we've had numerous problems with
ACSAUTO scripts failing randomly. Therefore, we have moved to using the ODBC
system to export data from CMS into SQL Server. I'm actually encountering
the same problem as Sheldon.
I understand if your Native OLE DB adapter for OpenLink ODBC is licensed
separately. I also understand that OEM OpenLink software from Avaya does not
provide this license. What I don't understand is how extracting your own
data from a CMS Informix database utilizing the software provided by Avaya
for specifically this purpose is in violation of any license agreement.
Please explain.
Isn't the whole point of the Avaya CMS ODBC access system so you can extract
data from the database? Furthermore, I'm unaware of any Avaya-provided
software that actually utilizes the ODBC connection in the way you outline
above (excepting demo applications that are actually created by OpenLink).
Thanks,
Scott Anderson
"OpenLink Technical Support" wrote:
> Hi Sheldon,
>
>
> First, I feel the need to explain the situation --
>
> You are using Avaya CMS and, along with it, an OEMed version of the OpenLink
> Multi-tier ODBC Driver for Informix.
>
> As I said this is an OEMed product and as such comes with restrictions --
>
> i) It is licensed solely for use with Avaya's CMS application and
> therefore your use of it with any other ODBC client application is in breach
> of this license agreement and therefore illegal.
>
> That is - if you are using the driver via SSIS, Access, Excel, etc,
> etc, or any other non-Avaya CMS ODBC application then you are using the
> driver illegally.
>
> ii) Avaya themselves are your point of contact for technical support for
> this product.
>
> OpenLink would be more than happy to assist but this would require you to
> evaluate and purchase a non-OEMed version of the driver with the license
> restrictions (above) removed.
>
> In order to proceed down this route you should contact sales.TakeThisOut@openlinksw.com
>
>
> Second, the missing license you refer to is oledb_lt.lic which is a license
> for the OpenLink Single-tier OLE DB Provider for ODBC.
>
> Since this OLE DB Provider is not OEMed to Avaya and is a totally separate
> product to the Multi-tier ODBC Driver for Informix it therefore requires its
> own license file.
>
>
> Once again you should contact sales.TakeThisOut@openlinksw.com if you need further
> clarification.
>
>
>
> Regards,
>
> Garry M. Biggs
> Technical Support
> OpenLink Software
> http://www.openlinksw.com
> Product Weblogs:
> Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
> UDA: http://www.openlinksw.com/weblogs/uda
> Universal Data Access & Virtual Database Technology
>
>
> "Sheldon" wrote:
>
> > Hello -
> >
> > We are running Sql Server 2005 in a Windows Server 2003 environment.
> >
> > I have been unable to create an SSIS package to copy four tables from an
> > Informix database; nor am I able to manually import from this DB. This is a
> > DB created by Avaya and they gave me an OpenLink ODBC driver which does not
> > work for this. I keep getting a licensing error complaining about not having
> > an ole license. I have contacted both OpenLink and Avaya on numerous
> > occasions and have run into a bunch of morons.
> >
> > I can, however create a connection and see all of the tables in BIDS. I can
> > also import the tables into Access. I need to delete the tables and
> > re-import them daily. Any suggestions on how to do this will be greatly
> > appreciated!
> >
> > (Also, I'm curious that the only DB sources are DataReader, Excel, Flat
> > File, OLE DB, Raw File and XML. I don't quite understand why BIDS doesn't
> > have an ODBC DB Source.)
> >
> > Again, any help will be greatly appreciated!
> > --
> > Sheldon >> Stay informed about: SSIS package Informix to SS 2005 |
|
| Back to top |
|
| |
External
Since: Mar 28, 2005
Posts: 8
|
(Msg. 4) Posted: Mon Oct 13, 2008 12:57 pm
Post subject: RE: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi,
I am having the exact same problem as Sheldon and basically just about ran
out of options. Did anyone ever figure out the best way (or any way for that
matter) to be able to utilize SSIS in order to extract data from avaya
through openlink? or in any possible way.
Exhausted pretty much all information sources. Please let me know if anyone
finds out how to get any work out of avaya cms.
Thank you >> Stay informed about: SSIS package Informix to SS 2005 |
|
| Back to top |
|
| |
External
Since: Oct 13, 2008
Posts: 1
|
(Msg. 5) Posted: Mon Oct 13, 2008 7:08 pm
Post subject: RE: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Has any tried using the FREE IBM Informix Client SDK to connect SSIS to the
Informix backend of CMS? Seems like it shoudl work. I just don't know the
backend informix configuration that Avaya uses. The openlink thing is pretty
useless for any sort of automated work. You can connect via Excel.
"Scott Anderson" wrote:
> Gary,
>
> How can you call the ODBC access via SSIS, Access, Excel, etc. illegal?
> This is the whole purpose of ODBC access into the CMS database. The idea is
> to enhance meager reporting capabilities of Avaya's CMS system by utilizing
> another reporting package (in this example, it's probably MS Reporting
> Services).
>
> Our company also uses Avaya CMS, and we've had numerous problems with
> ACSAUTO scripts failing randomly. Therefore, we have moved to using the ODBC
> system to export data from CMS into SQL Server. I'm actually encountering
> the same problem as Sheldon.
>
> I understand if your Native OLE DB adapter for OpenLink ODBC is licensed
> separately. I also understand that OEM OpenLink software from Avaya does not
> provide this license. What I don't understand is how extracting your own
> data from a CMS Informix database utilizing the software provided by Avaya
> for specifically this purpose is in violation of any license agreement.
> Please explain.
>
> Isn't the whole point of the Avaya CMS ODBC access system so you can extract
> data from the database? Furthermore, I'm unaware of any Avaya-provided
> software that actually utilizes the ODBC connection in the way you outline
> above (excepting demo applications that are actually created by OpenLink).
>
> Thanks,
>
> Scott Anderson
>
> "OpenLink Technical Support" wrote:
>
> > Hi Sheldon,
> >
> >
> > First, I feel the need to explain the situation --
> >
> > You are using Avaya CMS and, along with it, an OEMed version of the OpenLink
> > Multi-tier ODBC Driver for Informix.
> >
> > As I said this is an OEMed product and as such comes with restrictions --
> >
> > i) It is licensed solely for use with Avaya's CMS application and
> > therefore your use of it with any other ODBC client application is in breach
> > of this license agreement and therefore illegal.
> >
> > That is - if you are using the driver via SSIS, Access, Excel, etc,
> > etc, or any other non-Avaya CMS ODBC application then you are using the
> > driver illegally.
> >
> > ii) Avaya themselves are your point of contact for technical support for
> > this product.
> >
> > OpenLink would be more than happy to assist but this would require you to
> > evaluate and purchase a non-OEMed version of the driver with the license
> > restrictions (above) removed.
> >
> > In order to proceed down this route you should contact sales.DeleteThis@openlinksw.com
> >
> >
> > Second, the missing license you refer to is oledb_lt.lic which is a license
> > for the OpenLink Single-tier OLE DB Provider for ODBC.
> >
> > Since this OLE DB Provider is not OEMed to Avaya and is a totally separate
> > product to the Multi-tier ODBC Driver for Informix it therefore requires its
> > own license file.
> >
> >
> > Once again you should contact sales.DeleteThis@openlinksw.com if you need further
> > clarification.
> >
> >
> >
> > Regards,
> >
> > Garry M. Biggs
> > Technical Support
> > OpenLink Software
> > http://www.openlinksw.com
> > Product Weblogs:
> > Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
> > UDA: http://www.openlinksw.com/weblogs/uda
> > Universal Data Access & Virtual Database Technology
> >
> >
> > "Sheldon" wrote:
> >
> > > Hello -
> > >
> > > We are running Sql Server 2005 in a Windows Server 2003 environment.
> > >
> > > I have been unable to create an SSIS package to copy four tables from an
> > > Informix database; nor am I able to manually import from this DB. This is a
> > > DB created by Avaya and they gave me an OpenLink ODBC driver which does not
> > > work for this. I keep getting a licensing error complaining about not having
> > > an ole license. I have contacted both OpenLink and Avaya on numerous
> > > occasions and have run into a bunch of morons.
> > >
> > > I can, however create a connection and see all of the tables in BIDS. I can
> > > also import the tables into Access. I need to delete the tables and
> > > re-import them daily. Any suggestions on how to do this will be greatly
> > > appreciated!
> > >
> > > (Also, I'm curious that the only DB sources are DataReader, Excel, Flat
> > > File, OLE DB, Raw File and XML. I don't quite understand why BIDS doesn't
> > > have an ODBC DB Source.)
> > >
> > > Again, any help will be greatly appreciated!
> > > --
> > > Sheldon >> Stay informed about: SSIS package Informix to SS 2005 |
|
| Back to top |
|
| |
External
Since: Oct 27, 2008
Posts: 1
|
(Msg. 6) Posted: Mon Oct 27, 2008 2:48 pm
Post subject: Re: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Sep 30, 7:20 pm, Scott Anderson <Scott
Ander....TakeThisOut@discussions.microsoft.com> wrote:
> Gary,
>
> How can you call the ODBC access viaSSIS, Access, Excel, etc. illegal?
> This is the whole purpose of ODBC access into the CMS database. The idea is
> to enhance meager reporting capabilities of Avaya's CMS system by utilizing
> another reporting package (in this example, it's probably MS Reporting
> Services).
>
> Our company also uses Avaya CMS, and we've had numerous problems with
> ACSAUTO scripts failing randomly. Therefore, we have moved to using the ODBC
> system to export data from CMS into SQL Server. I'm actually encountering
> the same problem as Sheldon.
>
> I understand if your Native OLE DB adapter for OpenLink ODBC is licensed
> separately. I also understand that OEM OpenLink software from Avaya does not
> provide this license. What I don't understand is how extracting your own
> data from a CMSInformixdatabase utilizing the software provided by Avaya
> for specifically this purpose is in violation of any license agreement.
> Please explain.
>
> Isn't the whole point of the Avaya CMS ODBC access system so you can extract
> data from the database? Furthermore, I'm unaware of any Avaya-provided
> software that actually utilizes the ODBC connection in the way you outline
> above (excepting demo applications that are actually created by OpenLink)..
>
> Thanks,
>
> Scott Anderson
>
> "OpenLink Technical Support" wrote:
> > Hi Sheldon,
>
> > First, I feel the need to explain the situation --
>
> > You are using Avaya CMS and, along with it, an OEMed version of the OpenLink
> > Multi-tier ODBC Driver forInformix.
>
> > As I said this is an OEMed product and as such comes with restrictions --
>
> > i) It is licensed solely for use with Avaya's CMS application and
> > therefore your use of it with any other ODBC client application is in breach
> > of this license agreement and therefore illegal.
>
> > That is - if you are using the driver viaSSIS, Access, Excel, etc,
> > etc, or any other non-Avaya CMS ODBC application then you are using the
> > driver illegally.
>
> > ii) Avaya themselves are your point of contact for technical support for
> > this product.
>
> > OpenLink would be more than happy to assist but this would require you to
> > evaluate and purchase a non-OEMed version of the driver with the license
> > restrictions (above) removed.
>
> > In order to proceed down this route you should contact sa...@openlinksw..com
>
> > Second, the missing license you refer to is oledb_lt.lic which is a license
> > for the OpenLink Single-tier OLE DB Provider for ODBC.
>
> > Since this OLE DB Provider is not OEMed to Avaya and is a totally separate
> > product to the Multi-tier ODBC Driver forInformixit therefore requires its
> > own license file.
>
> > Once again you should contact sa....TakeThisOut@openlinksw.com if you need further
> > clarification.
>
> > Regards,
>
> > Garry M. Biggs
> > Technical Support
> > OpenLink Software
> >http://www.openlinksw.com
> > Product Weblogs:
> > Virtuoso:http://www.openlinksw.com/weblogs/virtuoso
> > UDA:http://www.openlinksw.com/weblogs/uda
> > Universal Data Access & Virtual Database Technology
>
> > "Sheldon" wrote:
>
> > > Hello -
>
> > > We are running Sql Server 2005 in a Windows Server 2003 environment.
>
> > > I have been unable to create anSSISpackage to copy four tables from an
> > >Informixdatabase; nor am I able to manually import from this DB. This is a
> > > DB created by Avaya and they gave me an OpenLink ODBC driver which does not
> > > work for this. I keep getting a licensing error complaining about not having
> > > an ole license. I have contacted both OpenLink and Avaya on numerous
> > > occasions and have run into a bunch of morons.
>
> > > I can, however create a connection and see all of the tables in BIDS. I can
> > > also import the tables into Access. I need to delete the tables and
> > > re-import them daily. Any suggestions on how to do this will be greatly
> > > appreciated!
>
> > > (Also, I'm curious that the only DB sources are DataReader, Excel, Flat
> > > File, OLE DB, Raw File and XML. I don't quite understand why BIDS doesn't
> > > have an ODBC DB Source.)
>
> > > Again, any help will be greatly appreciated!
> > > --
> > > Sheldon
Hi all,
Ok, I feel the need to clarify my initial response ----
Basically, the licensing restriction I spoke of is an application
specific restriction.
That is, Avaya have OEMed the OpenLink Multi-tier ODBC Driver for
Informix exclusively for use with their CMS application (the CMS
application being the application that puts the data into the Informix
database in the first place).
So - what is required is a fully licensed version of the ODBC Driver
purchased through OpenLink Software.
It is only a fully licensed version of the driver that is permitted to
be used with non-Avaya CMS ODBC applications such as SSIS, Access,
Excel, etc
I guess this was a commercial decision made by Avaya at the time
contracts for OEMing the driver were drawn up.
At no point did I said "ODBC access via SSIS, Access, Excel, etc was
illegal".
What I *did* said is - "ODBC access via SSIS, Access, Excel, etc
through the OpenLink Multi-tier ODBC Driver for Informix that is OEMed
to Avaya is illegal.
I hope this clears things up.
Regards,
Garry M. Biggs
Technical Support
OpenLink Software
http://www.openlinksw.com
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda >> Stay informed about: SSIS package Informix to SS 2005 |
|
| Back to top |
|
| |
External
Since: Oct 27, 2008
Posts: 1
|
(Msg. 7) Posted: Mon Oct 27, 2008 5:20 pm
Post subject: Re: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi All,
To be clear, the issue regarding the Avaya OEM'ed version of the
OpenLink ODBC Driver for Informix is the terms under which it is
licensed, this being for use with Avaya CMS applications only and not
any other ODBC application. So we are not questioning the general
usage of an ODBC Driver, only that of the terms under which the Avaya
OEM OpenLink ODBC for Informix is licensed from OpenLink Software
which imposes application restrictions on its use.
Going back to the specific issue of connectivty to SSIS, our Release
6.1 ODBC Driver have been tested against SSIS and verified to be
functional, this being the OpenLink release available when SSIS/SQL
Server 2005 itself was released. The Avaya OEM'ed OpenLink ODBC
Drivers for Informix are Release 4.2 or 5.2, which have not been
tested against SSIS these not being our current release at the time.
Thus the general recommendation would be that our Release 6.1 ODBC
Drivers or ADO.Net Provider are used for connectivity to SSIS, and can
be downloaded for evaluation from:
http://download.openlinksw.com
I hope this clarifies matters and clears up some of the confusion in
this thread ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support >> Stay informed about: SSIS package Informix to SS 2005 |
|
| Back to top |
|
| |
External
Since: Nov 05, 2008
Posts: 1
|
(Msg. 8) Posted: Wed Nov 05, 2008 10:22 pm
Post subject: Re: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Can anybody suggest me or explain how we can overcome the requirement like
picking data from ODBC and pushing it to SS 2005 Database through SSIS
package...
Thanks in advance..Request you to help me out...
Solution is appriciated...
Regards,
K.Phanish
"technical.support@openlinksw.com" wrote:
> On Sep 30, 7:20 pm, Scott Anderson <Scott
> Ander....TakeThisOut@discussions.microsoft.com> wrote:
> > Gary,
> >
> > How can you call the ODBC access viaSSIS, Access, Excel, etc. illegal?
> > This is the whole purpose of ODBC access into the CMS database. The idea is
> > to enhance meager reporting capabilities of Avaya's CMS system by utilizing
> > another reporting package (in this example, it's probably MS Reporting
> > Services).
> >
> > Our company also uses Avaya CMS, and we've had numerous problems with
> > ACSAUTO scripts failing randomly. Therefore, we have moved to using the ODBC
> > system to export data from CMS into SQL Server. I'm actually encountering
> > the same problem as Sheldon.
> >
> > I understand if your Native OLE DB adapter for OpenLink ODBC is licensed
> > separately. I also understand that OEM OpenLink software from Avaya does not
> > provide this license. What I don't understand is how extracting your own
> > data from a CMSInformixdatabase utilizing the software provided by Avaya
> > for specifically this purpose is in violation of any license agreement.
> > Please explain.
> >
> > Isn't the whole point of the Avaya CMS ODBC access system so you can extract
> > data from the database? Furthermore, I'm unaware of any Avaya-provided
> > software that actually utilizes the ODBC connection in the way you outline
> > above (excepting demo applications that are actually created by OpenLink)..
> >
> > Thanks,
> >
> > Scott Anderson
> >
> > "OpenLink Technical Support" wrote:
> > > Hi Sheldon,
> >
> > > First, I feel the need to explain the situation --
> >
> > > You are using Avaya CMS and, along with it, an OEMed version of the OpenLink
> > > Multi-tier ODBC Driver forInformix.
> >
> > > As I said this is an OEMed product and as such comes with restrictions --
> >
> > > i) It is licensed solely for use with Avaya's CMS application and
> > > therefore your use of it with any other ODBC client application is in breach
> > > of this license agreement and therefore illegal.
> >
> > > That is - if you are using the driver viaSSIS, Access, Excel, etc,
> > > etc, or any other non-Avaya CMS ODBC application then you are using the
> > > driver illegally.
> >
> > > ii) Avaya themselves are your point of contact for technical support for
> > > this product.
> >
> > > OpenLink would be more than happy to assist but this would require you to
> > > evaluate and purchase a non-OEMed version of the driver with the license
> > > restrictions (above) removed.
> >
> > > In order to proceed down this route you should contact sa...@openlinksw..com
> >
> > > Second, the missing license you refer to is oledb_lt.lic which is a license
> > > for the OpenLink Single-tier OLE DB Provider for ODBC.
> >
> > > Since this OLE DB Provider is not OEMed to Avaya and is a totally separate
> > > product to the Multi-tier ODBC Driver forInformixit therefore requires its
> > > own license file.
> >
> > > Once again you should contact sa....TakeThisOut@openlinksw.com if you need further
> > > clarification.
> >
> > > Regards,
> >
> > > Garry M. Biggs
> > > Technical Support
> > > OpenLink Software
> > >http://www.openlinksw.com
> > > Product Weblogs:
> > > Virtuoso:http://www.openlinksw.com/weblogs/virtuoso
> > > UDA:http://www.openlinksw.com/weblogs/uda
> > > Universal Data Access & Virtual Database Technology
> >
> > > "Sheldon" wrote:
> >
> > > > Hello -
> >
> > > > We are running Sql Server 2005 in a Windows Server 2003 environment.
> >
> > > > I have been unable to create anSSISpackage to copy four tables from an
> > > >Informixdatabase; nor am I able to manually import from this DB. This is a
> > > > DB created by Avaya and they gave me an OpenLink ODBC driver which does not
> > > > work for this. I keep getting a licensing error complaining about not having
> > > > an ole license. I have contacted both OpenLink and Avaya on numerous
> > > > occasions and have run into a bunch of morons.
> >
> > > > I can, however create a connection and see all of the tables in BIDS. I can
> > > > also import the tables into Access. I need to delete the tables and
> > > > re-import them daily. Any suggestions on how to do this will be greatly
> > > > appreciated!
> >
> > > > (Also, I'm curious that the only DB sources are DataReader, Excel, Flat
> > > > File, OLE DB, Raw File and XML. I don't quite understand why BIDS doesn't
> > > > have an ODBC DB Source.)
> >
> > > > Again, any help will be greatly appreciated!
> > > > --
> > > > Sheldon
> Hi all,
>
> Ok, I feel the need to clarify my initial response ----
>
> Basically, the licensing restriction I spoke of is an application
> specific restriction.
>
> That is, Avaya have OEMed the OpenLink Multi-tier ODBC Driver for
> Informix exclusively for use with their CMS application (the CMS
> application being the application that puts the data into the Informix
> database in the first place).
>
> So - what is required is a fully licensed version of the ODBC Driver
> purchased through OpenLink Software.
>
> It is only a fully licensed version of the driver that is permitted to
> be used with non-Avaya CMS ODBC applications such as SSIS, Access,
> Excel, etc
>
> I guess this was a commercial decision made by Avaya at the time
> contracts for OEMing the driver were drawn up.
>
>
> At no point did I said "ODBC access via SSIS, Access, Excel, etc was
> illegal".
>
> What I *did* said is - "ODBC access via SSIS, Access, Excel, etc
> through the OpenLink Multi-tier ODBC Driver for Informix that is OEMed
> to Avaya is illegal.
>
>
> I hope this clears things up.
>
>
> Regards,
>
> Garry M. Biggs
> Technical Support
> OpenLink Software
> http://www.openlinksw.com
> Product Weblogs:
> Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
> UDA: http://www.openlinksw.com/weblogs/uda
> >> Stay informed about: SSIS package Informix to SS 2005 |
|
| Back to top |
|
| |
External
Since: Nov 12, 2008
Posts: 1
|
(Msg. 9) Posted: Wed Nov 12, 2008 2:02 pm
Post subject: Re: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I am using Avaya Openlink driver 4.2 and after much trial and error I have
been able to connect to the database and import data into SQL Server 2005. I
had trouble with scheduling a package but overcame this when I saved the
package using Server storage and created a proxy account to run under. I
have occassionally had problems with specific fields which caused the package
to fail so I reverted to Access for thos tables. I am receiving error
OXC020901c. If anyone knows how to fix that I'd appreciate the help. I
found an article about changing the registry when you get this error message
when trying to import Excel spreadsheets but I can't find anything on
informix.
"Phani" wrote:
> Can anybody suggest me or explain how we can overcome the requirement like
> picking data from ODBC and pushing it to SS 2005 Database through SSIS
> package...
>
> Thanks in advance..Request you to help me out...
>
> Solution is appriciated...
>
> Regards,
> K.Phanish
>
> "technical.support@openlinksw.com" wrote:
>
> > On Sep 30, 7:20 pm, Scott Anderson <Scott
> > Ander... RemoveThis @discussions.microsoft.com> wrote:
> > > Gary,
> > >
> > > How can you call the ODBC access viaSSIS, Access, Excel, etc. illegal?
> > > This is the whole purpose of ODBC access into the CMS database. The idea is
> > > to enhance meager reporting capabilities of Avaya's CMS system by utilizing
> > > another reporting package (in this example, it's probably MS Reporting
> > > Services).
> > >
> > > Our company also uses Avaya CMS, and we've had numerous problems with
> > > ACSAUTO scripts failing randomly. Therefore, we have moved to using the ODBC
> > > system to export data from CMS into SQL Server. I'm actually encountering
> > > the same problem as Sheldon.
> > >
> > > I understand if your Native OLE DB adapter for OpenLink ODBC is licensed
> > > separately. I also understand that OEM OpenLink software from Avaya does not
> > > provide this license. What I don't understand is how extracting your own
> > > data from a CMSInformixdatabase utilizing the software provided by Avaya
> > > for specifically this purpose is in violation of any license agreement.
> > > Please explain.
> > >
> > > Isn't the whole point of the Avaya CMS ODBC access system so you can extract
> > > data from the database? Furthermore, I'm unaware of any Avaya-provided
> > > software that actually utilizes the ODBC connection in the way you outline
> > > above (excepting demo applications that are actually created by OpenLink)..
> > >
> > > Thanks,
> > >
> > > Scott Anderson
> > >
> > > "OpenLink Technical Support" wrote:
> > > > Hi Sheldon,
> > >
> > > > First, I feel the need to explain the situation --
> > >
> > > > You are using Avaya CMS and, along with it, an OEMed version of the OpenLink
> > > > Multi-tier ODBC Driver forInformix.
> > >
> > > > As I said this is an OEMed product and as such comes with restrictions --
> > >
> > > > i) It is licensed solely for use with Avaya's CMS application and
> > > > therefore your use of it with any other ODBC client application is in breach
> > > > of this license agreement and therefore illegal.
> > >
> > > > That is - if you are using the driver viaSSIS, Access, Excel, etc,
> > > > etc, or any other non-Avaya CMS ODBC application then you are using the
> > > > driver illegally.
> > >
> > > > ii) Avaya themselves are your point of contact for technical support for
> > > > this product.
> > >
> > > > OpenLink would be more than happy to assist but this would require you to
> > > > evaluate and purchase a non-OEMed version of the driver with the license
> > > > restrictions (above) removed.
> > >
> > > > In order to proceed down this route you should contact sa...@openlinksw..com
> > >
> > > > Second, the missing license you refer to is oledb_lt.lic which is a license
> > > > for the OpenLink Single-tier OLE DB Provider for ODBC.
> > >
> > > > Since this OLE DB Provider is not OEMed to Avaya and is a totally separate
> > > > product to the Multi-tier ODBC Driver forInformixit therefore requires its
> > > > own license file.
> > >
> > > > Once again you should contact sa... RemoveThis @openlinksw.com if you need further
> > > > clarification.
> > >
> > > > Regards,
> > >
> > > > Garry M. Biggs
> > > > Technical Support
> > > > OpenLink Software
> > > >http://www.openlinksw.com
> > > > Product Weblogs:
> > > > Virtuoso:http://www.openlinksw.com/weblogs/virtuoso
> > > > UDA:http://www.openlinksw.com/weblogs/uda
> > > > Universal Data Access & Virtual Database Technology
> > >
> > > > "Sheldon" wrote:
> > >
> > > > > Hello -
> > >
> > > > > We are running Sql Server 2005 in a Windows Server 2003 environment.
> > >
> > > > > I have been unable to create anSSISpackage to copy four tables from an
> > > > >Informixdatabase; nor am I able to manually import from this DB. This is a
> > > > > DB created by Avaya and they gave me an OpenLink ODBC driver which does not
> > > > > work for this. I keep getting a licensing error complaining about not having
> > > > > an ole license. I have contacted both OpenLink and Avaya on numerous
> > > > > occasions and have run into a bunch of morons.
> > >
> > > > > I can, however create a connection and see all of the tables in BIDS. I can
> > > > > also import the tables into Access. I need to delete the tables and
> > > > > re-import them daily. Any suggestions on how to do this will be greatly
> > > > > appreciated!
> > >
> > > > > (Also, I'm curious that the only DB sources are DataReader, Excel, Flat
> > > > > File, OLE DB, Raw File and XML. I don't quite understand why BIDS doesn't
> > > > > have an ODBC DB Source.)
> > >
> > > > > Again, any help will be greatly appreciated!
> > > > > --
> > > > > Sheldon
> > Hi all,
> >
> > Ok, I feel the need to clarify my initial response ----
> >
> > Basically, the licensing restriction I spoke of is an application
> > specific restriction.
> >
> > That is, Avaya have OEMed the OpenLink Multi-tier ODBC Driver for
> > Informix exclusively for use with their CMS application (the CMS
> > application being the application that puts the data into the Informix
> > database in the first place).
> >
> > So - what is required is a fully licensed version of the ODBC Driver
> > purchased through OpenLink Software.
> >
> > It is only a fully licensed version of the driver that is permitted to
> > be used with non-Avaya CMS ODBC applications such as SSIS, Access,
> > Excel, etc
> >
> > I guess this was a commercial decision made by Avaya at the time
> > contracts for OEMing the driver were drawn up.
> >
> >
> > At no point did I said "ODBC access via SSIS, Access, Excel, etc was
> > illegal".
> >
> > What I *did* said is - "ODBC access via SSIS, Access, Excel, etc
> > through the OpenLink Multi-tier ODBC Driver for Informix that is OEMed
> > to Avaya is illegal.
> >
> >
> > I hope this clears things up.
> >
> >
> > Regards,
> >
> > Garry M. Biggs
> > Technical Support
> > OpenLink Software
> > http://www.openlinksw.com
> > Product Weblogs:
> > Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
> > UDA: http://www.openlinksw.com/weblogs/uda
> > >> Stay informed about: SSIS package Informix to SS 2005 |
|
| Back to top |
|
| |
|
OpenLink Technical Suppor
|
External
Since: Aug 19, 2008
Posts: 2
|
(Msg. 10) Posted: Thu Jan 15, 2009 2:38 am
Post subject: Re: SSIS package Informix to SS 2005 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi Regina,
You should contact OpenLink technical support for assistance is resolving
ODBC issues, using the OpenLink ODBC Driver shipped by Avaya, with other
non-Avaya ODBC Applications.
You can do this by opening an online support case ar the following URL -
http://support.openlinksw.com/support/online-support.vsp
Regards,
Garry M. Biggs
Technical Support
OpenLink Software
http://www.openlinksw.com
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda
"Regina B" wrote:
> I am using Avaya Openlink driver 4.2 and after much trial and error I have
> been able to connect to the database and import data into SQL Server 2005. I
> had trouble with scheduling a package but overcame this when I saved the
> package using Server storage and created a proxy account to run under. I
> have occassionally had problems with specific fields which caused the package
> to fail so I reverted to Access for thos tables. I am receiving error
> OXC020901c. If anyone knows how to fix that I'd appreciate the help. I
> found an article about changing the registry when you get this error message
> when trying to import Excel spreadsheets but I can't find anything on
> informix.
>
> "Phani" wrote:
>
> > Can anybody suggest me or explain how we can overcome the requirement like
> > picking data from ODBC and pushing it to SS 2005 Database through SSIS
> > package...
> >
> > Thanks in advance..Request you to help me out...
> >
> > Solution is appriciated...
> >
> > Regards,
> > K.Phanish
> >
> > "technical.support@openlinksw.com" wrote:
> >
> > > On Sep 30, 7:20 pm, Scott Anderson <Scott
> > > Ander... DeleteThis @discussions.microsoft.com> wrote:
> > > > Gary,
> > > >
> > > > How can you call the ODBC access viaSSIS, Access, Excel, etc. illegal?
> > > > This is the whole purpose of ODBC access into the CMS database. The idea is
> > > > to enhance meager reporting capabilities of Avaya's CMS system by utilizing
> > > > another reporting package (in this example, it's probably MS Reporting
> > > > Services).
> > > >
> > > > Our company also uses Avaya CMS, and we've had numerous problems with
> > > > ACSAUTO scripts failing randomly. Therefore, we have moved to using the ODBC
> > > > system to export data from CMS into SQL Server. I'm actually encountering
> > > > the same problem as Sheldon.
> > > >
> > > > I understand if your Native OLE DB adapter for OpenLink ODBC is licensed
> > > > separately. I also understand that OEM OpenLink software from Avaya does not
> > > > provide this license. What I don't understand is how extracting your own
> > > > data from a CMSInformixdatabase utilizing the software provided by Avaya
> > > > for specifically this purpose is in violation of any license agreement.
> > > > Please explain.
> > > >
> > > > Isn't the whole point of the Avaya CMS ODBC access system so you can extract
> > > > data from the database? Furthermore, I'm unaware of any Avaya-provided
> > > > software that actually utilizes the ODBC connection in the way you outline
> > > > above (excepting demo applications that are actually created by OpenLink)..
> > > >
> > > > Thanks,
> > > >
> > > > Scott Anderson
> > > >
> > > > "OpenLink Technical Support" wrote:
> > > > > Hi Sheldon,
> > > >
> > > > > First, I feel the need to explain the situation --
> > > >
> > > > > You are using Avaya CMS and, along with it, an OEMed version of the OpenLink
> > > > > Multi-tier ODBC Driver forInformix.
> > > >
> > > > > As I said this is an OEMed product and as such comes with restrictions --
> > > >
> > > > > i) It is licensed solely for use with Avaya's CMS application and
> > > > > therefore your use of it with any other ODBC client application is in breach
> > > > > of this license agreement and therefore illegal.
> > > >
> > > > > That is - if you are using the driver viaSSIS, Access, Excel, etc,
> > > > > etc, or any other non-Avaya CMS ODBC application then you are using the
> > > > > driver illegally.
> > > >
> > > > > ii) Avaya themselves are your point of contact for technical support for
> > > > > this product.
> > > >
> > > > > OpenLink would be more than happy to assist but this would require you to
> > > > > evaluate and purchase a non-OEMed version of the driver with the license
> > > > > restrictions (above) removed.
> > > >
> > > > > In order to proceed down this route you should contact sa...@openlinksw..com
> > > >
> > > > > Second, the missing license you refer to is oledb_lt.lic which is a license
> > > > > for the OpenLink Single-tier OLE DB Provider for ODBC.
> > > >
> > > > > Since this OLE DB Provider is not OEMed to Avaya and is a totally separate
> > > > > product to the Multi-tier ODBC Driver forInformixit therefore requires its
> > > > > own license file.
> > > >
> > > > > Once again you should contact sa... DeleteThis @openlinksw.com if you need further
> > > > > clarification.
> > > >
> > > > > Regards,
> > > >
> > > > > Garry M. Biggs
> > > > > Technical Support
> > > > > OpenLink Software
> > > > >http://www.openlinksw.com
> > > > > Product Weblogs:
> > > > > Virtuoso:http://www.openlinksw.com/weblogs/virtuoso
> > > > > UDA:http://www.openlinksw.com/weblogs/uda
> > > > > Universal Data Access & Virtual Database Technology
> > > >
> > > > > "Sheldon" wrote:
> > > >
> > > > > > Hello -
> > > >
> > > > > > We are running Sql Server 2005 in a Windows Server 2003 environment.
> > > >
> > > > > > I have been unable to create anSSISpackage to copy four tables from an
> > > > > >Informixdatabase; nor am I able to manually import from this DB. This is a
> > > > > > DB created by Avaya and they gave me an OpenLink ODBC driver which does not
> > > > > > work for this. I keep getting a licensing error complaining about not having
> > > > > > an ole license. I have contacted both OpenLink and Avaya on numerous
> > > > > > occasions and have run into a bunch of morons.
> > > >
> > > > > > I can, however create a connection and see all of the tables in BIDS. I can
> > > > > > also import the tables into Access. I need to delete the tables and
> > > > > > re-import them daily. Any suggestions on how to do this will be greatly
> > > > > > appreciated!
> > > >
> > > > > > (Also, I'm curious that the only DB sources are DataReader, Excel, Flat
> > > > > > File, OLE DB, Raw File and XML. I don't quite understand why BIDS doesn't
> > > > > > have an ODBC DB Source.)
> > > >
> > > > > > Again, any help will be greatly appreciated!
> > > > > > --
> > > > > > Sheldon
> > > Hi all,
> > >
> > > Ok, I feel the need to clarify my initial response ----
> > >
> > > Basically, the licensing restriction I spoke of is an application
> > > specific restriction.
> > >
> > > That is, Avaya have OEMed the OpenLink Multi-tier ODBC Driver for
> > > Informix exclusively for use with their CMS application (the CMS
> > > application being the application that puts the data into the Informix
> > > database in the first place).
> > >
> > > So - what is required is a fully licensed version of the ODBC Driver
> > > purchased through OpenLink Software.
> > >
> > > It is only a fully licensed version of the driver that is permitted to
> > > be used with non-Avaya CMS ODBC applications such as SSIS, Access,
> > > Excel, etc
> > >
> > > I guess this was a commercial decision made by Avaya at the time
> > > contracts for OEMing the driver were drawn up.
> > >
> > >
> > > At no point did I said "ODBC access via SSIS, Access, Excel, etc was
> > > illegal".
> > >
> > > What I *did* said is - "ODBC access via SSIS, Access, Excel, etc
> > > through the OpenLink Multi-tier ODBC Driver for Informix that is OEMed
> > > to Avaya is illegal.
> > >
> > >
> > > I hope this clears things up.
> > >
> > >
> > > Regards,
> > >
> > > Garry M. Biggs
> > > Technical Support
> > > OpenLink Software
> > > http://www.openlinksw.com
> > > Product Weblogs:
> > > Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
> > > UDA: http://www.openlinksw.com/weblogs/uda
> > > >> Stay informed about: SSIS package Informix to SS 2005 |
|
| Back to top |
|
| |
| Related Topics: | SSIS Informix - Hello, I'm using SSIS (SQL Server Integration Services) via Native Informix OLE DB provider to extract (ETL) data from Informix 7.3 to SQL Server 2005. I have following problem, when I try to connect to the Informix database I'm getting : Warning -..
Duplicating Informix database - Hi, Our main application is running on a SCO Open Server Unix server. It's an Informix database. In order to free up this server a bit and because the application is running in text base format, we like to create a duplicate database on a Win2k Serve...
RDB ODBC for SSIS - I need RDB ODBC to use in my SSIS projects. is there any????
IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL EXCE.. - I am using the latest IBM INFORMIX ODBC DRIVER 3.00.00.13223 - ICLIT09B.DLL I then use a link server – Microsoft OLE DB Provider for ODBC Driver. Both ODBC and Linked server test connection successfully and I can return most records in a table from....
SSIS on Sql Server 2005 OLE DB datasource for Tandem machine - Hello, I am setting up a package to update sql/mp tables on a Tandem machine. I am using an OLE DB conneciton manager with the Attunity driver. I am attempting to use the OLE DB Command object to do parameterized queries. The connection works fine.. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
