Forum Discussion

RobPurdy's avatar
RobPurdy
Qrew Trainee
7 years ago

ETL insert help

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?
APIs and custom code
App builders
Data import and export
  • RobPurdy's avatar
    RobPurdy
    Qrew Trainee
    7 years ago
    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.