Data warehousing to MS Access (OpenInsight Specific)
At 17 DEC 1998 05:21:13PM Nancy wrote:
I'm *this close* to warehousing data into an Access 97 table. I've created the ODBC DSNs and the connection object, which work fine with the query window in the C/S workspace. I created a warehouse procedure with OI's wizard. The code generated is nearly identical to that posted here as an answer to previous quesions, only the variable names are different. When I run the procedure with the warehouse manager, OI creates the new table and seems to warehouse that data. However, the new Access table only has one record containing the values of the last row from the OI table. What is going wrong? Any ideas? Any suggestions would be much appreciated.
Nancy
At 17 DEC 1998 06:50PM dsig@teleport.com wrote:
Nancy,
After the warehouse process .. is there anything in the LOG?
dsig@teleport.com
David Tod Sigafoos ~ SigSolutions
voice: 503-639-8080
At 18 DEC 1998 07:42AM Nancy wrote:
David,
]After the warehouse process .. is there anything in the LOG?
Oh, thanks for reminding me, I forgot to mention this in my original post. I can't view the log after it's done warehousing! The button is greyed out. Does this mean that OI actually isn't done with the warehousing process?
At 18 DEC 1998 08:31AM Bizsoft Corp. wrote:
For those that have large amounts of data to be warehoused in Access, MS SQL, or Oracle we can create custom export programs.
We read the OI tables directly and churn them to Access without the use of ODBC. It's extremely fast.
We currently have a product that exports around 500 meg of info, approxiamtely 85 tables and a couple million records in about 2 hours to a MDB or Oracle on a 233Mhz.
www.bizsoftcorp.com for contact info
At 19 DEC 1998 12:55AM Nick Stevenson wrote:
It means there were no errors written to the log.
Try forcing a commit after each dataset 'write'.