JDBC to CSV file Scenario

[Former Member]

Hi ALL,

I have a scenario where the integration results in the jdbc to csv file format.

Here the data is following from non-sap system (Ccure system with progress database) to SAP (ECC).

we have pull data from non-sap on daily bases that is once in a day (say morning @ 7 am), create a file in csv format and place this file in ECC.

the issue over is, how to make it run on daily basis and retrieve only particular information from the progress database.

please put on your thoughts on this issue.

Thanks,

Lalitkumar.

[Former Member · Accepted solution]

Hi,

how to make it run on daily basis and retrieve only particular information from the progress database.

1.how to make it run on daily basis

Through Available Time Planing in RWB--> CC Monitoring.

Here u have the option for choosing the the time at which u want to run the CC

2.retrieve only particular information from the progress database

There are lot of techniques to do this.

a. when ever u retrieve the data from Database and if it is successful them mark the record as read.

For this u can have extra column in table and set the flag as read/unread or 0/1.

when u select in next query, select based on this field also..

Babu

[Former Member]

Hi Raja Sekhar,

Thanks for sharing your view on this.

But according to the requirement i need to fetch the data for the sy-date - 1 and sy-date - 2 records,

where sy-date being the current date of the system.

So if u put on more thoughts on this issue will be appreciated.

Thanks,

Lalitkumar.

[Former Member]

Hi Stefan Grube,

As you mentioned we cannot use the PI date in select query. so in that case any idea how to retrieve the current date from progress database and use it in the query statement of JDBC Adapter .

[rajasekhar_reddy14]

Hi ,

Selecting data based on PI date is not a right approach because take an example data inserted in to db tables X is the time, but your communictaion channel will execute some other time,so you will not pick the data most of teh cases.

to solve this problem, create one flag filed in data base, pick up the data based on flag value,after selecting the data dfrom data base update the flag value ,so that you will not pick the old data once again.this is the way JDBC sender scenario works.

even you can use any other filed to select data ,but PI data is not a right idea, you can create Sysdate field in data base, you can select the data base on the Sys date field, SysDat field stored the default time when data inserted in to data base, but as per my exop this is not right approch.

Regards,

Raj

[Former Member]

Hi,

Thanks for the reply.

While message mapping we can get it.

But the problem is to fetch the current date in select Query.In ECC the current date is stored in system variable,like that is there any variable which hold the system date and time in XI system.?

[stefan_grube]

> But the problem is to fetch the current date in select Query.In ECC the current date is stored in system variable,like that is there any variable which hold the system date and time in XI system.?

You cannot use PI dtae in SQL query, but you can use DB dependent functions.

For example in MSSQL you can use getdate()

Check manual or online help of your DB system.

[Former Member]

Hi,

Thanks for the reply.

can u tell how to get the system time and date in SAP xi.

that is when I'm writing a query in JDBC adapter, i got to retrieve the data based on system current date...?

so how do i get that...?

Thanks,

Lalitkumar.

[Former Member]

Hi,

In Mapping u have Date functions....

U have Date and Time Node function... U can get the Date and Time from that one.

But if u want to get in source CC its not possible....

Babu

Edited by: hlbabu123 on Sep 20, 2010 3:55 PM

Edited by: hlbabu123 on Sep 20, 2010 3:57 PM

[Former Member]

Hi,

You have to schdule the sender channel using Availability Time Planning' option in communication channel in runtime workbench.

This will ensure that data will be pulled at a particular time only (morning 7).

For fetching specific data, you have to write the select query in sendet communication channel in such a way using condition.

-Supriya.

[rajasekhar_reddy14]

> the issue over is, how to make it run on daily basis and retrieve only particular information from the progress database.

>

You can schedule your sender JDBC adapter , use availability time planning in communication chennal monitoring,ther eyou can specify the time when to execute the scenario.this will solve your problem.

selecting particular daya depend on your select query, you have to wite select query such a way that it will retrieve the data based one yoru conditions.

Regards,

Raj