Problem in Inserting Data into Database

[rizwans]

HelLO

I need to do following process, could any body help me to chaok out this process.

First in our company we have our sales database seperate and Accounts seperate.
As we are in process to Integrate this, i came accross some hurdles and not able to
clear this problem. Plz HeLP ME OUT.

At some certain shedular time (lets take in night Between 10 - 12 midnight) this process should run. this process should read or select the data from database "A" (MS SQL DATABASE) based on current date and inserts into Database "B" (Ms sql Database).

For this, i have taken the SelectSQL Adaptor service to read/Select the data from the Database "A" and and i have created InsertSQL Adaptor service at the other end to Insert the selected data. NOw the question is how should i map this , where should i get the publishable document and how should i insert this data into Database "B".

Plz Plz help me as soon as possible.

Plz say me in steps to perform this.
Thanks

[atul_ahire]

You can write one Flow Service in which you first call the Select adapter service from DB A and then do map step and then call Insert adapter service from DB B.

You need to schedule this Flow Service to run every night.

hope this helps.

[puneetverma]

Dear Rizwan,
Do the following steps to accomplish it.

1. Create a flow Service and Run the Select Service on DB A to select the data from table.
2. In the same flow service create a MAP step to map the data from the Select Service to a Document Type.
3. Create a Insert Service to insert the data from the Document to the DB B.Map the Document fields from the Document to the insert Service.
4. Do the proper Transaction Handling in the Flow Service.

HTH...

Thanks,
Puneet Verma

[rizwans]

Hi Puneet
Thanks for your Reply. I had created the Adaptor Service for selectSQL for Reading the data for DB-A and also i creted the INSERTSQL to insert it into DB-B. but i m getting the problem in mapping the data.

I had Created the Adaptor Trigger which takes the Flowservice and Reference of PublishedDocument which u will get only if you create Notification to monitor some changes . but i m not monitoring the DB. i m just picking the records at a perticular time.
Hope you got what i want to said.
Plz help me in this
Thanks
Rizwan

[rizwans]

Hi Puneet
Thanks for your Reply. I had created the Adaptor Service for selectSQL for Reading the data for DB-A and also i creted the INSERTSQL to insert it into DB-B. but i m getting the problem in mapping the data.

I had Created the Adaptor Trigger which takes the Flowservice and Reference of PublishedDocument which u will get only if you create Notification to monitor some changes . but i m not monitoring the DB. i m just picking the records at a perticular time.
Hope you got what i want to said.
Plz help me in this
Thanks
Rizwan