Import Providers

import providers load external data into the connector's import table choose the provider that best fits your source system text (csv/tsv/fixed) provider class innovation activate library\innovation activate connectors importtext example \<import> \<provider>innovation activate library\innovation activate connectors importtext\</provider> \<filename>c \imports\employees csv\</filename> \<headers>true\</headers> \<timeout>300\</timeout> \<batchsize>0\</batchsize> \</import> options path required default description provider ✅ — class name for text provider filename ✅ — fully qualified path to the file headers optional true indicates the first line contains column names oleprovider optional microsoft jet oledb 4 0 underlying ole db provider type optional text provider type passed to ole db timeout optional 300 seconds to wait before timing out batchsize optional 0 number of rows per batch (0 = provider decides) sql provider (local/remote sql server) class innovation activate library\innovation activate connectors importsql example \<import> \<provider>innovation activate library\innovation activate connectors importsql\</provider> \<connectionstring>server=sql01;integrated security=true;initial catalog=hrdb;\</connectionstring> \<sql>exec dbo getemployeesforactivate\</sql> \<timeout>120\</timeout> \<batchsize>0\</batchsize> \</import> options path required default description provider ✅ — class name for sql provider connectionstring ✅ — sql connection string (use for local activate db) sql ✅ — select or exec statement timeout optional 120 seconds before command timeout batchsize optional 0 rows per batch for remote sql loads script provider (custom sources & apis) use script when you need to call web services, read custom apis, or transform input before load class innovation activate library\innovation activate connectors importscript example \<import> \<provider>innovation activate library\innovation activate connectors importscript\</provider> \<script>=/script\</script> \<batchsize>10\</batchsize> \</import> behavior your script calls addrow to push rows into the import set rows are committed every batchsize calls to addrow options path required default description provider ✅ — class name for script provider script ✅ — pointer to the script to run batchsize optional 10 rows committed per batch provider selection guide text — simple flat files delivered on a schedule sql — first choice when the source is a database and you can control a view or stored procedure script — for apis, complex transforms, or multi source joins operational tips validate column names and types against your schema before first run set conservative timeout and batchsize during early testing use a staging environment to verify row counts and key uniqueness include notify steps in workflows to surface provider failures quickly