Configuring Integration and Caching services : Configuring the Caching service : About bulk loading files to the cache
 
About bulk loading files to the cache
Use database tools, such as sqlldr and db2cmd, for Oracle and DB2 respectively, for bulk loading. Install these tools on the node where the caching server is enabled. iHub also supports bulk loading through the JDBC driver using jdbc insert. To prevent problems with client tools, such as the SQL Server Bulk Copy Program (BCP), specify a fully qualified name for a database object, using database.schema.object notation, as shown in the following example of BCP command-line syntax:
bcp {[[database_name.][schema].]{table_name | view_name} | "query"}
{in | out | queryout | format} data_file
[-S server_name[\instance_name]] [-U login_id] [-P password]