RE: D3 on NT
Notice my next paragraph begins with the word "Seriously...". Yes XML has been usuable as a connectivity medium for years, but how many people are taking advantage of it? Microsoft and other companies are continually developing tools to reduce the time and money aspect of using XML, and make it easier to make use of relational databases, but I doubt most MV users or developers are keeping up with the details. No matter how much free information is available, I don't seriously think professionals like us who provide information, products, and services will go out of business anytime soon. ETL tools are always in vogue. Tony > >Tony, >Could you do me a favor and not declare my entire market >segment dead. > >"You now have the keys to data integration heaven and you >don't need to buy any more tools or migration services." > >The fact is, I could move data from any system to any other system >before XML, we all could. The question is always the 'time value of >money' equation. If a tool makes things work more >consistently, faster, >and with less setup time I still see a value. > >- Charles Barouch > > >Tony Gravagno wrote: > >>Without purchasing extra software, probably the easiest thing >to do in >>a migration these days is to take advantage of free .NET >features which >>allow seamless exchanges between XML and ADO.NET: >> >>1) It's simple to write code to wrap data in XML. >>2) You can use a program provided with the .NET Framework to >generate a >>Schema from the XML into a .XSD file. >>3) ADO.NET imports XSD files to create an internal map of a dataset. >>4) With one line of code ADO.NET can read XML and store the data as a >>relational dataset. >> >>Connecting the dots: It's easy to go from any MV platform into XML, >>then into ADO.NET, and from there to any Relational DBMS. >> >>And now that I've let the cat out of the bag, I have to retire a poor >>man. You now have the keys to data integration heaven and you don't >>need to buy any more tools or migration services. >> >>Seriously the way the technology is implemented depends on the >>application. If you ARE interested in data migrations From >any platform >>To any platform, I'll be happy to help. >> >>Tony >>Nebula R&D >>Former D3 DBMS Product Manager, Raining Data >>Technical Editor, C#Builder Kick Start, SAMS Publishing Author, "Web >>Services and .NET" series, Spectrum Magazine >> >> > > >-- >u2-users mailing list >[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 on NT
Tony, Could you do me a favor and not declare my entire market segment dead. "You now have the keys to data integration heaven and you don't need to buy any more tools or migration services." The fact is, I could move data from any system to any other system before XML, we all could. The question is always the 'time value of money' equation. If a tool makes things work more consistently, faster, and with less setup time I still see a value. - Charles Barouch Tony Gravagno wrote: Without purchasing extra software, probably the easiest thing to do in a migration these days is to take advantage of free .NET features which allow seamless exchanges between XML and ADO.NET: 1) It's simple to write code to wrap data in XML. 2) You can use a program provided with the .NET Framework to generate a Schema from the XML into a .XSD file. 3) ADO.NET imports XSD files to create an internal map of a dataset. 4) With one line of code ADO.NET can read XML and store the data as a relational dataset. Connecting the dots: It's easy to go from any MV platform into XML, then into ADO.NET, and from there to any Relational DBMS. And now that I've let the cat out of the bag, I have to retire a poor man. You now have the keys to data integration heaven and you don't need to buy any more tools or migration services. Seriously the way the technology is implemented depends on the application. If you ARE interested in data migrations From any platform To any platform, I'll be happy to help. Tony Nebula R&D Former D3 DBMS Product Manager, Raining Data Technical Editor, C#Builder Kick Start, SAMS Publishing Author, "Web Services and .NET" series, Spectrum Magazine -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 on NT
Without purchasing extra software, probably the easiest thing to do in a migration these days is to take advantage of free .NET features which allow seamless exchanges between XML and ADO.NET: 1) It's simple to write code to wrap data in XML. 2) You can use a program provided with the .NET Framework to generate a Schema from the XML into a .XSD file. 3) ADO.NET imports XSD files to create an internal map of a dataset. 4) With one line of code ADO.NET can read XML and store the data as a relational dataset. Connecting the dots: It's easy to go from any MV platform into XML, then into ADO.NET, and from there to any Relational DBMS. And now that I've let the cat out of the bag, I have to retire a poor man. You now have the keys to data integration heaven and you don't need to buy any more tools or migration services. Seriously the way the technology is implemented depends on the application. If you ARE interested in data migrations From any platform To any platform, I'll be happy to help. Tony Nebula R&D Former D3 DBMS Product Manager, Raining Data Technical Editor, C#Builder Kick Start, SAMS Publishing Author, "Web Services and .NET" series, Spectrum Magazine >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Dahn Finard >Sent: Wednesday, February 11, 2004 6:24 AM >To: U2 Users Discussion List >Subject: D3 on NT > > > >Although I have been working in many pick flavors for the past >20+ years, I have been working in Universe for the past 8 >years. I have a client that is looking for a conversion out of >D3/NT to Oracle. I have two questions; 1. does D3 support the >OPENSEQ and WRITESEQ that Universe does. I downloaded the d3 >basic manual and found the UOPEN and UCREATE. 2. Could the D3 >experts in the group please offer any suggestion and >information about there experiences in conversions from D3. I >know that this is not the direction that we would like to see >software going in, but I did not make the decision about the >companys IS goals. > > >Dahn Finard > > >-- >u2-users mailing list >[EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users > > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 on NT
>Also, how old is the D3? Does it support ODBC? Pull the data out by ODBC to a >"TEXT" ODBC target and then load it into Oracle. Only if he wants to wait a very long time. D3 ODBC is horribly, horribly slow even when it works. The options are really to write a simple flashbasic program using the %open and %write calls to dump data out as plain text; or to use a product like mvQuery (plug) to export to delimited file or to an OleDB connection to Oracle. Assuming all the files are homogenous and can be easily normalized, of course. What to do with it when it gets there - that will be the fun bit. Brian Leach This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan. DISCLAIMER This email and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information. In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED] Microgen Information Management Solutions http://www.microgen.co.uk -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 on NT
>From my understanding it does have the ODBC but the ODBC is blowing up when they attempt to use it. They want to extract the data to the Oracle tables. Dahn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ray Daignault Sent: Wednesday, February 11, 2004 12:34 PM To: U2 Users Discussion List Subject: Re: D3 on NT Is the conversion to an existing ORACLE application or is your client writing a new Oracle application? Also, how old is the D3? Does it support ODBC? Pull the data out by ODBC to a "TEXT" ODBC target and then load it into Oracle. If it's a new application, you might want to take a look at ON-WARE. It's a product that will allow you to keep the business rules within your application but use Oracle as a datastore. Chees, Ray D - Original Message - From: "Dahn Finard" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Wednesday, February 11, 2004 6:23 AM Subject: D3 on NT > > Although I have been working in many pick flavors for the past 20+ years, I > have been working in Universe for the past 8 years. I have a client that is > looking for a conversion out of D3/NT to Oracle. I have two questions; > 1. does D3 support the OPENSEQ and WRITESEQ that Universe does. I downloaded > the d3 basic manual and found the UOPEN and UCREATE. > 2. Could the D3 experts in the group please offer any suggestion and > information about there experiences in conversions from D3. I know that > this is not the direction that we would like to see software going in, but I > did not make the decision about the companys IS goals. > > > Dahn Finard > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 on NT
Is the conversion to an existing ORACLE application or is your client writing a new Oracle application? Also, how old is the D3? Does it support ODBC? Pull the data out by ODBC to a "TEXT" ODBC target and then load it into Oracle. If it's a new application, you might want to take a look at ON-WARE. It's a product that will allow you to keep the business rules within your application but use Oracle as a datastore. Chees, Ray D - Original Message - From: "Dahn Finard" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Wednesday, February 11, 2004 6:23 AM Subject: D3 on NT > > Although I have been working in many pick flavors for the past 20+ years, I > have been working in Universe for the past 8 years. I have a client that is > looking for a conversion out of D3/NT to Oracle. I have two questions; > 1. does D3 support the OPENSEQ and WRITESEQ that Universe does. I downloaded > the d3 basic manual and found the UOPEN and UCREATE. > 2. Could the D3 experts in the group please offer any suggestion and > information about there experiences in conversions from D3. I know that > this is not the direction that we would like to see software going in, but I > did not make the decision about the companys IS goals. > > > Dahn Finard > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 on NT
- Original Message - From: "Dahn Finard" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Wednesday, February 11, 2004 8:23 AM Subject: D3 on NT Dahn, Sorry to follow my own reply with a reply but I just remembered that Raining Data has a product available called D3 Oracle Gateway. You might want to check that out at www.rainingdata.com. Ron White -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 on NT
- Original Message - From: "Dahn Finard" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Wednesday, February 11, 2004 8:23 AM Subject: D3 on NT > 1. does D3 support the OPENSEQ and WRITESEQ that Universe does. I downloaded > the d3 basic manual and found the UOPEN and UCREATE. > > Dahn Finard > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > > Dahn, D3 does not have OPSENSEQ and WRITESEQ as UniVerse does. D3 uses the OSFI (Operating System File Interface) to read and write at the OS level. The OPEN statement can accept a windows path string such as "C:\MyFolder\MyFile". You may need to precede the path with one of the codes from DM,hosts,. The hosts codes help you deal with line termination issues. For additional help you can contact the Usenet group comp.databases.pick and/or search the cdp archive through Google groups. Ron White -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 on NT
1. Not 'per se' - but they have %read and %write plus OSFI and super-q pointers. This allows you to open an OS level file directly (much like openseq). 2. We've converted a number of D3 clients - but all to UniData. They go very well hth -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles -Original Message- From: Dahn Finard [mailto:[EMAIL PROTECTED] Although I have been working in many pick flavors for the past 20+ years, I have been working in Universe for the past 8 years. I have a client that is looking for a conversion out of D3/NT to Oracle. I have two questions; 1. does D3 support the OPENSEQ and WRITESEQ that Universe does. I downloaded the d3 basic manual and found the UOPEN and UCREATE. 2. Could the D3 experts in the group please offer any suggestion and information about there experiences in conversions from D3. I know that this is not the direction that we would like to see software going in, but I did not make the decision about the companys IS goals. Dahn Finard -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
D3 on NT
Although I have been working in many pick flavors for the past 20+ years, I have been working in Universe for the past 8 years. I have a client that is looking for a conversion out of D3/NT to Oracle. I have two questions; 1. does D3 support the OPENSEQ and WRITESEQ that Universe does. I downloaded the d3 basic manual and found the UOPEN and UCREATE. 2. Could the D3 experts in the group please offer any suggestion and information about there experiences in conversions from D3. I know that this is not the direction that we would like to see software going in, but I did not make the decision about the companys IS goals. Dahn Finard -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users