Importing Excel to Database

Hello, I'm currently trying to use the import excel to database smart service within my process model and it's completing but not updating my data store entity.

Process model:
Start -> User form -> Import Excel to DB smart service -> End

The file that I input in the form is an excel file and gets saved, and I have also configured the smart service so that the data source is a constant that contains the text which is my datasource: "jdbc/{name}". Table name: {SQL database table name}", excel file: Process variable which is stored excel document. 

After configuring all of these as followed by a youtube video that showcased this smart service, the data is not saving.

I made sure that my column headers(A1,B1,C1) are exactly as stated within my CDT and matches the data type.

How would I fix this/do this differently?

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data