I would look at using the Python thin client. There are libraries for reading Excel and parsing JSON. There’s a good chance that there are Java libraries, too, but I’ve not used them.
> On 1 Sep 2021, at 07:54, Karthik Nandagiri > <karthik.nandag...@costrategix.com> wrote: > > Hi Team > > We have a requirement where a client(user) will provide me data in any of the > formats, csv, excel or json. > Now, we need to load this data into ignite table(table is created). For csv > we are using sqlline tool with copy from command. > Is there a mechanism to load excel and json data as well? As we won't be > having access to clients' RDBMS, we are provided the data in any of the file > formats mentioned above. > > Regards > Karthik N