RE: [U2] Unidata 6 into SQL 2005
Steve Interesting that you didn't use ODBC to move the data directly out of Unidata? In the DTS script you can use CONVERT or CAST to change the data type. Eg: SELECT CAST(COMPANY AS varchar(3)) AS Company, Project, CAST(ProjectName AS varchar(60)) AS ProjectName, CONVERT(char(10), EndDate, 101) AS EndDate FROM dbo.US_eTimeProjectLoad CONVERT(length,source,type) Regards Graham Graham Forbes| Trading Systems | BT Global Services | Tel:+44 (0)20 7176| Mob:+44 (0)77407 38550 | Fax:+44 (0)20 7177 | E: [EMAIL PROTECTED] | www.bt.com/globalservices -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 22, 2006 5:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 We have a homegrown process where a cron job runs a nightly script that calls basic programs which create comma-delimited text files. Then a windows server runs a scheduled task to ftp the files to that server. Then a DTS script loads the SQL tables with the data. The problem is that the user wants us to type the data (dates mostly). Is there a way to do this with our current process? Thanks in advance. Steve Kunzman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Thursday, June 22, 2006 10:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 [ad] Hello Graham, We have many customers moving MultiValue data to SQL Server or relational databases. We have two products, FusionWare Relational ODBC Driver Edition or FusionWare Direct mv2SQL. These two products have less developer time required If you have VB developer skills accessible to you could consider FusionWare OLEDB driver or FusionWare Direct ADO.Net Provider as an approach to this project. Just a note, the more code you include with your project you create an increased internal support factor as well. IF you are moving the data in one direction MultValue to Relational then I suggest you use the mv2SQL product it is much faster and uses newer technology (OLEDB) and has User Interface for setting up transfers. Lastly this product can be scheduled in SSIS or DTS. As you may be aware when using an ODBC technology the data is flatten during the transfer process, this has a performance penalty. Good Luck Janet Bond [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 8:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial sS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks
RE: [U2] Unidata 6 into SQL 2005 - connection string
Angelo Thanks for this - I have now loaded a new ODBC driver. In SQL 2005 you need to build the connection string (I am using the .net framework Data Provider for ODBC). Here is what I have at the moment: Driver={IBM UniData ODBC Driver};provider=Ardent.UniOLEDB;data source=servername;location=databasename;user id=odbc;password=password Does anyone have a successful connection string which works with SQL 2005 SSIS? Thanks graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 4:40 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial sS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 6 into SQL 2005 [ad]
Hello Graham, We have many customers moving MultiValue data to SQL Server or relational databases. We have two products, FusionWare Relational ODBC Driver Edition or FusionWare Direct mv2SQL. These two products have less developer time required If you have VB developer skills accessible to you could consider FusionWare OLEDB driver or FusionWare Direct ADO.Net Provider as an approach to this project. Just a note, the more code you include with your project you create an increased internal support factor as well. IF you are moving the data in one direction MultValue to Relational then I suggest you use the mv2SQL product it is much faster and uses newer technology (OLEDB) and has User Interface for setting up transfers. Lastly this product can be scheduled in SSIS or DTS. As you may be aware when using an ODBC technology the data is flatten during the transfer process, this has a performance penalty. Good Luck Janet Bond [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 8:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial sS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing
RE: [U2] Unidata 6 into SQL 2005
We have a homegrown process where a cron job runs a nightly script that calls basic programs which create comma-delimited text files. Then a windows server runs a scheduled task to ftp the files to that server. Then a DTS script loads the SQL tables with the data. The problem is that the user wants us to type the data (dates mostly). Is there a way to do this with our current process? Thanks in advance. Steve Kunzman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Thursday, June 22, 2006 10:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 [ad] Hello Graham, We have many customers moving MultiValue data to SQL Server or relational databases. We have two products, FusionWare Relational ODBC Driver Edition or FusionWare Direct mv2SQL. These two products have less developer time required If you have VB developer skills accessible to you could consider FusionWare OLEDB driver or FusionWare Direct ADO.Net Provider as an approach to this project. Just a note, the more code you include with your project you create an increased internal support factor as well. IF you are moving the data in one direction MultValue to Relational then I suggest you use the mv2SQL product it is much faster and uses newer technology (OLEDB) and has User Interface for setting up transfers. Lastly this product can be scheduled in SSIS or DTS. As you may be aware when using an ODBC technology the data is flatten during the transfer process, this has a performance penalty. Good Luck Janet Bond [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 8:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial sS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs
RE: [U2] Unidata 6 into SQL 2005
Steve: Perhaps VSG is what you're looking for. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 22, 2006 9:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 We have a homegrown process where a cron job runs a nightly script that calls basic programs which create comma-delimited text files. Then a windows server runs a scheduled task to ftp the files to that server. Then a DTS script loads the SQL tables with the data. The problem is that the user wants us to type the data (dates mostly). Is there a way to do this with our current process? Thanks in advance. Steve Kunzman -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Thursday, June 22, 2006 10:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 [ad] Hello Graham, We have many customers moving MultiValue data to SQL Server or relational databases. We have two products, FusionWare Relational ODBC Driver Edition or FusionWare Direct mv2SQL. These two products have less developer time required If you have VB developer skills accessible to you could consider FusionWare OLEDB driver or FusionWare Direct ADO.Net Provider as an approach to this project. Just a note, the more code you include with your project you create an increased internal support factor as well. IF you are moving the data in one direction MultValue to Relational then I suggest you use the mv2SQL product it is much faster and uses newer technology (OLEDB) and has User Interface for setting up transfers. Lastly this product can be scheduled in SSIS or DTS. As you may be aware when using an ODBC technology the data is flatten during the transfer process, this has a performance penalty. Good Luck Janet Bond [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Wednesday, June 21, 2006 8:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata 6 into SQL 2005 Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trial sS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire
[U2] Unidata 6 into SQL 2005
Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 6 into SQL 2005
Graham, If you are running your U2 database under Windows, You can download the CLIENT(s) and use the native U2 ODBC drivers. See this link: http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trialsS_ TACT=105AGX11S_CMP=DNLD If your are running under UNIX you to purchase one. Two I know of. 1- http://www.easysoft.com/ 2- http://www.datadirect.com/index.ssp 3- Open source (http://www.mysql.com/) and search for ODBC. Two versions UNIX(AIX/HP/Others) and Linux unixODBC) May the force be with you. Cheers, Angelo Collazo System Administrator Silver Line Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 9:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata 6 into SQL 2005 Does anyone have any advice for which odbc drivers are best for importing Unidata data into a SQL 2005 database? Thanks Graham -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Tuesday, June 20, 2006 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net - universe 10.1.14 Redback and .Net work perfectly together. I've used it in a variety of applications using both C# and VB.Net. Full power of .Net is available as Redback simply makes U2 available. You can build a Data Access Layer where U2 looks like any other database to .Net. If you are from the .Net/SQL world, you can access your Universe data via ADO same as other databases. If you are not an ADO guru, Redback provides its' own more U2 friendly commands to also access the Universe data and programs. You have total freedom in deciding how much or how little of your business logic to be in U2 or .Net. Unlike like some of the other offerings, Redback is not a 'do something on the web for the U2 programmer' type of application. It is a true enabler to allow you to use U2 with the web and do whatever you can do in your web technology of choice. Mike. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Tuesday, June 20, 2006 3:30 AM To: U2-Users (E-mail) Subject: [U2] .net - universe 10.1.14 Apologies I asked this before then went on tour for 3 weeks and my wonderfull staff cleared by emails So I am looking to tie Universe 10.1.14 to a .net development I am looking at biztalk and redback and one other piece of software to facilitate this Any experiences/opinions will be gratefully received (and read this time) Bob Witney IT Senior EXPLORE! Nelson House 55 Victoria Road Farnborough Hampshire GU14 7PA, UK Tel: 01252 379489 Mob: 07973 451156 www.explore.co.uk __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/