I once needed to import some data, on daily basis, from SQL Server to my Clarity database which is on Oracle. Wrote a GEL script which will do this thing in simpler way. Though there are many more efficient ways of data integrations, however this is within Clarity's scope and without need of writing external program/script to achieve this task.
Click here to download the script. Readme.txt file attached.
Can we import data into clarity from excel file(.xls)using gel which is at FTP server?
ReplyDelete