jdbc to file scenario

[Former Member]

Hi All,

I want to connect oracle erp to ecc system. so,i planned to do jdbc to file scenario. As i am new for this scenario, i like know what are the requirements should i take from client before starting development. Please let me know.

Thanks,

Dileep

[former_member184720 · Accepted solution]

• Also consider the number of tables i.e. if you need to process records from multiple tables..
• What is the frequency of interval to process the records from DB
• Any scheduling required i.e. will there be any specific period to execute this interface/ will there be any periodic downtimes(weekly/monthly maintenance) so that you can schedule your channels

[Former Member · Accepted solution]

Hi Hareesh,

Thanks for your response.

Scheduling is required, file updation should be done at 1 'O' clock for every mid night.

so ,please let me know how it should be scheduled.

Thanks,

Dileep

[former_member184720 · Accepted solution]

Schedule your sender channel to run at 1AM daily. Below blog will help you in scheduling.

[Harish · Accepted solution]

Hi Dileep,

Please check the option of available planning in communication channel monitoring

regards,

Harish

[Former Member · Accepted solution]

Actually for my project, i am planning to do the scenario jdbc to file.

can you suggest me which scenario should i prefer better than this and why?

[Former Member · Accepted solution]

Actually for my project, i am planning to do the scenario jdbc to file.

can you suggest me which scenario should i prefer better than this and why?

[Bhargavakrishna · Accepted solution]

Hi Dileep,

Scenario 1: JDBC to File

If you want to do JDBC to File scenario, you should integrate the PI with Oracle database.

For this you should deploy the JDBC drivers which is supported by that particular oracle version.

Please refer the guide:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

Basis team will take of this driver installation.

Then create the sender JDBC communication channel and fetch the req fields from the database, by writing select statements.

Scenario 2:

If the data is updating in ECC tables, you can go for RFC / IDOC / Proxy as well.

Scenario 3: File[FTP] to File

As you said users are placing the files in C: Drive, you can use FTP to read the files from the directory.

Scenario 4: File [NFS] to File

instead of placing the files in C:drive ask the users to place the files in PI SAP directories.

It completely depends on how the client wants to do it.

Scenario 2: requires custom development.. so instead of this you can go for any other scenarios.

Regards

Bhargava krishna

[Muniyappan]

Hi Deleep,

concentrate on

1. Data types--how many fields are going to come from sender

2. Mapping---if any transform required

3. Message size and how many messages per day--for performance analysis

4. synchronous or asynchronous

5. Sender system details like versions--for installing drivers

i hope you might be having business documents which talk about real requirement. reading this also gives you some idea how to design.

wait for more suggestions from others

Regards,

Muniyappan.

[Former Member]

Thanks for your valuable suggestion Muniyappan.

Actually the existing process is, a person will extract those database tables as files, and bring them to the ecc system using a storage device. Then the file will be kept in the c drive of the system and it is uploaded to the ECC system manually by using one tcode.

Whenever that tcode is entered, fields like fiscal year, backup number will showcase. By providing those details ,the files will update in the ECC system. And this backup number will be available with the file itself.

But my client told me to find one suitable GLCODE to upload it.

Can you provide me any suggesion regarding this.

Thanks,

Dileep

[former_member184720]

Dileep -

To know more about GL codes

To get the list of GL accounts list with Description