ETL insert help

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Doesn't Need an Answer
I am using informatica to connect to Quickbase via Qunect ODBC connector.  I can connect the two and get data from Quickbase --> Oracle DB using informatica.  But when I try to go from Oracle --> Quickbase using Informatica its failing.  Is there some kind of setting i need to set on Quickbase side to allow for insert/updates to the table?
Photo of Rob Purdy

Rob Purdy

  • 110 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of Rob Purdy

Rob Purdy

  • 110 Points 100 badge 2x thumb
Ok, i got it to work.  I didn't know the data well enough yet.  I was trying to reinsert back into quickbase the 5 built in fields, such as record id, date created, date modified, last modified by and date.  solution was, don't send those back over to quickbase, quickbase will handle those, only send my other fields to quickbase and it worked fine.