Actually updating sql tables directly from udt is pretty easy using the BCI
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Gerd Forthmann Sent: 20 January 2010 16:34 To: U2 Users List Subject: Re: [U2] Export files You are right, exporting to SQL Server isn't as easy as importing from SQL Server. I even doubt that exporting data from UD files directly into SQL Server tables is possible at all without some really fancy programming in foreign tongues like C# or similar. The main reason for that is that SQL Server has in-built tools for data transfers while UD hasn't, so you would have to "knit your own". First question: Which releases do you use? And that is for both sides. For SQL Server before 2005 you can use DTS for newer versions SSIS. Of course you need to make your UD files accessible to SQL first. To do that you can use VSG or Schema API. It's really not that hard once you get the hang of it. If you have SQL Server 2005 or 2008 and UD before release 6 then you are out of luck. The ODBC and OLEDB drivers are based on COM and just don't work with SSIS, which uses .NET! To overcome that you can buy some software from Bluefinity for instance, since you where asking for the "simplest" way, but I guess you mean the cheapest as well. Next step is to set up UD as a data source on the SQL Server side. DTS will in most cases quite happily work with the IBM ODBC driver. Just set it up in ODBC Data sources under System DNS. SSIS requires a driver using ADO.NET and should work with the OLEDB driver supplied with the UniDK (U2 Developer kit). If you didn't get a CD with the programs from your VAR ask them, or otherwise you should be able to download it from Rocket Software. I haven't found them yet, but they should be there somewhere. For OLEDB you set up your UD connection with the UCI editor that comes with it. Once the files you want to export have been set up as SQL tables on UD and the datasource has been set up on the SQL Server side you can then use DTS or SSIS to copy the data. You can create whole data transfer projects and schedule them to run at defined intervalls. It's really a piece of cake once everything is set up right. It's all wizard driven and DTS and SSIS will even create the tables for you on the SQL Server side. No knowledge of SQL syntax required. Cheers Mecki -------- Original-Nachricht -------- > Datum: Wed, 20 Jan 2010 15:10:20 -0000 > Von: "Symeon Breen" <[email protected]> > An: "\'U2 Users List\'" <[email protected]> > Betreff: Re: [U2] Export files > Are you after the simplest way of exporting from udt ? > > > Or is it the whole transfer of data into sqlserver that is at stake here > ?? > > The easy ways of exporting tend to be more effort to import at the other > end > ... > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of César Riba > Cervera > Sent: 20 January 2010 11:56 > To: 'U2 Users List' > Subject: [U2] Export files > > Hello > > > Which is the simplest way to export data from Unidata to SQLServer? > > Thanks. > > César Riba > Spain > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3.5 - sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
