Quick Base Discussions

Expand all | Collapse all

ETL insert help

  • 1.  ETL insert help

    Posted 01-25-2019 13:50
    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?

  • 2.  RE: ETL insert help

    Posted 01-25-2019 19:00
    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.