Finally, I would like to add an identifier field to the SQL tables that is not located in the Acess DB's, how is this achieved?
Thanks,
Question
Populate/Append SQL Table
I was wondering the steps to populate an existing SQL table from MSAccess DB's. The issue is that the field names from the 40 different access db's are not the same as those in the SQL table for example, in the SQL table I have a field called "Material" but the data I want to populate it with is in an access table in a field called "mat_type". I assume I will have to have a different workbench for each access db as the fields are diffrent in each. I would like to keep adding to the SQL table with all of the data in the seperate 40 Access DB's, how exactly do I keep appending to the SQL table?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi,
your question is a bit light on the technical details, but here is how it might be done:
- Create a writer for the SQL database connection (but do not create a feature type when FME asks you)
- Import the existing table definition using the menu Writer / Import feature type. This ensures that you get a perfect match between FME and your SQL database, which is important.
- Create a Reader for your Access databases. If they all have the same schema, you can add them all at once to the same workbench using a dynamic schema reader. If not, you will have to add them all individually.
- Insert an AttributeRenamer so that you can rename "mat_type" to "Material", etc.
- Insert a Counter and name the resulting attribute according to your SQL database primary key (identifier)
David
+22- Safer
Hi,
A posibble addition is to make use of the schema mapper, this especially useful when you have lots of attributes to rename and keep the attribute mapping flexible.
Itay
p.s. you can extract the input and output schema (schema reader 2 csv) to help you create the mapp
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.