import csv to database smart service from Excel tool is creating an issue with connected system data source
Discussion posts and replies are publicly visible
hi ashishdave what is the database you are using to import data, is it mariadb or postgres SQL
Hello ashishdave There's a high chance that, Import csv to database smart service likely expects a traditional database connection, which connected systems might not provide.
We are importing the data into Maria DB.
Thank for Shubham,
Yes, I did try with several options but it is still giving me the same error with the connected system database, after that I tried to import the data into another schema in Maria DB using the traditional datasource like 'jdbc/Appian' and it works but in case of connected system it is giving me the same error
Looks like Import CSV to Database smart service might not work with connected system data sources.Plugin documentation doesn't have enough info. Still you can go through it.PDF