Thank you both, guys! It helps me to solve it...

Hi, I found a reason of the error. CSV file contains double quote characters in one column (text field with strings searched by users in database) regardless that there was \ right before double quote character. In moment I replaced double quote character in the file, I was able to import CSV without any problem.

The reason why we are not accessing directly to OSvC is that we need to use OKCS data which is not available in the connector. I spent a lot of time with investigating it and much more time to create a scripted workaround. Current situation (bunch of CSVs) is a half-way stand on the road to the ideal structure (we need to…

Thank you Joshua, Regarding Option 2: Could you advise me the way how to load data into the OAC? Via API? Via JDBC? I could incorporate it into my Java script which is preparing CSV data from OSvC.

Thank you a lot for quick and correct answer. It helps me to do my task.

Thank you Joshua, it works! It works little bit differently, but it works!!

Yes, there is a significant reason: we need to use data which is not accessible via live OSvC Connection (KM data, specifically OKCS tables). Because we need to refresh data daily, we are searching an automatic way how to do it. That's why I use a Java script for run report in OSvC, get data, export data in CSV. Now I am…

Currently I am trying to find a solution of the concern: * Export CSV data from OSvC * Import data into OAC and create dataset * Next day export CSV with new data from OSvC * Automatically update dataset in OAC (tried OAC DataSync, JDBC, SQL client,...) I didn't found how is stored CSV in OAC (table name), if it is…

Thank you all. The original reason I need to access OAC data is to update some data via API regularly. Because we are getting data from Oracle Service Cloud via API and want to push them in OAC to have a fresh set of data.

I am also interesting in such information regarding REST API access to data in OAC. Is somewhere a description of available API endpoints? Thank you.