Skip to Content
author's profile photo Former Member
Former Member

File To JDBC scenario

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2007 at 02:29 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 11, 2007 at 03:01 AM

    <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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 11, 2007 at 04:31 AM

    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........

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2007 at 04:47 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.