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 +0000 >> Von: Daniel McGrath<dmcgr...@rocketsoftware.com> >> An: U2 Users List<u2-users@listserver.u2ug.org> >> 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<wphask...@advantos.net> >> 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<u2-users@listserver.u2ug.org> >>> *Date:* 9/2/2011 9:47 AM >>> *Subject:* Re: [U2] DataVu Query [ad] >>>> On Fri, Sep 2, 2011 at 12:45 PM, John >>>> Thompson<jthompson...@gmail.com> >>>> 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<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 >>>>>> >>>>> -- >>>>> 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 >>> >> On this page >> >> http://www.rocketsoftware.com/u2/u2/products/datavu/offer >> >> it states >> >> "No VSG Schemas for UniData or HS.ADMIN setup for UniVerse are >> required to access your U2 data. Click here to download this free >> tool together with its example database to get started using U2 DataVu >> Query." >> _______________________________________________ >> 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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users