Problem with Oracle Database and Syncfusion Data integration

[Ricardo Pérez Bravo]

I was trying connect synfusion and Oracle 11g Home but I found problem can´t load driver, so I download many times the driver but It still doesn't work.

I have to UP so many records of a file in a table of my database, if you can help me with a template for this.

Attachment: Error_27174c16.rar

[Karthikeyan SankaraVadivel]

 Hi Ricardo, 

Thank you for contacting Syncfusion support. 

Please find the steps to create the create the connection with Oracle database and the Sample template that move the data from the CSV files in to target Oracle Database.  

Document & Template link - http://www.syncfusion.com/downloads/support/forum/130030/7z/Forum_1300301081997216.7z  

Please let us know if you have further assistance. 

Regards, 

Karthikeyan S  

[Ricardo Pérez Bravo]

So thanks, but I have another question, now it works but when I try to insert any data It response that It failed, so the type of data is important when inserts?  because of follow with your template it doesn't  put a type of data.Can you give me correct sintaxis to write an insert query  and delete query to can execute in syncfusion processors? So many thanks.

[Karthikeyan SankaraVadivel]

Hi Ricardo, 

Please find the update. 

now it works but when I try to insert any data It response that It failed, so the type of data is important when inserts?  because of follow with your template it doesn't  put a type of data. 

Yes it is important to know the type of the data in the Database during Insert operation.  

In the provides sample, we have consider all the fields as String Data type. Please find the Syntax for the insert and delete operation in the below query.  

  

Can you give me correct sintaxis to write an insert query  and delete query to can execute in Syncfusion processors?  

You can use PutSQL processor to execute Insert/Delete query. 

Consider the example provided in the sample,  

Table name – AdventurePerson  

Schema-  

ID	NUMBER
CUSTOMERNAME	VARCHAR2
AGE	NUMBER
EMAIL	VARCHAR2
CONTACTNO	NUMBER
CREATEDDATE	VARCHAR2

In ReplaceText Processor, you need to specify the insert or delete statement as given below, 

Insert Statement-  

Syntax - insert into <tableName>(<column1>,<column2>,<column3>,..) values(<attribute1>,<attribute2>,<attribute3>,..)  

You need to specify ‘ (Single Quotes) for the data types String, Character, Timestamp.. For numeric data type you just send the attribute from the flow file as it as to insert statement.  

Example- insert into AdventurePerson(ID,CustomerName,Age,Email,ContactNo,CreatedDate) values(${csv.1},'${csv.2}',${csv.3},'${csv.4}',${csv.5},'${csv.6}') 

Here the highlighted attributes are considered as String and TIMESTAMP in the Oracle.  

  

Delete Statement- 

Syntax - Delete from <tableName> where ID=<yourattribute>  

Example - delete from AdventurePerson where ID=${csv.1} 

Here we are deleting the record,when the column ID is matched with the incoming attribute in the flow file.  

 

Please let us know if you have further assistance.  

Regards,  

Karthikeyan S