File To JDBC scenario

[Former Member]

Hi all,

I want to implement a File to JDBC scenario. But one thing is I want to implement in access databas which will be residing in a seperate FTP server. Is it possible to do it. If so What will the connection string be? or is there any database which resides on the internet which I can use for testing my scenario.

[Former Member]

Hi,

Have a look at this,

A JDBC sender adapter has 2 essential fields,

1. SQL Statement

2. Update Statement

Your SQL statement will contain your SELECT statement and once your SQL statement is executed, UPDATE statement is executed. This is done so that records that have been selected by the SQL statement should not be selected again as the JDBC sender adapter will poll over the database for every poll interval.

If you want to SELECT something from your Database, then you will have to go for a JDBC sender adapter.

But, if you want to insert/update your Database, then you can go for a JDBC receiver adapter.

Multiple insertions are possible for a JDBC receiver, but multiple Selection queries (different select queries) are not possible for a single JDBC sender adapter.

Just check these links to understand how JDBC adapters work,

If you wanna do update/insert you will have to follow the

Document Formats for the Receiver JDBC Adapter

For Configuring the Receiver JDBC Adapter refer:

Configuring the Receiver JDBC Adapter

For Configuring the Sender JDBC Adapter refer:

Configuring the Sender JDBC Adapter

Please go through this blog and see if it helps you.

/people/prasadbabu.nemalikanti3/blog/2006/02/27/collecting-and-bundling-vendor-records-from-different-multiple-interfaces-file-systempeoplesoft-and-sending-to-sap-r3-system-part-2

For more info, just take a look at these links also,

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

All that i could get from the SAP Help regarding JDBC Adapters once when i searched for the same were these links, so go through these links and see if you find anything useful.

http://help.sap.com/bp_bpmv130/Documentation/Planning/XIUnicodeGuide030411.pdf

Configuring the Receiver JDBC Adapter

Mapping Lookups

JDBC Adapter

Configuring the Receiver JDBC Adapter - part 2

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Akshay Jamgaonkar.

• Reward points if find useful.

[nisarkhan_n]

I want to implement a File to JDBC scenario. But one thing is I want to implement in access databas which will be residing in a seperate FTP server. Is it possible to do it.

Yes it is possible to do connect to the D/B which is on the FTP server....make sure the required drivers are deployed in the .sda file in the XI server........

[prateek]

<i>access databas which will be residing in a seperate FTP server</i>

Do u mean that the database is on a separate system. Could u clarify this point. If it is a separate system, then u just need to install the drivers. See this

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

<i>or is there any database which resides on the internet which I can use for testing my scenario. </i>

I dont think this would be available.

Regards,

Prateek

[Former Member]

Hey

i dont know of any Database server available on internet.

as far as connection string is concerned it depends upon the database.you need to deploy the drivers (usually Admin will do it for u).once the database drivers r installed,you can do the scenario easily

Thanx

Aamir