Re: [U2] DataVu
Yeah right, if you can get it to connect. On 24/10/2011 22:20, David Jordan wrote: The cost is a fraction of Cognos and DataVu provides more development functionality. You also don't have the cost of adding an SQL Server database and work to copy from UniData to the SQL Server that you would normally do with a Cognos environment. There is a development license and web based licenses for users to access the reports. I am not experienced with MITS, but from my knowledge MITS first role is to develop a data warehouse and then has reporting facility against the datawarehouse. It may not be the right tool if you are not building a data warehouse, however I may not be correct in that assessment. DataVu is a tool that allows users to develop visual dashboards and reports from working data rather than data warehouse database like Cognos depends on. However it would make life easier to probably set up a separate account that you put reporting data into. The product is not so much a matter of learning how to use, but about getting your head around how to use it which is no different to other products. DataVu provides flexibility to achieve functionality at a low cost. It resolves a problem that most sites have of giving users more access to querying data themselves. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Tuesday, 25 October 2011 3:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] DataVu Does anyone have solid experience with this product yet? I am particularly interested in the license costs for a Unidata environment and some sense of what development efforts are required and the quality of the results, especially when compared with Cognos or MITS or the others in the space.Cheers,Kebbon ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu
The cost is a fraction of Cognos and DataVu provides more development functionality. You also don't have the cost of adding an SQL Server database and work to copy from UniData to the SQL Server that you would normally do with a Cognos environment. There is a development license and web based licenses for users to access the reports. I am not experienced with MITS, but from my knowledge MITS first role is to develop a data warehouse and then has reporting facility against the datawarehouse. It may not be the right tool if you are not building a data warehouse, however I may not be correct in that assessment. DataVu is a tool that allows users to develop visual dashboards and reports from working data rather than data warehouse database like Cognos depends on. However it would make life easier to probably set up a separate account that you put reporting data into. The product is not so much a matter of learning how to use, but about getting your head around how to use it which is no different to other products. DataVu provides flexibility to achieve functionality at a low cost. It resolves a problem that most sites have of giving users more access to querying data themselves. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Tuesday, 25 October 2011 3:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] DataVu Does anyone have solid experience with this product yet? I am particularly interested in the license costs for a Unidata environment and some sense of what development efforts are required and the quality of the results, especially when compared with Cognos or MITS or the others in the space.Cheers,Kebbon ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] DataVu
Does anyone have solid experience with this product yet? I am particularly interested in the license costs for a Unidata environment and some sense of what development efforts are required and the quality of the results, especially when compared with Cognos or MITS or the others in the space.Cheers,Kebbon ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] DataVu Query and other delights
Just wanted to let everyone know that thanks to Mike Rajkowski and Dan McGrath I've been able to get a query executed in DataVu. It apparently does not like a "D" type dictionary item pointing to attribute 0 other than @ID. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Obviously your install team did not include a 55 year old school teacher and an 8 year old boy! -Original Message- From: David Jordan To: U2 Users List Sent: Wed, Sep 7, 2011 7:45 pm Subject: Re: [U2] DataVu Query [ad] Hi Steve here have been 2 betas and I have been on both and requests were made through he Rocket newsletter. The issues are probably a combination of people mplementing on a broader spectrum of environments than was tested and also an ssue of not being as intuitive to install. Regards avid Jordan -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Steve Romanow ent: Thursday, 8 September 2011 11:27 AM o: U2 Users List ubject: Re: [U2] DataVu Query [ad] That is cool. Wish we could have done a beta and help shake some of these out. Thank you Rocket for continuing to push the platform. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Hi Steve There have been 2 betas and I have been on both and requests were made through the Rocket newsletter. The issues are probably a combination of people implementing on a broader spectrum of environments than was tested and also an issue of not being as intuitive to install. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Thursday, 8 September 2011 11:27 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] That is cool. Wish we could have done a beta and help shake some of these out. Thank you Rocket for continuing to push the platform. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
That is cool. Wish we could have done a beta and help shake some of these out. Thank you Rocket for continuing to push the platform. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
I spoke to Jackie Burhans at Rocket about the issues raised in this list on behalf of the user group and she is putting a team onto looking at how to improve the documentation and installation process for DataVu. This is a product U2 users want to persevere with as it will make U2 stronger in the market and reduce the potential for competitor products pushing U2 out of a site. It needs some issues ironing out, but the potential is great. Regards David Jordan VP U2UG ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query
:-) Bill Haskett - Original Message - *From:* jscha...@gmail.com *To:* U2 Users List *Date:* 9/7/2011 7:38 AM *Subject:* Re: [U2] DataVu Query I've managed to get this installed, define a "repository", successfully connect to it, and construct a simple query. When I run it I get a pop up that says: Applications Error BIC4. 5 Any thoughts? So far, I would not give this to an end user under any circumstances. Running an ODBC query from Excel/MS Query is vastly simpler. I have not completely given up hope yet since I'm early in the process of learning the product and getting used to the interface. Perhaps I'll pause my normal process of "click on stuff and see what it does" and read the 351 page "Getting Started" PDF. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query
I've managed to get this installed, define a "repository", successfully connect to it, and construct a simple query. When I run it I get a pop up that says: Applications Error BIC4. 5 Any thoughts? So far, I would not give this to an end user under any circumstances. Running an ODBC query from Excel/MS Query is vastly simpler. I have not completely given up hope yet since I'm early in the process of learning the product and getting used to the interface. Perhaps I'll pause my normal process of "click on stuff and see what it does" and read the 351 page "Getting Started" PDF. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
I've just been setting up DataVu Query as well and the first thing I've noticed is that the documentation installed by the setup process does not match the version of the software installed. Screens are completely different. Daniel McGrath wrote: CONVERT.SQL is only for UniData. DataVu uses UOJ and JDBC. When you actually *run* the queries it does it via SQL. Remember that DataVu can use more than one data source, including SQL databases. This keeps everything uniform and always you to use those data sources together in a more seamless manner. Regards, Dan Sent from my Verizon Wireless 4GLTE smartphone -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
CONVERT.SQL is only for UniData. DataVu uses UOJ and JDBC. When you actually *run* the queries it does it via SQL. Remember that DataVu can use more than one data source, including SQL databases. This keeps everything uniform and always you to use those data sources together in a more seamless manner. Regards, Dan Sent from my Verizon Wireless 4GLTE smartphone - Reply message - From: "Steve Romanow" To: "U2 Users List" Subject: [U2] DataVu Query [ad] Date: Wed, Sep 7, 2011 7:07 am I am really confused. If it uses UniObjects, there should be very little need for the ODBC driver and CONVERT.SQL. Can we get a clarification on this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
I am really confused. If it uses UniObjects, there should be very little need for the ODBC driver and CONVERT.SQL. Can we get a clarification on this? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
I see a lot of talk about this CONVERT.SQL command. I have never used it. So out of curiosity I'll ask a couple of noob questions... I saw a demo on ODBC for Universe, and the person suggested setting up a new account and creating clean dictionaries for existing files. (by using F pointers). I realize ODBC is a whole other bag of nuts entirely. Could you do this with DataVu, or does that CONVERT.SQL command make changes to the hash file itself, or does it just add dictionaries for SQL? (I have never used SQL in Universe - never saw the point really I guess). On Wed, Sep 7, 2011 at 3:09 AM, Mecki Foerthmann wrote: > I haven't tried the slashes. Maybe that does the trick. > > > > On 07/09/2011 00:08, Wjhonson wrote: > >> I also have a weirdness with that server name. >> Either it wanted the \\ in front or it didn't I can't remember which. >> I do remember fiddling with that field. >> Too bad it can't query "What drives are you attached to anyway?" and give >> me those as options :) >> >> >> >> >> >> >> >> >> >> >> >> -Original Message- >> From: Mecki Foerthmann >> To: u2-users >> > >> Sent: Tue, Sep 6, 2011 4:03 pm >> Subject: Re: [U2] DataVu Query [ad] >> >> >> David, >> I bet you are right, but what users want is to be able to install >> oftware like that without having to search the documentation for hours. >> don't mind if I have to search for and download a JDBC driver from the >> et to connect to SQL Server, DB2 or Oracle data sources but I expect a >> ocket product to work straight away for U2. >> get a screen that asks me for the UD server name and even though that >> ame one works for SB client, VSG, UniAdmin and tools like mvDeveloper >> t won't connect in DataVu. >> ll I found so far is that I need this driver (hell knows where to get >> t from) and a file called bi.jdbc,drivers (or something like that) that >> eeds to be created somewhere by the administrator. >> ell, I am the administrator and I haven't got a clue how to do that! >> >> n 06/09/2011 23:22, David Jordan wrote: >> Mecki >> You do not need a JDBC driver, it uses uniobjects. There is a video >> showing >> ow to install and read the documentation. The installation is not >> intuitive, >> ut it is not hard. I made the mistake first not to read the >> documentation >> hich takes you through step by step. >> >> Regards >> David Jordan >> >> -Original Message- >> From: >> u2-users-bounces@listserver.**u2ug.org[mailto: >> u2-users-bounces@**listserver.u2ug.org >> ] >> n Behalf Of Gerd Forthmann >> Sent: Wednesday, 7 September 2011 1:00 AM >> To: U2 Users List >> Subject: Re: [U2] DataVu Query [ad] >> >> Well, I can't even connect to the host. A get an error message U2DB1004. >> I reckon you guys really need to make this a lot easier if you want >> people tto >> se this and buy the other modules. >> In the documentation it says something about a JDBC driver that needs to >> be >> nstalled but isn't included in the package and some obscure file that >> needs to >> e created somewhere and contains connection data but to me this is just >> Greek >> nd doesn't mean anything. >> Other products like mvDeveloper just work without having to find a driver >> omewhere and create any files by hand. >> I bet you can do better than that. >> >> Mecki >> Original-Nachricht >> >>> Datum: Fri, 2 Sep 2011 17:20:14 + >>> Von: Daniel >>> McGrath >>> > >>> An: U2 Users >>> List >>> > >>> Betreff: Re: [U2] DataVu Query [ad] >>> Okay, so once you download DV Query there is a quick start guide that >>> will tell you what you need to do. >>> >>> You need to run CONVERT.SQL on your files so that it has access to >>> them, but you don't need to worry about creating the schemas with VSG >>> or using HS.ADMIN like you would otherwise. Actually, there is a way >>> to just use UPDATE.SQL.PRIVILEGES to get around this >>> (https://u2tc.rocketsoftware.**com/documentation/1410030.asp<https://u2tc.rocketsoftware.com/documentation/1410030.asp> >>> )**, although we >>> >> ecommend you do the CONVERT.SQL way. >> >>> If you are running older versions of U2 you may need to update >>> XTOOLSUB, which is also a Tech note on TechConnect. >>> >
Re: [U2] DataVu Query [ad]
I haven't tried the slashes. Maybe that does the trick. On 07/09/2011 00:08, Wjhonson wrote: I also have a weirdness with that server name. Either it wanted the \\ in front or it didn't I can't remember which. I do remember fiddling with that field. Too bad it can't query "What drives are you attached to anyway?" and give me those as options :) -Original Message- From: Mecki Foerthmann To: u2-users Sent: Tue, Sep 6, 2011 4:03 pm Subject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install oftware like that without having to search the documentation for hours. don't mind if I have to search for and download a JDBC driver from the et to connect to SQL Server, DB2 or Oracle data sources but I expect a ocket product to work straight away for U2. get a screen that asks me for the UD server name and even though that ame one works for SB client, VSG, UniAdmin and tools like mvDeveloper t won't connect in DataVu. ll I found so far is that I need this driver (hell knows where to get t from) and a file called bi.jdbc,drivers (or something like that) that eeds to be created somewhere by the administrator. ell, I am the administrator and I haven't got a clue how to do that! n 06/09/2011 23:22, David Jordan wrote: Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing ow to install and read the documentation. The installation is not intuitive, ut it is not hard. I made the mistake first not to read the documentation hich takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto se this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be nstalled but isn't included in the package and some obscure file that needs to e created somewhere and contains connection data but to me this is just Greek nd doesn't mean anything. Other products like mvDeveloper just work without having to find a driver omewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht Datum: Fri, 2 Sep 2011 17:20:14 +0000 Von: Daniel McGrath An: U2 Users List Betreff: Re: [U2] DataVu Query [ad] Okay, so once you download DV Query there is a quick start guide that will tell you what you need to do. You need to run CONVERT.SQL on your files so that it has access to them, but you don't need to worry about creating the schemas with VSG or using HS.ADMIN like you would otherwise. Actually, there is a way to just use UPDATE.SQL.PRIVILEGES to get around this (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we ecommend you do the CONVERT.SQL way. If you are running older versions of U2 you may need to update XTOOLSUB, which is also a Tech note on TechConnect. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 11:14 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wrote: Steve: Really? I was looking at DataVu for UniData and I understood that I did need to SQL'ize all my data. So, if I hosted a number of accounts I'd have to go through the entire process of figuring how to duplicate the accounts for SQL file access, keep them all straight, and fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett -- -- - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:45 PM, John Thompson wrote: For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath wrote: I'm not entirely sure on what you want here? DataVu (the free Query and paid Report& Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 User
Re: [U2] DataVu Query [ad]
It doesn't give me a choice which connector to use. As I said, I can connect to UD 5.2 and UD 7.2 on two different servers with any other client software on my PC (SBClient, UniAdmin, mvDeveloper, VSG) by just entering the server name. On 07/09/2011 02:45, David Jordan wrote: Hi Mecki You should not need a jdbc driver, this is why I suspect you maybe using the data connector for RDBMs databases instead of U2 data connector which uses uniobjects. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, 7 September 2011 9:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install software like that without having to search the documentation for hours. I don't mind if I have to search for and download a JDBC driver from the net to connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product to work straight away for U2. I get a screen that asks me for the UD server name and even though that name one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't connect in DataVu. All I found so far is that I need this driver (hell knows where to get it from) and a file called bi.jdbc,drivers (or something like that) that needs to be created somewhere by the administrator. Hell, I am the administrator and I haven't got a clue how to do that! On 06/09/2011 23:22, David Jordan wrote: Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing how to install and read the documentation. The installation is not intuitive, but it is not hard. I made the mistake first not to read the documentation which takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto use this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be installed but isn't included in the package and some obscure file that needs to be created somewhere and contains connection data but to me this is just Greek and doesn't mean anything. Other products like mvDeveloper just work without having to find a driver somewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht Datum: Fri, 2 Sep 2011 17:20:14 + Von: Daniel McGrath An: U2 Users List Betreff: Re: [U2] DataVu Query [ad] Okay, so once you download DV Query there is a quick start guide that will tell you what you need to do. You need to run CONVERT.SQL on your files so that it has access to them, but you don't need to worry about creating the schemas with VSG or using HS.ADMIN like you would otherwise. Actually, there is a way to just use UPDATE.SQL.PRIVILEGES to get around this (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we recommend you do the CONVERT.SQL way. If you are running older versions of U2 you may need to update XTOOLSUB, which is also a Tech note on TechConnect. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 11:14 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wrote: Steve: Really? I was looking at DataVu for UniData and I understood that I did need to SQL'ize all my data. So, if I hosted a number of accounts I'd have to go through the entire process of figuring how to duplicate the accounts for SQL file access, keep them all straight, and fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett -- -- - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:45 PM, John Thompson wrote: For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath wrote: I'm not entirely sure on what you want here? DataVu (the free Query and paid Report& Dashboard products) are querying, reporting and dashboard tools whereas ODBC is jus
Re: [U2] DataVu Query [ad]
Hi Mecki You should not need a jdbc driver, this is why I suspect you maybe using the data connector for RDBMs databases instead of U2 data connector which uses uniobjects. David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, 7 September 2011 9:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install software like that without having to search the documentation for hours. I don't mind if I have to search for and download a JDBC driver from the net to connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product to work straight away for U2. I get a screen that asks me for the UD server name and even though that name one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't connect in DataVu. All I found so far is that I need this driver (hell knows where to get it from) and a file called bi.jdbc,drivers (or something like that) that needs to be created somewhere by the administrator. Hell, I am the administrator and I haven't got a clue how to do that! On 06/09/2011 23:22, David Jordan wrote: > Mecki > You do not need a JDBC driver, it uses uniobjects. There is a video showing > how to install and read the documentation. The installation is not > intuitive, but it is not hard. I made the mistake first not to read the > documentation which takes you through step by step. > > Regards > David Jordan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd > Forthmann > Sent: Wednesday, 7 September 2011 1:00 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Well, I can't even connect to the host. A get an error message U2DB1004. > I reckon you guys really need to make this a lot easier if you want people > tto use this and buy the other modules. > In the documentation it says something about a JDBC driver that needs to be > installed but isn't included in the package and some obscure file that needs > to be created somewhere and contains connection data but to me this is just > Greek and doesn't mean anything. > Other products like mvDeveloper just work without having to find a driver > somewhere and create any files by hand. > I bet you can do better than that. > > Mecki > Original-Nachricht ---- >> Datum: Fri, 2 Sep 2011 17:20:14 + >> Von: Daniel McGrath >> An: U2 Users List >> Betreff: Re: [U2] DataVu Query [ad] >> Okay, so once you download DV Query there is a quick start guide that >> will tell you what you need to do. >> >> You need to run CONVERT.SQL on your files so that it has access to >> them, but you don't need to worry about creating the schemas with VSG >> or using HS.ADMIN like you would otherwise. Actually, there is a way >> to just use UPDATE.SQL.PRIVILEGES to get around this >> (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we >> recommend you do the CONVERT.SQL way. >> >> If you are running older versions of U2 you may need to update >> XTOOLSUB, which is also a Tech note on TechConnect. >> >> -----Original Message- >> From: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve >> Romanow >> Sent: Friday, September 02, 2011 11:14 AM >> To: U2 Users List >> Subject: Re: [U2] DataVu Query [ad] >> >> On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett >> wrote: >>> Steve: >>> >>> Really? I was looking at DataVu for UniData and I understood that I >>> did need to SQL'ize all my data. So, if I hosted a number of >>> accounts I'd have to go through the entire process of figuring how >>> to duplicate the accounts for SQL file access, keep them all >>> straight, and fight with all that this entails. >>> >>> Are you sure I misunderstood this? >>> >>> Thanks, >>> >>> Bill Haskett >>> >>> >>> -- >>> -- >>> - Original Message - >>> *From:* slestak...@gmail.com >>> *To:* U2 Users List >>> *Date:* 9/2/2011 9:47 AM >>> *Subject:* Re: [U2] DataVu Query [ad] >>>> On Fri, Sep 2, 2011 at 12:45 PM, John >>>> Thompson >>>> wrote: >>>>> For example: >>>>> >>>>> If my goal was to teach a fair
Re: [U2] DataVu Query [ad]
I don't think Mecki is that far. I think she cannot connect to the server. -Original Message- From: David Jordan To: U2 Users List Sent: Tue, Sep 6, 2011 5:21 pm Subject: Re: [U2] DataVu Query [ad] Hi Mecki ou need to set up in the UD.ACCOUNTS. Install the xdemo account from the CD nd try connecting to that first. I have installed with UniVerse and I am not s familiar with UniData, you may have to do a CONVERT.SQL, you will need to heck the documentation. I would consider actually setting up a separate ccount with pointers to your live account or even build a mini datawarehouse in separate account to do reporting from. Make sure that you are select the U2 options and not using the SQL database onnectors. There are specific U2 data connections and queries. Regards avid Jordan -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Mecki Foerthmann ent: Wednesday, 7 September 2011 9:02 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install software like hat without having to search the documentation for hours. don't mind if I have to search for and download a JDBC driver from the net to onnect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product o work straight away for U2. get a screen that asks me for the UD server name and even though that name one orks for SB client, VSG, UniAdmin and tools like mvDeveloper it won't connect n DataVu. ll I found so far is that I need this driver (hell knows where to get it from) nd a file called bi.jdbc,drivers (or something like that) that needs to be reated somewhere by the administrator. ell, I am the administrator and I haven't got a clue how to do that! n 06/09/2011 23:22, David Jordan wrote: Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing ow to install and read the documentation. The installation is not intuitive, ut it is not hard. I made the mistake first not to read the documentation hich takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto se this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be nstalled but isn't included in the package and some obscure file that needs to e created somewhere and contains connection data but to me this is just Greek nd doesn't mean anything. Other products like mvDeveloper just work without having to find a driver omewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht > Datum: Fri, 2 Sep 2011 17:20:14 + > Von: Daniel McGrath > An: U2 Users List > Betreff: Re: [U2] DataVu Query [ad] > Okay, so once you download DV Query there is a quick start guide that > will tell you what you need to do. > > You need to run CONVERT.SQL on your files so that it has access to > them, but you don't need to worry about creating the schemas with VSG > or using HS.ADMIN like you would otherwise. Actually, there is a way > to just use UPDATE.SQL.PRIVILEGES to get around this > (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we ecommend you do the CONVERT.SQL way. > > If you are running older versions of U2 you may need to update > XTOOLSUB, which is also a Tech note on TechConnect. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve > Romanow > Sent: Friday, September 02, 2011 11:14 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett > wrote: >> Steve: >> >> Really? I was looking at DataVu for UniData and I understood that I >> did need to SQL'ize all my data. So, if I hosted a number of >> accounts I'd have to go through the entire process of figuring how >> to duplicate the accounts for SQL file access, keep them all >> straight, and fight with all that this entails. >> >> Are you sure I misunderstood this? >> >> Thanks, >> >> Bill Haskett >> >> ---- >> -- >> -- >> - Original Message - >> *From:* slestak...@gmail.com >> *To:* U2 Users List >> *Date:* 9/
Re: [U2] DataVu Query [ad]
Hi Mecki You need to set up in the UD.ACCOUNTS. Install the xdemo account from the CD and try connecting to that first. I have installed with UniVerse and I am not as familiar with UniData, you may have to do a CONVERT.SQL, you will need to check the documentation. I would consider actually setting up a separate account with pointers to your live account or even build a mini datawarehouse in a separate account to do reporting from. Make sure that you are select the U2 options and not using the SQL database connectors. There are specific U2 data connections and queries. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, 7 September 2011 9:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install software like that without having to search the documentation for hours. I don't mind if I have to search for and download a JDBC driver from the net to connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product to work straight away for U2. I get a screen that asks me for the UD server name and even though that name one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't connect in DataVu. All I found so far is that I need this driver (hell knows where to get it from) and a file called bi.jdbc,drivers (or something like that) that needs to be created somewhere by the administrator. Hell, I am the administrator and I haven't got a clue how to do that! On 06/09/2011 23:22, David Jordan wrote: > Mecki > You do not need a JDBC driver, it uses uniobjects. There is a video showing > how to install and read the documentation. The installation is not > intuitive, but it is not hard. I made the mistake first not to read the > documentation which takes you through step by step. > > Regards > David Jordan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd > Forthmann > Sent: Wednesday, 7 September 2011 1:00 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Well, I can't even connect to the host. A get an error message U2DB1004. > I reckon you guys really need to make this a lot easier if you want people > tto use this and buy the other modules. > In the documentation it says something about a JDBC driver that needs to be > installed but isn't included in the package and some obscure file that needs > to be created somewhere and contains connection data but to me this is just > Greek and doesn't mean anything. > Other products like mvDeveloper just work without having to find a driver > somewhere and create any files by hand. > I bet you can do better than that. > > Mecki > Original-Nachricht ---- >> Datum: Fri, 2 Sep 2011 17:20:14 + >> Von: Daniel McGrath >> An: U2 Users List >> Betreff: Re: [U2] DataVu Query [ad] >> Okay, so once you download DV Query there is a quick start guide that >> will tell you what you need to do. >> >> You need to run CONVERT.SQL on your files so that it has access to >> them, but you don't need to worry about creating the schemas with VSG >> or using HS.ADMIN like you would otherwise. Actually, there is a way >> to just use UPDATE.SQL.PRIVILEGES to get around this >> (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we >> recommend you do the CONVERT.SQL way. >> >> If you are running older versions of U2 you may need to update >> XTOOLSUB, which is also a Tech note on TechConnect. >> >> -----Original Message- >> From: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve >> Romanow >> Sent: Friday, September 02, 2011 11:14 AM >> To: U2 Users List >> Subject: Re: [U2] DataVu Query [ad] >> >> On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett >> wrote: >>> Steve: >>> >>> Really? I was looking at DataVu for UniData and I understood that I >>> did need to SQL'ize all my data. So, if I hosted a number of >>> accounts I'd have to go through the entire process of figuring how >>> to duplicate the accounts for SQL file access, keep them all >>> straight, and fight with all that this entails. >>> >>> Are you sure I misunderstood this? >>> >>> Thanks, >>> >>> Bill Haskett >>> >>> >>> -- >>>
Re: [U2] DataVu Query [ad]
I also have a weirdness with that server name. Either it wanted the \\ in front or it didn't I can't remember which. I do remember fiddling with that field. Too bad it can't query "What drives are you attached to anyway?" and give me those as options :) -Original Message- From: Mecki Foerthmann To: u2-users Sent: Tue, Sep 6, 2011 4:03 pm Subject: Re: [U2] DataVu Query [ad] David, I bet you are right, but what users want is to be able to install oftware like that without having to search the documentation for hours. don't mind if I have to search for and download a JDBC driver from the et to connect to SQL Server, DB2 or Oracle data sources but I expect a ocket product to work straight away for U2. get a screen that asks me for the UD server name and even though that ame one works for SB client, VSG, UniAdmin and tools like mvDeveloper t won't connect in DataVu. ll I found so far is that I need this driver (hell knows where to get t from) and a file called bi.jdbc,drivers (or something like that) that eeds to be created somewhere by the administrator. ell, I am the administrator and I haven't got a clue how to do that! n 06/09/2011 23:22, David Jordan wrote: Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing ow to install and read the documentation. The installation is not intuitive, ut it is not hard. I made the mistake first not to read the documentation hich takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto se this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be nstalled but isn't included in the package and some obscure file that needs to e created somewhere and contains connection data but to me this is just Greek nd doesn't mean anything. Other products like mvDeveloper just work without having to find a driver omewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht > Datum: Fri, 2 Sep 2011 17:20:14 + > Von: Daniel McGrath > An: U2 Users List > Betreff: Re: [U2] DataVu Query [ad] > Okay, so once you download DV Query there is a quick start guide that > will tell you what you need to do. > > You need to run CONVERT.SQL on your files so that it has access to > them, but you don't need to worry about creating the schemas with VSG > or using HS.ADMIN like you would otherwise. Actually, there is a way > to just use UPDATE.SQL.PRIVILEGES to get around this > (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we ecommend you do the CONVERT.SQL way. > > If you are running older versions of U2 you may need to update > XTOOLSUB, which is also a Tech note on TechConnect. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve > Romanow > Sent: Friday, September 02, 2011 11:14 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett > wrote: >> Steve: >> >> Really? I was looking at DataVu for UniData and I understood that I >> did need to SQL'ize all my data. So, if I hosted a number of >> accounts I'd have to go through the entire process of figuring how >> to duplicate the accounts for SQL file access, keep them all >> straight, and fight with all that this entails. >> >> Are you sure I misunderstood this? >> >> Thanks, >> >> Bill Haskett >> >> >> -- >> -- >> - Original Message - >> *From:* slestak...@gmail.com >> *To:* U2 Users List >> *Date:* 9/2/2011 9:47 AM >> *Subject:* Re: [U2] DataVu Query [ad] >>> On Fri, Sep 2, 2011 at 12:45 PM, John >>> Thompson >>> wrote: >>>> For example: >>>> >>>> If my goal was to teach a fairly savvy computer user to get data >>>> out of >>>> U2 >>>> into, lets say Excel... without the user coming to ask me to write >>>> some query for them... >>>> >>>> What would be the pros/cons of doing the ODBC way, vs. doing it >>>> the DataVu way? >>>> >>>> Forgive my ignorance... Does that make sense? >
Re: [U2] DataVu Query [ad]
David, I bet you are right, but what users want is to be able to install software like that without having to search the documentation for hours. I don't mind if I have to search for and download a JDBC driver from the net to connect to SQL Server, DB2 or Oracle data sources but I expect a Rocket product to work straight away for U2. I get a screen that asks me for the UD server name and even though that name one works for SB client, VSG, UniAdmin and tools like mvDeveloper it won't connect in DataVu. All I found so far is that I need this driver (hell knows where to get it from) and a file called bi.jdbc,drivers (or something like that) that needs to be created somewhere by the administrator. Hell, I am the administrator and I haven't got a clue how to do that! On 06/09/2011 23:22, David Jordan wrote: Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing how to install and read the documentation. The installation is not intuitive, but it is not hard. I made the mistake first not to read the documentation which takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto use this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be installed but isn't included in the package and some obscure file that needs to be created somewhere and contains connection data but to me this is just Greek and doesn't mean anything. Other products like mvDeveloper just work without having to find a driver somewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht Datum: Fri, 2 Sep 2011 17:20:14 + Von: Daniel McGrath An: U2 Users List Betreff: Re: [U2] DataVu Query [ad] Okay, so once you download DV Query there is a quick start guide that will tell you what you need to do. You need to run CONVERT.SQL on your files so that it has access to them, but you don't need to worry about creating the schemas with VSG or using HS.ADMIN like you would otherwise. Actually, there is a way to just use UPDATE.SQL.PRIVILEGES to get around this (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we recommend you do the CONVERT.SQL way. If you are running older versions of U2 you may need to update XTOOLSUB, which is also a Tech note on TechConnect. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 11:14 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wrote: Steve: Really? I was looking at DataVu for UniData and I understood that I did need to SQL'ize all my data. So, if I hosted a number of accounts I'd have to go through the entire process of figuring how to duplicate the accounts for SQL file access, keep them all straight, and fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett -- -- - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:45 PM, John Thompson wrote: For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath wrote: I'm not entirely sure on what you want here? DataVu (the free Query and paid Report&Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath< dmcgr...@rocketsoftware.com wrote: Free as in free beer on the house. Just install and run. There is no need to authorize. Regards, Dan -Original Message- From: u2-users-boun...@listserv
Re: [U2] DataVu Query [ad]
Mecki You do not need a JDBC driver, it uses uniobjects. There is a video showing how to install and read the documentation. The installation is not intuitive, but it is not hard. I made the mistake first not to read the documentation which takes you through step by step. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, 7 September 2011 1:00 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto use this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be installed but isn't included in the package and some obscure file that needs to be created somewhere and contains connection data but to me this is just Greek and doesn't mean anything. Other products like mvDeveloper just work without having to find a driver somewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht > Datum: Fri, 2 Sep 2011 17:20:14 + > Von: Daniel McGrath > An: U2 Users List > Betreff: Re: [U2] DataVu Query [ad] > Okay, so once you download DV Query there is a quick start guide that > will tell you what you need to do. > > You need to run CONVERT.SQL on your files so that it has access to > them, but you don't need to worry about creating the schemas with VSG > or using HS.ADMIN like you would otherwise. Actually, there is a way > to just use UPDATE.SQL.PRIVILEGES to get around this > (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we > recommend you do the CONVERT.SQL way. > > If you are running older versions of U2 you may need to update > XTOOLSUB, which is also a Tech note on TechConnect. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve > Romanow > Sent: Friday, September 02, 2011 11:14 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett > wrote: > > Steve: > > > > Really? I was looking at DataVu for UniData and I understood that I > > did need to SQL'ize all my data. So, if I hosted a number of > > accounts I'd have to go through the entire process of figuring how > > to duplicate the accounts for SQL file access, keep them all > > straight, and fight with all that this entails. > > > > Are you sure I misunderstood this? > > > > Thanks, > > > > Bill Haskett > > > > -------- > > -- > > -- > > - Original Message - > > *From:* slestak...@gmail.com > > *To:* U2 Users List > > *Date:* 9/2/2011 9:47 AM > > *Subject:* Re: [U2] DataVu Query [ad] > >> > >> On Fri, Sep 2, 2011 at 12:45 PM, John > >> Thompson > >> wrote: > >>> > >>> For example: > >>> > >>> If my goal was to teach a fairly savvy computer user to get data > >>> out of > >>> U2 > >>> into, lets say Excel... without the user coming to ask me to write > >>> some query for them... > >>> > >>> What would be the pros/cons of doing the ODBC way, vs. doing it > >>> the DataVu way? > >>> > >>> Forgive my ignorance... Does that make sense? > >>> > >>> On Fri, Sep 2, 2011 at 12:41 PM, Daniel > >>> McGrath >>>> > >>>> wrote: > >>>> I'm not entirely sure on what you want here? > >>>> > >>>> DataVu (the free Query and paid Report& Dashboard products) are > >>>> querying, reporting and dashboard tools whereas ODBC is just an > >>>> interface. > >>>> > >>>> > >>>> -Original Message- > >>>> From: u2-users-boun...@listserver.u2ug.org [mailto: > >>>> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > >>>> Sent: Friday, September 02, 2011 10:36 AM > >>>> To: U2 Users List > >>>> Subject: Re: [U2] DataVu Query [ad] > >>>> > >>>> Is there a comparison chart of DataVu vs. ODBC? > >>>> > >>>> I am planning on investigating both for reporting purposes, but, > >>>> I was just curious if there was anything out there that listed >
Re: [U2] DataVu Query [ad]
Well, I can't even connect to the host. A get an error message U2DB1004. I reckon you guys really need to make this a lot easier if you want people tto use this and buy the other modules. In the documentation it says something about a JDBC driver that needs to be installed but isn't included in the package and some obscure file that needs to be created somewhere and contains connection data but to me this is just Greek and doesn't mean anything. Other products like mvDeveloper just work without having to find a driver somewhere and create any files by hand. I bet you can do better than that. Mecki Original-Nachricht > Datum: Fri, 2 Sep 2011 17:20:14 + > Von: Daniel McGrath > An: U2 Users List > Betreff: Re: [U2] DataVu Query [ad] > Okay, so once you download DV Query there is a quick start guide that will > tell you what you need to do. > > You need to run CONVERT.SQL on your files so that it has access to them, > but you don't need to worry about creating the schemas with VSG or using > HS.ADMIN like you would otherwise. Actually, there is a way to just use > UPDATE.SQL.PRIVILEGES to get around this > (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we > recommend you do the CONVERT.SQL way. > > If you are running older versions of U2 you may need to update XTOOLSUB, > which is also a Tech note on TechConnect. > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow > Sent: Friday, September 02, 2011 11:14 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett > wrote: > > Steve: > > > > Really? I was looking at DataVu for UniData and I understood that I > > did need to SQL'ize all my data. So, if I hosted a number of accounts > > I'd have to go through the entire process of figuring how to duplicate > > the accounts for SQL file access, keep them all straight, and fight > > with all that this entails. > > > > Are you sure I misunderstood this? > > > > Thanks, > > > > Bill Haskett > > > > ------ > > -- > > - Original Message - > > *From:* slestak...@gmail.com > > *To:* U2 Users List > > *Date:* 9/2/2011 9:47 AM > > *Subject:* Re: [U2] DataVu Query [ad] > >> > >> On Fri, Sep 2, 2011 at 12:45 PM, John > >> Thompson > >> wrote: > >>> > >>> For example: > >>> > >>> If my goal was to teach a fairly savvy computer user to get data out > >>> of > >>> U2 > >>> into, lets say Excel... without the user coming to ask me to write > >>> some query for them... > >>> > >>> What would be the pros/cons of doing the ODBC way, vs. doing it the > >>> DataVu way? > >>> > >>> Forgive my ignorance... Does that make sense? > >>> > >>> On Fri, Sep 2, 2011 at 12:41 PM, Daniel > >>> McGrath >>>> > >>>> wrote: > >>>> I'm not entirely sure on what you want here? > >>>> > >>>> DataVu (the free Query and paid Report& Dashboard products) are > >>>> querying, reporting and dashboard tools whereas ODBC is just an > >>>> interface. > >>>> > >>>> > >>>> -Original Message- > >>>> From: u2-users-boun...@listserver.u2ug.org [mailto: > >>>> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > >>>> Sent: Friday, September 02, 2011 10:36 AM > >>>> To: U2 Users List > >>>> Subject: Re: [U2] DataVu Query [ad] > >>>> > >>>> Is there a comparison chart of DataVu vs. ODBC? > >>>> > >>>> I am planning on investigating both for reporting purposes, but, I > >>>> was just curious if there was anything out there that listed the > >>>> pros and cons of both in a nice little table. > >>>> > >>>> > >>>> On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath< > >>>> dmcgr...@rocketsoftware.com > >>>>> > >>>>> wrote: > >>>>> Free as in free beer on the house. > >>>>> > >>>>> Just install and run. There is no need to authorize. > >>>>> > >>>>> Regards, > >>>>> Dan > >&
Re: [U2] DataVu Query [ad]
This is what I get. I cannot access ApplicationData on my machine, which bothers me. meh. win7. http://screencast.com/t/c3QI4gs6 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Uh yeah. Ok here's one. Instead of "error BD10456342!!.blah gobbly gook" maybe something a human can understand :) Having, as I have, a brilliant mind, it only took me five minutes or so to figure out that possibly, it can't figure out what files are in my account because it's seeing a menu pop up when it logs in as me, on login, and has no idea what to do with THAT, so it barfs all over my backseat. Very rude! Instead of an actual application account, I changed it to point at UV which has no menu and voila up comes the list of files. So I'm at step 1B now. -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 1:41 pm Subject: Re: [U2] DataVu Query [ad] If you can think of any instructions that made it hard to work, instructions hat are missing or anything else that will make it easier for first time users eg, Gotcha's that might affect some people we have missed), let us know. The est way for us to make it better is if people give us some constructive eedback (u2as...@rs.com) to work with :) As a side note, the DataVu 2.0 link on the front page now works (thanks Will & teve) Regards, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Friday, September 02, 2011 2:36 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] DataVu Query [ad] After 45 minutes of trying different things I finally got to step 1. -Original Message- rom: Daniel McGrath o: U2 Users List ent: Fri, Sep 2, 2011 1:25 pm ubject: Re: [U2] DataVu Query [ad] ust to clarify, this is only an issue for UniData (because by default it denies L access, until you update the privileges). In UniVerse it is as simple as inting it to your host, typing in your credentials and selecting the account. n fact, I just did it on my machine with the SBDEMO account in under 5 minutes. t is also correct this is a benefit of the Rocket Acquisition. You will find at going forward will be able to increasingly leverage the other R&D assets of e rest of Rocket to bring new products and tighter integrations to the MV orld hen we have previously. egards, n Original Message- om: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] Behalf Of Steve Romanow nt: Friday, September 02, 2011 12:42 PM : U2 Users List bject: Re: [U2] DataVu Query [ad] ill, think you are correct. I was hoping and praying for straight UoJ connection o ata, not shoehorned SQL. teve _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
On Fri, Sep 2, 2011 at 4:41 PM, Daniel McGrath wrote: > If you can think of any instructions that made it hard to work, instructions > that are missing or anything else that will make it easier for first time > users (eg, Gotcha's that might affect some people we have missed), let us > know. The best way for us to make it better is if people give us some > constructive feedback (u2as...@rs.com) to work with :) > > As a side note, the DataVu 2.0 link on the front page now works (thanks Will > & Steve) > > Regards, > Dan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson > Sent: Friday, September 02, 2011 2:36 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] DataVu Query [ad] > > After 45 minutes of trying different things I finally got to step 1. > > > > > > > > > > -Original Message----- > From: Daniel McGrath > To: U2 Users List > Sent: Fri, Sep 2, 2011 1:25 pm > Subject: Re: [U2] DataVu Query [ad] > > > Just to clarify, this is only an issue for UniData (because by default it > denies QL access, until you update the privileges). In UniVerse it is as > simple as ointing it to your host, typing in your credentials and selecting > the account. > In fact, I just did it on my machine with the SBDEMO account in under 5 > minutes. > It is also correct this is a benefit of the Rocket Acquisition. You will find > hat going forward will be able to increasingly leverage the other R&D assets > of he rest of Rocket to bring new products and tighter integrations to the MV > orld then we have previously. > Regards, > an > -Original Message- > rom: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] > n Behalf Of Steve Romanow > ent: Friday, September 02, 2011 12:42 PM > o: U2 Users List > ubject: Re: [U2] DataVu Query [ad] > Bill, > I think you are correct. I was hoping and praying for straight UoJ > connection o data, not shoehorned SQL. > Steve > __ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > __ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > I am having trouble with licensing. I had 1.0 installed previously (uninstalled) but when I launch 2.0, i get a dialog stating there is a problem and it closes DataVue. I do not get a chance to get to Manage License. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
If you can think of any instructions that made it hard to work, instructions that are missing or anything else that will make it easier for first time users (eg, Gotcha's that might affect some people we have missed), let us know. The best way for us to make it better is if people give us some constructive feedback (u2as...@rs.com) to work with :) As a side note, the DataVu 2.0 link on the front page now works (thanks Will & Steve) Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, September 02, 2011 2:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] After 45 minutes of trying different things I finally got to step 1. -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 1:25 pm Subject: Re: [U2] DataVu Query [ad] Just to clarify, this is only an issue for UniData (because by default it denies QL access, until you update the privileges). In UniVerse it is as simple as ointing it to your host, typing in your credentials and selecting the account. In fact, I just did it on my machine with the SBDEMO account in under 5 minutes. It is also correct this is a benefit of the Rocket Acquisition. You will find hat going forward will be able to increasingly leverage the other R&D assets of he rest of Rocket to bring new products and tighter integrations to the MV orld then we have previously. Regards, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Steve Romanow ent: Friday, September 02, 2011 12:42 PM o: U2 Users List ubject: Re: [U2] DataVu Query [ad] Bill, I think you are correct. I was hoping and praying for straight UoJ connection o data, not shoehorned SQL. Steve __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
After 45 minutes of trying different things I finally got to step 1. -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 1:25 pm Subject: Re: [U2] DataVu Query [ad] Just to clarify, this is only an issue for UniData (because by default it denies QL access, until you update the privileges). In UniVerse it is as simple as ointing it to your host, typing in your credentials and selecting the account. In fact, I just did it on my machine with the SBDEMO account in under 5 minutes. It is also correct this is a benefit of the Rocket Acquisition. You will find hat going forward will be able to increasingly leverage the other R&D assets of he rest of Rocket to bring new products and tighter integrations to the MV orld then we have previously. Regards, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Steve Romanow ent: Friday, September 02, 2011 12:42 PM o: U2 Users List ubject: Re: [U2] DataVu Query [ad] Bill, I think you are correct. I was hoping and praying for straight UoJ connection o data, not shoehorned SQL. Steve __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Just to clarify, this is only an issue for UniData (because by default it denies SQL access, until you update the privileges). In UniVerse it is as simple as pointing it to your host, typing in your credentials and selecting the account. In fact, I just did it on my machine with the SBDEMO account in under 5 minutes. It is also correct this is a benefit of the Rocket Acquisition. You will find that going forward will be able to increasingly leverage the other R&D assets of the rest of Rocket to bring new products and tighter integrations to the MV world then we have previously. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 12:42 PM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Bill, I think you are correct. I was hoping and praying for straight UoJ connection to data, not shoehorned SQL. Steve ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
I think this was another Rocket acquisition that was 're-engineered' so it could talk to U2. Hence the reason it's using SQL. I could be wrong... but I don't think I am! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 1:42 PM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Bill, I think you are correct. I was hoping and praying for straight UoJ connection to data, not shoehorned SQL. Steve ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Bill, I think you are correct. I was hoping and praying for straight UoJ connection to data, not shoehorned SQL. Steve ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Wow. That's a dog who is not going to run. "Setting Up a UniData Account n order to access your files in U2 Data Vu, you need to properly set up our UniData account. To do this you must add your account to the D.ACCOUNT file, use the CONVERT.SQL command to make your files SQL ompliant, and then grant appropriate privileges for access to the files." -Original Message- From: Bill Haskett To: U2 Users List Sent: Fri, Sep 2, 2011 11:36 am Subject: Re: [U2] DataVu Query [ad] Steve: Sorry, but I don't think that's right. I remember getting excited and ownloading the product. Then when I was reviewing the installation nstructions I seemed to run into a myriad of issues I'd have to vercome in development, let alone in production. For instance, according to the Quick Start Guide: Setting Up a UniData Account n order to access your files in U2 Data Vu, you need to properly set up our UniData account. To do this you must add your account to the D.ACCOUNT file, use the CONVERT.SQL command to make your files SQL ompliant, and then grant appropriate privileges for access to the files. This isn't exactly pain free, nor anywhere as easy as Mits or Informer eemed to be (I could install and see my files and create a query and et a spreadsheet through a web browser in our Windows environment). I ay just be the paradigm I was having problems with, but DataVu didn't eem either easy to install, configure, use, or put into production. This doesn't mean I'm saying your wrong, or any such thing. It's just hat the product looked a lot more complicated and difficult than other ptions I've been looking into. Bill Original Message - From:* slestak...@gmail.com To:* U2 Users List Date:* 9/2/2011 10:14 AM Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wrote: > Steve: > > Really? I was looking at DataVu for UniData and I understood that I did > need to SQL'ize all my data. So, if I hosted a number of accounts I'd have > to go through the entire process of figuring how to duplicate the accounts > for SQL file access, keep them all straight, and fight with all that this > entails. > > Are you sure I misunderstood this? > > Thanks, > > Bill Haskett > > > - Original Message - > *From:* slestak...@gmail.com > *To:* U2 Users List > *Date:* 9/2/2011 9:47 AM > *Subject:* Re: [U2] DataVu Query [ad] >> On Fri, Sep 2, 2011 at 12:45 PM, John Thompson >> wrote: >>> For example: >>> >>> If my goal was to teach a fairly savvy computer user to get data out of >>> U2 >>> into, lets say Excel... without the user coming to ask me to write some >>> query for them... >>> >>> What would be the pros/cons of doing the ODBC way, vs. doing it the >>> DataVu >>> way? >>> >>> Forgive my ignorance... Does that make sense? >>> >>> On Fri, Sep 2, 2011 at 12:41 PM, Daniel >>> McGrath>>> wrote: >>>> I'm not entirely sure on what you want here? >>>> >>>> DataVu (the free Query and paid Report&Dashboard products) are >>>> querying, >>>> reporting and dashboard tools whereas ODBC is just an interface. >>>> >>>> >>>> -Original Message- >>>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>>> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >>>> Sent: Friday, September 02, 2011 10:36 AM >>>> To: U2 Users List >>>> Subject: Re: [U2] DataVu Query [ad] >>>> >>>> Is there a comparison chart of DataVu vs. ODBC? >>>> >>>> I am planning on investigating both for reporting purposes, but, I was >>>> just >>>> curious if there was anything out there that listed the pros and cons of >>>> both in a nice little table. >>>> >>>> >>>> On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath< >>>> dmcgr...@rocketsoftware.com >>>>> wrote: >>>>> Free as in free beer on the house. >>>>> >>>>> Just install and run. There is no need to authorize. >>>>> >>>>> Regards, >>>>> Dan >>>>> >>>>> -Original Message- >>>>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>>>> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >>>>> Sent: Friday, September 0
Re: [U2] DataVu Query [ad]
Steve: Sorry, but I don't think that's right. I remember getting excited and downloading the product. Then when I was reviewing the installation instructions I seemed to run into a myriad of issues I'd have to overcome in development, let alone in production. For instance, according to the Quick Start Guide: Setting Up a UniData Account In order to access your files in U2 Data Vu, you need to properly set up your UniData account. To do this you must add your account to the UD.ACCOUNT file, use the CONVERT.SQL command to make your files SQL compliant, and then grant appropriate privileges for access to the files. This isn't exactly pain free, nor anywhere as easy as Mits or Informer seemed to be (I could install and see my files and create a query and get a spreadsheet through a web browser in our Windows environment). I may just be the paradigm I was having problems with, but DataVu didn't seem either easy to install, configure, use, or put into production. This doesn't mean I'm saying your wrong, or any such thing. It's just that the product looked a lot more complicated and difficult than other options I've been looking into. Bill - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List *Date:* 9/2/2011 10:14 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wrote: Steve: Really? I was looking at DataVu for UniData and I understood that I did need to SQL'ize all my data. So, if I hosted a number of accounts I'd have to go through the entire process of figuring how to duplicate the accounts for SQL file access, keep them all straight, and fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:45 PM, John Thompson wrote: For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath wrote: I'm not entirely sure on what you want here? DataVu (the free Query and paid Report&Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath< dmcgr...@rocketsoftware.com wrote: Free as in free beer on the house. Just install and run. There is no need to authorize. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:20 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is this a licensed product? Or does it come with the U2 licenses we have purchased? On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath< dmcgr...@rocketsoftware.com wrote: Since DataVu Query recently came up here, I thought I should let you all know we have just released a new version of the free DataVu Query tool (v2.0.1) We have introduced new capabilities to combine your queries and results. You can filter and quickly create charts with just a couple of clicks. Also, a new quick start wizard guides you through the steps to connect to your U2 data so you can quickly get up and running with U2 DataVu Query. You can download this from our downloads page. Don't forget we have videos available on U2DevZone on the 'Accelerate' page. Regards, Dan McGrath U2 Product Manager Rocket Software Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson __
Re: [U2] DataVu Query [ad]
Think of repository as a 'project' It stores the metadata about your how you built your queries locally, but it runs the actually queries and retrieves the data from your U2 database itself. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, September 02, 2011 11:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] This requires a repository? It doesn't query directly into the Universe database itself? -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 10:09 am Subject: Re: [U2] DataVu Query [ad] I think you will find savvy computer users will find this fairly easy to use. our best bet would be to check out 'Building Queries' video on U2 Dev Zone https://u2devzone.rocketsoftware.com/accelerate/resources/videos/u2datavu/u2-datavu-part-4-query-building/view egards, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of John Thompson ent: Friday, September 02, 2011 10:46 AM o: U2 Users List ubject: Re: [U2] DataVu Query [ad] For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, ets say Excel... without the user coming to ask me to write some query for hem... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath I'm not entirely sure on what you want here? DataVu (the free Query and paid Report & Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < dmcgr...@rocketsoftware.com > wrote: > Free as in free beer on the house. > > Just install and run. There is no need to authorize. > > Regards, > Dan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:20 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is this a licensed product? Or does it come with the U2 licenses we > have purchased? > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Since DataVu Query recently came up here, I thought I should let > > you all know we have just released a new version of the free > > DataVu Query tool > > (v2.0.1) > > > > We have introduced new capabilities to combine your queries and results. > > You can filter and quickly create charts with just a couple of clicks. > > Also, a new quick start wizard guides you through the steps to > > connect to your U2 data so you can quickly get up and running with > > U2 DataVu Query. You can download this from our downloads page. > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > page. > > > > Regards, > > > > Dan McGrath > > U2 Product Manager > > Rocket Software > > Web: www.rocketsoftware.com/u2 > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mail
Re: [U2] DataVu Query [ad]
On 02/09/11 17:47, Steve Romanow wrote: > The odbc way requires you to use VSG to normalize your U2 data. > DataVue does not. I'm sure someone will correct me if I'm wrong, but ... Aiui, ODBC (on UV at least) is no longer a native data access technology, but it sits on top of OleDB. So if you can avoid ODBC you should. I'm also pretty sure I've accessed UV data files, using SQL, without ODBC-ising them. The results have been a bit strange on occasion, thanks to unclean dictionaries, but it's been a lot easier than getting ODBC to work. If DataVue accesses the database using the same technique, it would be far better than ODBC. Cheers, Wol > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Okay, so once you download DV Query there is a quick start guide that will tell you what you need to do. You need to run CONVERT.SQL on your files so that it has access to them, but you don't need to worry about creating the schemas with VSG or using HS.ADMIN like you would otherwise. Actually, there is a way to just use UPDATE.SQL.PRIVILEGES to get around this (https://u2tc.rocketsoftware.com/documentation/1410030.asp), although we recommend you do the CONVERT.SQL way. If you are running older versions of U2 you may need to update XTOOLSUB, which is also a Tech note on TechConnect. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 11:14 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wrote: > Steve: > > Really? I was looking at DataVu for UniData and I understood that I > did need to SQL'ize all my data. So, if I hosted a number of accounts > I'd have to go through the entire process of figuring how to duplicate > the accounts for SQL file access, keep them all straight, and fight > with all that this entails. > > Are you sure I misunderstood this? > > Thanks, > > Bill Haskett > > -- > -- > - Original Message - > *From:* slestak...@gmail.com > *To:* U2 Users List > *Date:* 9/2/2011 9:47 AM > *Subject:* Re: [U2] DataVu Query [ad] >> >> On Fri, Sep 2, 2011 at 12:45 PM, John >> Thompson >> wrote: >>> >>> For example: >>> >>> If my goal was to teach a fairly savvy computer user to get data out >>> of >>> U2 >>> into, lets say Excel... without the user coming to ask me to write >>> some query for them... >>> >>> What would be the pros/cons of doing the ODBC way, vs. doing it the >>> DataVu way? >>> >>> Forgive my ignorance... Does that make sense? >>> >>> On Fri, Sep 2, 2011 at 12:41 PM, Daniel >>> McGrath>>> >>>> wrote: >>>> I'm not entirely sure on what you want here? >>>> >>>> DataVu (the free Query and paid Report& Dashboard products) are >>>> querying, reporting and dashboard tools whereas ODBC is just an >>>> interface. >>>> >>>> >>>> -Original Message- >>>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>>> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >>>> Sent: Friday, September 02, 2011 10:36 AM >>>> To: U2 Users List >>>> Subject: Re: [U2] DataVu Query [ad] >>>> >>>> Is there a comparison chart of DataVu vs. ODBC? >>>> >>>> I am planning on investigating both for reporting purposes, but, I >>>> was just curious if there was anything out there that listed the >>>> pros and cons of both in a nice little table. >>>> >>>> >>>> On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath< >>>> dmcgr...@rocketsoftware.com >>>>> >>>>> wrote: >>>>> Free as in free beer on the house. >>>>> >>>>> Just install and run. There is no need to authorize. >>>>> >>>>> Regards, >>>>> Dan >>>>> >>>>> -Original Message- >>>>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>>>> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >>>>> Sent: Friday, September 02, 2011 10:20 AM >>>>> To: U2 Users List >>>>> Subject: Re: [U2] DataVu Query [ad] >>>>> >>>>> Is this a licensed product? Or does it come with the U2 licenses >>>>> we have purchased? >>>>> >>>>> On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath< >>>>> dmcgr...@rocketsoftware.com >>>>>> >>>>>> wrote: >>>>>> Since DataVu Query recently came up here, I thought I should let >>>>>> you all know we have just released a new version of the free >>>>>> DataVu Query tool >>>>>> (v2.0.1) >>>>>> >>>>>> We have introduced new capabilities to combine your queries and >>>> >>>> results. >>>>>> >>>>>> You can filter and quickly create charts with just a couple of >>>&g
Re: [U2] DataVu Query [ad]
This requires a repository? It doesn't query directly into the Universe database itself? -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 10:09 am Subject: Re: [U2] DataVu Query [ad] I think you will find savvy computer users will find this fairly easy to use. our best bet would be to check out 'Building Queries' video on U2 Dev Zone https://u2devzone.rocketsoftware.com/accelerate/resources/videos/u2datavu/u2-datavu-part-4-query-building/view egards, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of John Thompson ent: Friday, September 02, 2011 10:46 AM o: U2 Users List ubject: Re: [U2] DataVu Query [ad] For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, ets say Excel... without the user coming to ask me to write some query for hem... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath I'm not entirely sure on what you want here? DataVu (the free Query and paid Report & Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < dmcgr...@rocketsoftware.com > wrote: > Free as in free beer on the house. > > Just install and run. There is no need to authorize. > > Regards, > Dan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:20 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is this a licensed product? Or does it come with the U2 licenses we > have purchased? > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Since DataVu Query recently came up here, I thought I should let > > you all know we have just released a new version of the free > > DataVu Query tool > > (v2.0.1) > > > > We have introduced new capabilities to combine your queries and results. > > You can filter and quickly create charts with just a couple of clicks. > > Also, a new quick start wizard guides you through the steps to > > connect to your U2 data so you can quickly get up and running with > > U2 DataVu Query. You can download this from our downloads page. > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > page. > > > > Regards, > > > > Dan McGrath > > U2 Product Manager > > Rocket Software > > Web: www.rocketsoftware.com/u2 > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
On Fri, Sep 2, 2011 at 1:04 PM, Bill Haskett wrote: > Steve: > > Really? I was looking at DataVu for UniData and I understood that I did > need to SQL'ize all my data. So, if I hosted a number of accounts I'd have > to go through the entire process of figuring how to duplicate the accounts > for SQL file access, keep them all straight, and fight with all that this > entails. > > Are you sure I misunderstood this? > > Thanks, > > Bill Haskett > > > - Original Message - > *From:* slestak...@gmail.com > *To:* U2 Users List > *Date:* 9/2/2011 9:47 AM > *Subject:* Re: [U2] DataVu Query [ad] >> >> On Fri, Sep 2, 2011 at 12:45 PM, John Thompson >> wrote: >>> >>> For example: >>> >>> If my goal was to teach a fairly savvy computer user to get data out of >>> U2 >>> into, lets say Excel... without the user coming to ask me to write some >>> query for them... >>> >>> What would be the pros/cons of doing the ODBC way, vs. doing it the >>> DataVu >>> way? >>> >>> Forgive my ignorance... Does that make sense? >>> >>> On Fri, Sep 2, 2011 at 12:41 PM, Daniel >>> McGrath>>> >>>> wrote: >>>> I'm not entirely sure on what you want here? >>>> >>>> DataVu (the free Query and paid Report& Dashboard products) are >>>> querying, >>>> reporting and dashboard tools whereas ODBC is just an interface. >>>> >>>> >>>> -Original Message- >>>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>>> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >>>> Sent: Friday, September 02, 2011 10:36 AM >>>> To: U2 Users List >>>> Subject: Re: [U2] DataVu Query [ad] >>>> >>>> Is there a comparison chart of DataVu vs. ODBC? >>>> >>>> I am planning on investigating both for reporting purposes, but, I was >>>> just >>>> curious if there was anything out there that listed the pros and cons of >>>> both in a nice little table. >>>> >>>> >>>> On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath< >>>> dmcgr...@rocketsoftware.com >>>>> >>>>> wrote: >>>>> Free as in free beer on the house. >>>>> >>>>> Just install and run. There is no need to authorize. >>>>> >>>>> Regards, >>>>> Dan >>>>> >>>>> -Original Message- >>>>> From: u2-users-boun...@listserver.u2ug.org [mailto: >>>>> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >>>>> Sent: Friday, September 02, 2011 10:20 AM >>>>> To: U2 Users List >>>>> Subject: Re: [U2] DataVu Query [ad] >>>>> >>>>> Is this a licensed product? Or does it come with the U2 licenses we >>>>> have purchased? >>>>> >>>>> On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath< >>>>> dmcgr...@rocketsoftware.com >>>>>> >>>>>> wrote: >>>>>> Since DataVu Query recently came up here, I thought I should let you >>>>>> all know we have just released a new version of the free DataVu >>>>>> Query tool >>>>>> (v2.0.1) >>>>>> >>>>>> We have introduced new capabilities to combine your queries and >>>> >>>> results. >>>>>> >>>>>> You can filter and quickly create charts with just a couple of >>>>>> clicks. >>>>>> Also, a new quick start wizard guides you through the steps to >>>>>> connect to your U2 data so you can quickly get up and running with >>>>>> U2 DataVu Query. You can download this from our downloads page. >>>>>> >>>>>> Don't forget we have videos available on U2DevZone on the 'Accelerate' >>>>>> page. >>>>>> >>>>>> Regards, >>>>>> >>>>>> Dan McGrath >>>>>> U2 Product Manager >>>>>> Rocket Software >>>>>> Web: www.rocketsoftware.com/u2 >>>>>> >>>>>> ___ >>>>>> U2-Users mailing list >>&
Re: [U2] DataVu Query [ad]
Ok thanks. I'll check it out. On Fri, Sep 2, 2011 at 12:59 PM, Wjhonson wrote: > > I loaded to the Pickwiki, code which will output the first 10 VOC entries > as an HTML table and then launch it with Accuterm into whatever browser you > have. > > I don't know anything about FTWIZ, looks like a file transfer tool, doesn't > seem closely related to me. > You can use the core concepts of my code to also create csv or tab > delimited files which should open in Excel as well btw. > > You can also add the code snippets or a subroutine to any report you have > to make it pop up in Excel or as an HTML table. > > > > > > > -Original Message- > From: John Thompson > To: U2 Users List > Sent: Fri, Sep 2, 2011 9:55 am > Subject: Re: [U2] DataVu Query [ad] > > > Yes... but, Accuterm FTWIZ can be quite slow when pulling a lot of data. > Although, I have not had much time to mess with the New Version of Accuterm > , so it may have improved. > Also the last time I checked, its difficult for FTWIZ to get data from > ultiple files, unless you want to spend your life doing translates. > My understanding was that the ODBC for Universe would actually normalize > the > ata for you if you had a new set of clean dictionaries setup properly in a > lean account. > Maybe this is what I should do for the Accuterm stuff too Like I said, > ts on the project list, but, I have not got that far in the heap yet... Any > dvice appreciated. > On Fri, Sep 2, 2011 at 12:47 PM, Wjhonson wrote: > > John don't you use Accuterm? > > > > > > -Original Message- > From: John Thompson > To: U2 Users List > Sent: Fri, Sep 2, 2011 9:46 am > Subject: Re: [U2] DataVu Query [ad] > > > For example: > If my goal was to teach a fairly savvy computer user to get data out of U2 > nto, lets say Excel... without the user coming to ask me to write some > uery for them... > What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu > ay? > Forgive my ignorance... Does that make sense? > On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > wrote: > > I'm not entirely sure on what you want here? > > DataVu (the free Query and paid Report & Dashboard products) are querying, > reporting and dashboard tools whereas ODBC is just an interface. > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:36 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is there a comparison chart of DataVu vs. ODBC? > > I am planning on investigating both for reporting purposes, but, I was > just > curious if there was anything out there that listed the pros and cons of > both in a nice little table. > > > On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Free as in free beer on the house. > > > > Just install and run. There is no need to authorize. > > > > Regards, > > Dan > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto: > > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > > Sent: Friday, September 02, 2011 10:20 AM > > To: U2 Users List > > Subject: Re: [U2] DataVu Query [ad] > > > > Is this a licensed product? Or does it come with the U2 licenses we > > have purchased? > > > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > > dmcgr...@rocketsoftware.com > > > wrote: > > > > > Since DataVu Query recently came up here, I thought I should let you > > > all know we have just released a new version of the free DataVu > > > Query tool > > > (v2.0.1) > > > > > > We have introduced new capabilities to combine your queries and > results. > > > You can filter and quickly create charts with just a couple of > clicks. > > > Also, a new quick start wizard guides you through the steps to > > > connect to your U2 data so you can quickly get up and running with > > > U2 DataVu Query. You can download this from our downloads page. > > > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > > page. > > > > > > Regards, > > > > > > Dan McGrath > > > U2 Product Manager > > > Rocket Software > > > Web: www.
Re: [U2] DataVu Query [ad]
I think you will find savvy computer users will find this fairly easy to use. Your best bet would be to check out 'Building Queries' video on U2 Dev Zone https://u2devzone.rocketsoftware.com/accelerate/resources/videos/u2datavu/u2-datavu-part-4-query-building/view Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:46 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath wrote: > I'm not entirely sure on what you want here? > > DataVu (the free Query and paid Report & Dashboard products) are > querying, reporting and dashboard tools whereas ODBC is just an interface. > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:36 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is there a comparison chart of DataVu vs. ODBC? > > I am planning on investigating both for reporting purposes, but, I was > just curious if there was anything out there that listed the pros and > cons of both in a nice little table. > > > On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Free as in free beer on the house. > > > > Just install and run. There is no need to authorize. > > > > Regards, > > Dan > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto: > > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > > Sent: Friday, September 02, 2011 10:20 AM > > To: U2 Users List > > Subject: Re: [U2] DataVu Query [ad] > > > > Is this a licensed product? Or does it come with the U2 licenses we > > have purchased? > > > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > > dmcgr...@rocketsoftware.com > > > wrote: > > > > > Since DataVu Query recently came up here, I thought I should let > > > you all know we have just released a new version of the free > > > DataVu Query tool > > > (v2.0.1) > > > > > > We have introduced new capabilities to combine your queries and > results. > > > You can filter and quickly create charts with just a couple of clicks. > > > Also, a new quick start wizard guides you through the steps to > > > connect to your U2 data so you can quickly get up and running with > > > U2 DataVu Query. You can download this from our downloads page. > > > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > > page. > > > > > > Regards, > > > > > > Dan McGrath > > > U2 Product Manager > > > Rocket Software > > > Web: www.rocketsoftware.com/u2 > > > > > > ___ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > > > > -- > > John Thompson > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Steve: Really? I was looking at DataVu for UniData and I understood that I did need to SQL'ize all my data. So, if I hosted a number of accounts I'd have to go through the entire process of figuring how to duplicate the accounts for SQL file access, keep them all straight, and fight with all that this entails. Are you sure I misunderstood this? Thanks, Bill Haskett - Original Message - *From:* slestak...@gmail.com *To:* U2 Users List *Date:* 9/2/2011 9:47 AM *Subject:* Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:45 PM, John Thompson wrote: For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath wrote: I'm not entirely sure on what you want here? DataVu (the free Query and paid Report& Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath< dmcgr...@rocketsoftware.com wrote: Free as in free beer on the house. Just install and run. There is no need to authorize. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:20 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is this a licensed product? Or does it come with the U2 licenses we have purchased? On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath< dmcgr...@rocketsoftware.com wrote: Since DataVu Query recently came up here, I thought I should let you all know we have just released a new version of the free DataVu Query tool (v2.0.1) We have introduced new capabilities to combine your queries and results. You can filter and quickly create charts with just a couple of clicks. Also, a new quick start wizard guides you through the steps to connect to your U2 data so you can quickly get up and running with U2 DataVu Query. You can download this from our downloads page. Don't forget we have videos available on U2DevZone on the 'Accelerate' page. Regards, Dan McGrath U2 Product Manager Rocket Software Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The odbc way requires you to use VSG to normalize your U2 data. DataVue does not. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
I loaded to the Pickwiki, code which will output the first 10 VOC entries as an HTML table and then launch it with Accuterm into whatever browser you have. I don't know anything about FTWIZ, looks like a file transfer tool, doesn't seem closely related to me. You can use the core concepts of my code to also create csv or tab delimited files which should open in Excel as well btw. You can also add the code snippets or a subroutine to any report you have to make it pop up in Excel or as an HTML table. -Original Message- From: John Thompson To: U2 Users List Sent: Fri, Sep 2, 2011 9:55 am Subject: Re: [U2] DataVu Query [ad] Yes... but, Accuterm FTWIZ can be quite slow when pulling a lot of data. Although, I have not had much time to mess with the New Version of Accuterm , so it may have improved. Also the last time I checked, its difficult for FTWIZ to get data from ultiple files, unless you want to spend your life doing translates. My understanding was that the ODBC for Universe would actually normalize the ata for you if you had a new set of clean dictionaries setup properly in a lean account. Maybe this is what I should do for the Accuterm stuff too Like I said, ts on the project list, but, I have not got that far in the heap yet... Any dvice appreciated. On Fri, Sep 2, 2011 at 12:47 PM, Wjhonson wrote: > John don't you use Accuterm? -Original Message- From: John Thompson To: U2 Users List Sent: Fri, Sep 2, 2011 9:46 am Subject: Re: [U2] DataVu Query [ad] For example: If my goal was to teach a fairly savvy computer user to get data out of U2 nto, lets say Excel... without the user coming to ask me to write some uery for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu ay? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath < dmcgr...@rocketsoftware.com wrote: > I'm not entirely sure on what you want here? DataVu (the free Query and paid Report & Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < dmcgr...@rocketsoftware.com > wrote: > Free as in free beer on the house. > > Just install and run. There is no need to authorize. > > Regards, > Dan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:20 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is this a licensed product? Or does it come with the U2 licenses we > have purchased? > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Since DataVu Query recently came up here, I thought I should let you > > all know we have just released a new version of the free DataVu > > Query tool > > (v2.0.1) > > > > We have introduced new capabilities to combine your queries and results. > > You can filter and quickly create charts with just a couple of clicks. > > Also, a new quick start wizard guides you through the steps to > > connect to your U2 data so you can quickly get up and running with > > U2 DataVu Query. You can download this from our downloads page. > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > page. > > > > Regards, > > > > Dan McGrath > > U2 Product Manager > > Rocket Software > > Web: www.rocketsoftware.com/u2 > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompso
Re: [U2] DataVu Query [ad]
Yes... but, Accuterm FTWIZ can be quite slow when pulling a lot of data. Although, I have not had much time to mess with the New Version of Accuterm 7, so it may have improved. Also the last time I checked, its difficult for FTWIZ to get data from multiple files, unless you want to spend your life doing translates. My understanding was that the ODBC for Universe would actually normalize the data for you if you had a new set of clean dictionaries setup properly in a clean account. Maybe this is what I should do for the Accuterm stuff too Like I said, its on the project list, but, I have not got that far in the heap yet... Any advice appreciated. On Fri, Sep 2, 2011 at 12:47 PM, Wjhonson wrote: > John don't you use Accuterm? > > > > > > -Original Message- > From: John Thompson > To: U2 Users List > Sent: Fri, Sep 2, 2011 9:46 am > Subject: Re: [U2] DataVu Query [ad] > > > For example: > If my goal was to teach a fairly savvy computer user to get data out of U2 > nto, lets say Excel... without the user coming to ask me to write some > uery for them... > What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu > ay? > Forgive my ignorance... Does that make sense? > On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > wrote: > > I'm not entirely sure on what you want here? > > DataVu (the free Query and paid Report & Dashboard products) are querying, > reporting and dashboard tools whereas ODBC is just an interface. > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:36 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is there a comparison chart of DataVu vs. ODBC? > > I am planning on investigating both for reporting purposes, but, I was > just > curious if there was anything out there that listed the pros and cons of > both in a nice little table. > > > On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Free as in free beer on the house. > > > > Just install and run. There is no need to authorize. > > > > Regards, > > Dan > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto: > > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > > Sent: Friday, September 02, 2011 10:20 AM > > To: U2 Users List > > Subject: Re: [U2] DataVu Query [ad] > > > > Is this a licensed product? Or does it come with the U2 licenses we > > have purchased? > > > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > > dmcgr...@rocketsoftware.com > > > wrote: > > > > > Since DataVu Query recently came up here, I thought I should let you > > > all know we have just released a new version of the free DataVu > > > Query tool > > > (v2.0.1) > > > > > > We have introduced new capabilities to combine your queries and > results. > > > You can filter and quickly create charts with just a couple of > clicks. > > > Also, a new quick start wizard guides you through the steps to > > > connect to your U2 data so you can quickly get up and running with > > > U2 DataVu Query. You can download this from our downloads page. > > > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > > page. > > > > > > Regards, > > > > > > Dan McGrath > > > U2 Product Manager > > > Rocket Software > > > Web: www.rocketsoftware.com/u2 > > > > > > ___ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > > > > -- > > John Thompson > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > -- > ohn Thompson > __ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
If you click on DataVu Query here ( http://www.rocketsoftware.com/u2/resources/downloads ) it should take you where you need to go. And thanks Steve, I'll get that address straight away. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, September 02, 2011 10:48 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] Give us the direct link to the download page -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 9:46 am Subject: Re: [U2] DataVu Query [ad] Can you let me know which page so I can address it? I just successfully started downloading, so I'm not sure where to look. Thanks, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Friday, September 02, 2011 10:43 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] DataVu Query [ad] We’re sorry, but that page doesn’t exist… Ha! So Rocket is looking to hire a website developer? -Original Message- rom: Daniel McGrath o: U2 Users List ent: Fri, Sep 2, 2011 9:31 am ubject: Re: [U2] DataVu Query [ad] ree as in free beer on the house. ust install and run. There is no need to authorize. egards, n Original Message- om: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] Behalf Of John Thompson nt: Friday, September 02, 2011 10:20 AM : U2 Users List bject: Re: [U2] DataVu Query [ad] s this a licensed product? Or does it come with the U2 licenses we have rchased? n Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath http://listserver.u2ug.org/mailman/listinfo/u2-users - hn Thompson _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
On Fri, Sep 2, 2011 at 12:48 PM, Wjhonson wrote: > Give us the direct link to the download page > > > > > > -Original Message- > From: Daniel McGrath > To: U2 Users List > Sent: Fri, Sep 2, 2011 9:46 am > Subject: Re: [U2] DataVu Query [ad] > > > Can you let me know which page so I can address it? > I just successfully started downloading, so I'm not sure where to look. > Thanks, > an > -Original Message- > rom: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] > n Behalf Of Wjhonson > ent: Friday, September 02, 2011 10:43 AM > o: u2-users@listserver.u2ug.org > ubject: Re: [U2] DataVu Query [ad] > We’re sorry, but that page doesn’t exist… > > Ha! So Rocket is looking to hire a website developer? > > > -Original Message----- > rom: Daniel McGrath > o: U2 Users List > ent: Fri, Sep 2, 2011 9:31 am > ubject: Re: [U2] DataVu Query [ad] > > ree as in free beer on the house. > ust install and run. There is no need to authorize. > egards, > n > Original Message- > om: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] > Behalf Of John Thompson > nt: Friday, September 02, 2011 10:20 AM > : U2 Users List > bject: Re: [U2] DataVu Query [ad] > s this a licensed product? Or does it come with the U2 licenses we have > rchased? > n Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath wrote: > Since DataVu Query recently came up here, I thought I should let you > all know we have just released a new version of the free DataVu Query tool > (v2.0.1) > We have introduced new capabilities to combine your queries and results. > You can filter and quickly create charts with just a couple of clicks. > Also, a new quick start wizard guides you through the steps to connect to > your > 2 data so you can quickly get up and running with U2 DataVu Query. You can > ownload this from our downloads page. > Don't forget we have videos available on U2DevZone on the 'Accelerate' > page. > Regards, > Dan McGrath > U2 Product Manager > Rocket Software > Web: www.rocketsoftware.com/u2 > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > - > hn Thompson > _ > -Users mailing list > -us...@listserver.u2ug.org > tp://listserver.u2ug.org/mailman/listinfo/u2-users > _ > -Users mailing list > -us...@listserver.u2ug.org > tp://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > __ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > http://screencast.com/t/iCP0GRu8iCP4 Here is where the error is Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
We’re sorry, but that page doesn’t exist… Ha! So Rocket is looking to hire a website developer? -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 9:31 am Subject: Re: [U2] DataVu Query [ad] Free as in free beer on the house. Just install and run. There is no need to authorize. Regards, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of John Thompson ent: Friday, September 02, 2011 10:20 AM o: U2 Users List ubject: Re: [U2] DataVu Query [ad] Is this a licensed product? Or does it come with the U2 licenses we have urchased? On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath Since DataVu Query recently came up here, I thought I should let you all know we have just released a new version of the free DataVu Query tool (v2.0.1) We have introduced new capabilities to combine your queries and results. You can filter and quickly create charts with just a couple of clicks. Also, a new quick start wizard guides you through the steps to connect to your U2 data so you can quickly get up and running with U2 DataVu Query. You can download this from our downloads page. Don't forget we have videos available on U2DevZone on the 'Accelerate' page. Regards, Dan McGrath U2 Product Manager Rocket Software Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Give us the direct link to the download page -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 9:46 am Subject: Re: [U2] DataVu Query [ad] Can you let me know which page so I can address it? I just successfully started downloading, so I'm not sure where to look. Thanks, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Friday, September 02, 2011 10:43 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] DataVu Query [ad] We’re sorry, but that page doesn’t exist… Ha! So Rocket is looking to hire a website developer? -Original Message- rom: Daniel McGrath o: U2 Users List ent: Fri, Sep 2, 2011 9:31 am ubject: Re: [U2] DataVu Query [ad] ree as in free beer on the house. ust install and run. There is no need to authorize. egards, n Original Message- om: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] Behalf Of John Thompson nt: Friday, September 02, 2011 10:20 AM : U2 Users List bject: Re: [U2] DataVu Query [ad] s this a licensed product? Or does it come with the U2 licenses we have rchased? n Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath http://listserver.u2ug.org/mailman/listinfo/u2-users - hn Thompson _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
John don't you use Accuterm? -Original Message- From: John Thompson To: U2 Users List Sent: Fri, Sep 2, 2011 9:46 am Subject: Re: [U2] DataVu Query [ad] For example: If my goal was to teach a fairly savvy computer user to get data out of U2 nto, lets say Excel... without the user coming to ask me to write some uery for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu ay? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath I'm not entirely sure on what you want here? DataVu (the free Query and paid Report & Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < dmcgr...@rocketsoftware.com > wrote: > Free as in free beer on the house. > > Just install and run. There is no need to authorize. > > Regards, > Dan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:20 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is this a licensed product? Or does it come with the U2 licenses we > have purchased? > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Since DataVu Query recently came up here, I thought I should let you > > all know we have just released a new version of the free DataVu > > Query tool > > (v2.0.1) > > > > We have introduced new capabilities to combine your queries and results. > > You can filter and quickly create charts with just a couple of clicks. > > Also, a new quick start wizard guides you through the steps to > > connect to your U2 data so you can quickly get up and running with > > U2 DataVu Query. You can download this from our downloads page. > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > page. > > > > Regards, > > > > Dan McGrath > > U2 Product Manager > > Rocket Software > > Web: www.rocketsoftware.com/u2 > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
On Fri, Sep 2, 2011 at 12:46 PM, Daniel McGrath wrote: > Can you let me know which page so I can address it? > > I just successfully started downloading, so I'm not sure where to look. > > Thanks, > Dan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson > Sent: Friday, September 02, 2011 10:43 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] DataVu Query [ad] > > We’re sorry, but that page doesn’t exist… > > > > Ha! So Rocket is looking to hire a website developer? > > > > > > -Original Message- > From: Daniel McGrath > To: U2 Users List > Sent: Fri, Sep 2, 2011 9:31 am > Subject: Re: [U2] DataVu Query [ad] > > > Free as in free beer on the house. > Just install and run. There is no need to authorize. > Regards, > an > -Original Message- > rom: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] > n Behalf Of John Thompson > ent: Friday, September 02, 2011 10:20 AM > o: U2 Users List > ubject: Re: [U2] DataVu Query [ad] > Is this a licensed product? Or does it come with the U2 licenses we have > urchased? > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath wrote: >> Since DataVu Query recently came up here, I thought I should let you > all know we have just released a new version of the free DataVu Query tool > (v2.0.1) > > We have introduced new capabilities to combine your queries and results. > You can filter and quickly create charts with just a couple of clicks. > Also, a new quick start wizard guides you through the steps to connect to > your U2 data so you can quickly get up and running with U2 DataVu Query. You > can download this from our downloads page. > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > page. > > Regards, > > Dan McGrath > U2 Product Manager > Rocket Software > Web: www.rocketsoftware.com/u2 > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > -- > ohn Thompson > __ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > __ > 2-Users mailing list > 2-us...@listserver.u2ug.org > ttp://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > The rocket page on the front page has an image for DataVue2.0 and that leads to a broken link ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
On Fri, Sep 2, 2011 at 12:45 PM, John Thompson wrote: > For example: > > If my goal was to teach a fairly savvy computer user to get data out of U2 > into, lets say Excel... without the user coming to ask me to write some > query for them... > > What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu > way? > > Forgive my ignorance... Does that make sense? > > On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath > wrote: > >> I'm not entirely sure on what you want here? >> >> DataVu (the free Query and paid Report & Dashboard products) are querying, >> reporting and dashboard tools whereas ODBC is just an interface. >> >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >> Sent: Friday, September 02, 2011 10:36 AM >> To: U2 Users List >> Subject: Re: [U2] DataVu Query [ad] >> >> Is there a comparison chart of DataVu vs. ODBC? >> >> I am planning on investigating both for reporting purposes, but, I was just >> curious if there was anything out there that listed the pros and cons of >> both in a nice little table. >> >> >> On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < >> dmcgr...@rocketsoftware.com >> > wrote: >> >> > Free as in free beer on the house. >> > >> > Just install and run. There is no need to authorize. >> > >> > Regards, >> > Dan >> > >> > -Original Message- >> > From: u2-users-boun...@listserver.u2ug.org [mailto: >> > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >> > Sent: Friday, September 02, 2011 10:20 AM >> > To: U2 Users List >> > Subject: Re: [U2] DataVu Query [ad] >> > >> > Is this a licensed product? Or does it come with the U2 licenses we >> > have purchased? >> > >> > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < >> > dmcgr...@rocketsoftware.com >> > > wrote: >> > >> > > Since DataVu Query recently came up here, I thought I should let you >> > > all know we have just released a new version of the free DataVu >> > > Query tool >> > > (v2.0.1) >> > > >> > > We have introduced new capabilities to combine your queries and >> results. >> > > You can filter and quickly create charts with just a couple of clicks. >> > > Also, a new quick start wizard guides you through the steps to >> > > connect to your U2 data so you can quickly get up and running with >> > > U2 DataVu Query. You can download this from our downloads page. >> > > >> > > Don't forget we have videos available on U2DevZone on the 'Accelerate' >> > > page. >> > > >> > > Regards, >> > > >> > > Dan McGrath >> > > U2 Product Manager >> > > Rocket Software >> > > Web: www.rocketsoftware.com/u2 >> > > >> > > ___ >> > > U2-Users mailing list >> > > U2-Users@listserver.u2ug.org >> > > http://listserver.u2ug.org/mailman/listinfo/u2-users >> > > >> > >> > >> > >> > -- >> > John Thompson >> > ___ >> > U2-Users mailing list >> > U2-Users@listserver.u2ug.org >> > http://listserver.u2ug.org/mailman/listinfo/u2-users >> > ___ >> > U2-Users mailing list >> > U2-Users@listserver.u2ug.org >> > http://listserver.u2ug.org/mailman/listinfo/u2-users >> > >> >> >> >> -- >> John Thompson >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > The odbc way requires you to use VSG to normalize your U2 data. DataVue does not. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Can you let me know which page so I can address it? I just successfully started downloading, so I'm not sure where to look. Thanks, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, September 02, 2011 10:43 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DataVu Query [ad] We’re sorry, but that page doesn’t exist… Ha! So Rocket is looking to hire a website developer? -Original Message- From: Daniel McGrath To: U2 Users List Sent: Fri, Sep 2, 2011 9:31 am Subject: Re: [U2] DataVu Query [ad] Free as in free beer on the house. Just install and run. There is no need to authorize. Regards, an -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of John Thompson ent: Friday, September 02, 2011 10:20 AM o: U2 Users List ubject: Re: [U2] DataVu Query [ad] Is this a licensed product? Or does it come with the U2 licenses we have urchased? On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath Since DataVu Query recently came up here, I thought I should let you all know we have just released a new version of the free DataVu Query tool (v2.0.1) We have introduced new capabilities to combine your queries and results. You can filter and quickly create charts with just a couple of clicks. Also, a new quick start wizard guides you through the steps to connect to your U2 data so you can quickly get up and running with U2 DataVu Query. You can download this from our downloads page. Don't forget we have videos available on U2DevZone on the 'Accelerate' page. Regards, Dan McGrath U2 Product Manager Rocket Software Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
For example: If my goal was to teach a fairly savvy computer user to get data out of U2 into, lets say Excel... without the user coming to ask me to write some query for them... What would be the pros/cons of doing the ODBC way, vs. doing it the DataVu way? Forgive my ignorance... Does that make sense? On Fri, Sep 2, 2011 at 12:41 PM, Daniel McGrath wrote: > I'm not entirely sure on what you want here? > > DataVu (the free Query and paid Report & Dashboard products) are querying, > reporting and dashboard tools whereas ODBC is just an interface. > > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:36 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is there a comparison chart of DataVu vs. ODBC? > > I am planning on investigating both for reporting purposes, but, I was just > curious if there was anything out there that listed the pros and cons of > both in a nice little table. > > > On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Free as in free beer on the house. > > > > Just install and run. There is no need to authorize. > > > > Regards, > > Dan > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto: > > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > > Sent: Friday, September 02, 2011 10:20 AM > > To: U2 Users List > > Subject: Re: [U2] DataVu Query [ad] > > > > Is this a licensed product? Or does it come with the U2 licenses we > > have purchased? > > > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > > dmcgr...@rocketsoftware.com > > > wrote: > > > > > Since DataVu Query recently came up here, I thought I should let you > > > all know we have just released a new version of the free DataVu > > > Query tool > > > (v2.0.1) > > > > > > We have introduced new capabilities to combine your queries and > results. > > > You can filter and quickly create charts with just a couple of clicks. > > > Also, a new quick start wizard guides you through the steps to > > > connect to your U2 data so you can quickly get up and running with > > > U2 DataVu Query. You can download this from our downloads page. > > > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > > page. > > > > > > Regards, > > > > > > Dan McGrath > > > U2 Product Manager > > > Rocket Software > > > Web: www.rocketsoftware.com/u2 > > > > > > ___ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > > > > -- > > John Thompson > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Thanks Steve. Yes, DV Report (as well as Dashboard) is a separate product that is licensed. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, September 02, 2011 10:41 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] On Fri, Sep 2, 2011 at 12:36 PM, John Thompson wrote: > Is there a comparison chart of DataVu vs. ODBC? > > I am planning on investigating both for reporting purposes, but, I was > just curious if there was anything out there that listed the pros and > cons of both in a nice little table. > > > On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath > > wrote: > >> Free as in free beer on the house. >> >> Just install and run. There is no need to authorize. >> >> Regards, >> Dan >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >> Sent: Friday, September 02, 2011 10:20 AM >> To: U2 Users List >> Subject: Re: [U2] DataVu Query [ad] >> >> Is this a licensed product? Or does it come with the U2 licenses we >> have purchased? >> >> On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < >> dmcgr...@rocketsoftware.com >> > wrote: >> >> > Since DataVu Query recently came up here, I thought I should let >> > you all know we have just released a new version of the free DataVu >> > Query tool >> > (v2.0.1) >> > >> > We have introduced new capabilities to combine your queries and results. >> > You can filter and quickly create charts with just a couple of clicks. >> > Also, a new quick start wizard guides you through the steps to >> > connect to your U2 data so you can quickly get up and running with >> > U2 DataVu Query. You can download this from our downloads page. >> > >> > Don't forget we have videos available on U2DevZone on the 'Accelerate' >> > page. >> > >> > Regards, >> > >> > Dan McGrath >> > U2 Product Manager >> > Rocket Software >> > Web: www.rocketsoftware.com/u2 >> > >> > ___ >> > U2-Users mailing list >> > U2-Users@listserver.u2ug.org >> > http://listserver.u2ug.org/mailman/listinfo/u2-users >> > >> >> >> >> -- >> John Thompson >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > Giving it a try now. TY guys. DV Report is a sep licensed product? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
I'm not entirely sure on what you want here? DataVu (the free Query and paid Report & Dashboard products) are querying, reporting and dashboard tools whereas ODBC is just an interface. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:36 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath wrote: > Free as in free beer on the house. > > Just install and run. There is no need to authorize. > > Regards, > Dan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:20 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is this a licensed product? Or does it come with the U2 licenses we > have purchased? > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Since DataVu Query recently came up here, I thought I should let you > > all know we have just released a new version of the free DataVu > > Query tool > > (v2.0.1) > > > > We have introduced new capabilities to combine your queries and results. > > You can filter and quickly create charts with just a couple of clicks. > > Also, a new quick start wizard guides you through the steps to > > connect to your U2 data so you can quickly get up and running with > > U2 DataVu Query. You can download this from our downloads page. > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > page. > > > > Regards, > > > > Dan McGrath > > U2 Product Manager > > Rocket Software > > Web: www.rocketsoftware.com/u2 > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
On Fri, Sep 2, 2011 at 12:36 PM, John Thompson wrote: > Is there a comparison chart of DataVu vs. ODBC? > > I am planning on investigating both for reporting purposes, but, I was just > curious if there was anything out there that listed the pros and cons of > both in a nice little table. > > > On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath > wrote: > >> Free as in free beer on the house. >> >> Just install and run. There is no need to authorize. >> >> Regards, >> Dan >> >> -Original Message- >> From: u2-users-boun...@listserver.u2ug.org [mailto: >> u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson >> Sent: Friday, September 02, 2011 10:20 AM >> To: U2 Users List >> Subject: Re: [U2] DataVu Query [ad] >> >> Is this a licensed product? Or does it come with the U2 licenses we have >> purchased? >> >> On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < >> dmcgr...@rocketsoftware.com >> > wrote: >> >> > Since DataVu Query recently came up here, I thought I should let you >> > all know we have just released a new version of the free DataVu Query >> > tool >> > (v2.0.1) >> > >> > We have introduced new capabilities to combine your queries and results. >> > You can filter and quickly create charts with just a couple of clicks. >> > Also, a new quick start wizard guides you through the steps to connect >> > to your U2 data so you can quickly get up and running with U2 DataVu >> > Query. You can download this from our downloads page. >> > >> > Don't forget we have videos available on U2DevZone on the 'Accelerate' >> > page. >> > >> > Regards, >> > >> > Dan McGrath >> > U2 Product Manager >> > Rocket Software >> > Web: www.rocketsoftware.com/u2 >> > >> > ___ >> > U2-Users mailing list >> > U2-Users@listserver.u2ug.org >> > http://listserver.u2ug.org/mailman/listinfo/u2-users >> > >> >> >> >> -- >> John Thompson >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> ___ >> U2-Users mailing list >> U2-Users@listserver.u2ug.org >> http://listserver.u2ug.org/mailman/listinfo/u2-users >> > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > Giving it a try now. TY guys. DV Report is a sep licensed product? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Is there a comparison chart of DataVu vs. ODBC? I am planning on investigating both for reporting purposes, but, I was just curious if there was anything out there that listed the pros and cons of both in a nice little table. On Fri, Sep 2, 2011 at 12:31 PM, Daniel McGrath wrote: > Free as in free beer on the house. > > Just install and run. There is no need to authorize. > > Regards, > Dan > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, September 02, 2011 10:20 AM > To: U2 Users List > Subject: Re: [U2] DataVu Query [ad] > > Is this a licensed product? Or does it come with the U2 licenses we have > purchased? > > On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath < > dmcgr...@rocketsoftware.com > > wrote: > > > Since DataVu Query recently came up here, I thought I should let you > > all know we have just released a new version of the free DataVu Query > > tool > > (v2.0.1) > > > > We have introduced new capabilities to combine your queries and results. > > You can filter and quickly create charts with just a couple of clicks. > > Also, a new quick start wizard guides you through the steps to connect > > to your U2 data so you can quickly get up and running with U2 DataVu > > Query. You can download this from our downloads page. > > > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > > page. > > > > Regards, > > > > Dan McGrath > > U2 Product Manager > > Rocket Software > > Web: www.rocketsoftware.com/u2 > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Free as in free beer on the house. Just install and run. There is no need to authorize. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, September 02, 2011 10:20 AM To: U2 Users List Subject: Re: [U2] DataVu Query [ad] Is this a licensed product? Or does it come with the U2 licenses we have purchased? On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath wrote: > Since DataVu Query recently came up here, I thought I should let you > all know we have just released a new version of the free DataVu Query > tool > (v2.0.1) > > We have introduced new capabilities to combine your queries and results. > You can filter and quickly create charts with just a couple of clicks. > Also, a new quick start wizard guides you through the steps to connect > to your U2 data so you can quickly get up and running with U2 DataVu > Query. You can download this from our downloads page. > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > page. > > Regards, > > Dan McGrath > U2 Product Manager > Rocket Software > Web: www.rocketsoftware.com/u2 > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
Is this a licensed product? Or does it come with the U2 licenses we have purchased? On Fri, Sep 2, 2011 at 12:10 PM, Daniel McGrath wrote: > Since DataVu Query recently came up here, I thought I should let you all > know we have just released a new version of the free DataVu Query tool > (v2.0.1) > > We have introduced new capabilities to combine your queries and results. > You can filter and quickly create charts with just a couple of clicks. > Also, a new quick start wizard guides you through the steps to connect to > your U2 data so you can quickly get up and running with U2 DataVu Query. You > can download this from our downloads page. > > Don't forget we have videos available on U2DevZone on the 'Accelerate' > page. > > Regards, > > Dan McGrath > U2 Product Manager > Rocket Software > Web: www.rocketsoftware.com/u2 > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] DataVu Query [ad]
Since DataVu Query recently came up here, I thought I should let you all know we have just released a new version of the free DataVu Query tool (v2.0.1) We have introduced new capabilities to combine your queries and results. You can filter and quickly create charts with just a couple of clicks. Also, a new quick start wizard guides you through the steps to connect to your U2 data so you can quickly get up and running with U2 DataVu Query. You can download this from our downloads page. Don't forget we have videos available on U2DevZone on the 'Accelerate' page. Regards, Dan McGrath U2 Product Manager Rocket Software Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
Thanks for the response, Michael. The VOC entry for UD.ACCOUNT, in the data account chosen in the connection setup, is being overwritten. Prior to making the connection the VOC entry for UD.ACCOUNT is as follows: 001: F 002: c:\program files\ibm\ud71\sys\UD.ACCOUNT 003: c:\program files\ibm\ud71\sys\D_UD.ACCOUNT After selecting the the data account the VOC entry for UD.ACCOUNT is changed to: 001: F 002: ..\sys\UD.ACCOUNT 003: ..\sys\D_UD.ACCOUNT (the path for the data account is e:\data account name) I think U2 DataVu Query should not be overwriting the path to UD.ACCOUNT in the data account. Comments would be appreciated. Bruce W. McAdoo Wagner & Brown, Ltd. bmca...@wbltd.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael Byrne Sent: Monday, December 06, 2010 9:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 DataVu Query You need to use CONVERT.SQL on UniData files (not for UniVerse files) for them to be visible. You may also need to GRANT privileges for specific users depending on what username will be connecting. There is a small mention of this in the readme that comes with the download. The following would make it available to all users. CONVERT.SQL MYFILE PUBLIC Michael Bruce McAdoo wrote: > > Using unidata 7.1, testing U2 DataVu Query, established and tested > connection successfully, but unable to have any data files displayed > to select via the Create New U2 Query. I was able to view files and create > U2 Query when I use the DEMO account. Any ideas would be greatly > appreciated. > > Bruce W. McAdoo > Wagner & Brown, Ltd. > bmca...@wbltd.com<mailto:bmca...@wbltd.com> > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/U2-DataVu-Query-tp30261771p30389822.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
You need to use CONVERT.SQL on UniData files (not for UniVerse files) for them to be visible. You may also need to GRANT privileges for specific users depending on what username will be connecting. There is a small mention of this in the readme that comes with the download. The following would make it available to all users. CONVERT.SQL MYFILE PUBLIC Michael Bruce McAdoo wrote: > > Using unidata 7.1, testing U2 DataVu Query, established and tested > connection successfully, but unable to have any data files displayed to > select via the Create New U2 Query. I was able to view files and create > U2 Query when I use the DEMO account. Any ideas would be greatly > appreciated. > > Bruce W. McAdoo > Wagner & Brown, Ltd. > bmca...@wbltd.com<mailto:bmca...@wbltd.com> > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- View this message in context: http://old.nabble.com/U2-DataVu-Query-tp30261771p30389822.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
You need to populate that UD.ACCOUNT with a record for that UD.ACCOUNT. You can either manually create it or use UniAdmin to update an already created account. You may also need to fill in the description field. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Saturday, 20 November 2010 8:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 DataVu Query Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner & Brown, Ltd. bmca...@wbltd.com<mailto:bmca...@wbltd.com> ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
Thanks Doug, but actually the file UD.ACCOUNT in the sys account exists and is not missing. The VOC entry of UD.ACCOUNT in the account I'm trying to query (with U2 DataVu Query) seems to be changing after trying to display files via the Create New U2 Query. The VOC entry prior to trying to display files via the Create New U2 Query: 001: F 002: c:\program files\ibm\ud71\sys\UD.ACCOUNT 003: c:\program files\ibm\ud71\sys\D_UD.ACCOUNT The VOC entry after trying to display files via the Create New U2 Query: 001: F 002: ..\sys\UD.ACCOUNT 003: ..\sys\D_UD.ACCOUNT The account I'm trying to query is actually on an alternate drive (e:\). Does anyone know if this is the problem, or a solution to resolve tis problem? Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner & Brown, Ltd. bmca...@wbltd.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, November 19, 2010 3:47 PM To: 'U2 Users List' Subject: Re: [U2] U2 DataVu Query You are missing a file in the sys account called UD.ACCOUNT. There is a tech note for BDT on that problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Friday, November 19, 2010 2:46 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 DataVu Query Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner & Brown, Ltd. bmca...@wbltd.com<mailto:bmca...@wbltd.com> ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
You are missing a file in the sys account called UD.ACCOUNT. There is a tech note for BDT on that problem. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Friday, November 19, 2010 2:46 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2 DataVu Query Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner & Brown, Ltd. bmca...@wbltd.com<mailto:bmca...@wbltd.com> ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 DataVu Query
Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner & Brown, Ltd. bmca...@wbltd.com<mailto:bmca...@wbltd.com> ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users