Search Results

Search results 1-10 of 10.

  • User Avatar

    We use the MS SQL Server Management Studio 2008 R2. The nvarchar fields are of different lengths, ranging from 6 to 80. thx in advance 4 ur willingness to help! best regards, Boris Jost

  • User Avatar

    We just changed our ERP software and are now in the process of adapting our ETL connections and extracts to the new SQL Database. The connection works, however when previewing the data, only two fields appear with values. All other fields are empty. All the empty fields are defined as nvarchar in our SQL-DB. In our old ERP-System these fields had a varchar format. Could this be the reason why these fields are all empty? thx in advance, boris jost

  • User Avatar

    hey Pommie, am relieved to read i'm not the only one out there having occasional trouble reading thru these manuals:-). thx for the solidarity all the best, boris

  • User Avatar

    thx for that tip too, Sivgin! had a quick look at it and it indeed looks quite complicated! making an easy to use GUI might not be that easy after all... ...keeping in mind that Kais wrote that Jedox has been working on one for the past 1-2 yrs already. regards, boris

  • User Avatar

    thx, realquo, that's an excellent idea. will work on a direct ODBC connection and will gladly revert back in case of problems. regards, boris

  • User Avatar

    thx for the link, Kais. glad to see there's something in the pipeline (attention: i mean the product devpt pipeline used in marketing language, not the PALO-pipeline:-) as far as GUI is concerned. in our little 10-man company we don't have an internal IT specialist, but i got a friend to help me out a bit y'day and at least he gave me the basics of xml scripts, and SQL queries. now i'll try and adapt that importrelDB example to my specific needs. you all convinced me not to give up on this just …

  • User Avatar

    allright, thanks, Kais, i get it. It might seem to you that I don't read your manual but believe me, that's not the case. I have desperately TRIED TO UNDERSTAND what is meant in that manual. Now I might want to add that I am an agronomist by education and presently work as the CEO of our company and by no means am an IT-specialist. And since your products are supposedly straightforward, simple and easy-to-use (see the somewhat misleading wording on your homepage: "Einfach, schnell und flexibel D…

  • User Avatar

    ok, i was able to load the importRelDB into the Palo cube and found the dimensions year, month, currency and measures. after going thru the further possibilities described in chapter 5.2 (and they all worked), i tried to load my data base, the above mentioned Firm0000.fdb i got the following failure message: File C:\importFirm0000.fdb.xml not found i then tried by adding the path to one of the tables in my data base but the error message was similar: File C:\importFirm0000.fdb\AARBJOUR.xml not f…

  • User Avatar

    thanks for your help. i read thru the etl manual and tried those prompts but just didn't succed yet. will now look at the example you mention. i'll be back! regards, boris

  • User Avatar

    Being new to both Palo and ETL Server, on the one hand I’m convinced it’s exactly the tool I’ve always been looking for, so to speak the way to at last get rid of all my pivot tables. On the other hand, I’m having a hard time getting the logics of the ETL Server and its “weird” (I’m a Windows kid:-) command line straight. Have grazed all through this forum for similar threads but still can’t figure out how I should proceed. Sure would be grateful if someone could take the time to…