Importing data from another database

cchappell

I want to transfer data from an external db. Each time a process is run I want the awareim db to update if it doesn't create duplicates in AwareIM.

I followed the directions in hyperlink below as I thought it would be a good place to start and then add duplicate checking if this works....

It doesn't work for me.

http://www.hiden.org/awareim/tips-n-tricks/importing-data-from-another-database

When I followed the directions in the hyperlink listed above and I run the process in step 4. I only get one record created in BODestination.

The only thing that is different from the example hyperlink is my external db is MS SQL and my attribute name in both objects is DBAction.

Any ideas would be appreciated.

Hubertus

Do you have a primary key field selected for the external table ?

Hubertus

cchappell

I selected the Primary Key and it worked like it is suppose to.

Can you help me understand?

I didn't select a primary key because I hadn't planned on updating the external db using Aware Im. I want the external db to be read only thus I didn't think defining a primary key was necessary.

I appreciate the help..Thank You! 😃

Hubertus

Hello,

Updating requires a primary key. What we are doing here is that we update a unchanged record. What's really going on under the hood would be a question to Aware Support. Btw. I had the same thought yesterday (don't update data - so I need no pk) and ran exactly into the same trouble :roll:

Guess I should add a comment to my little how to...

Hubertus

cchappell

I was really banging my head on this one. 😮
Thanks for your help. 😃 I definitely won't forget to check the primary key!
Even if I don't intend on writing to the DB.