How to change the name of feature class in file geodatabase converted from mdf file by using a transformer from workspace.

Hi @rawansaleh, I guess that you have a dynamic writer feature type, in which the destination feature class name is set to "fme_feature_type" and the Schema Definition Name is set to default (i.e. same as the feature class name).

If my guessing was correct, firstly create appropriate destination feature class name as a new feature attribute. For example, if your desired destination feature class names are the lowercase source table names excluding the schema prefix:

1. AttributeCopier: Copy the value of "fme_feature_type" (source feature type name) to a new attribute called e.g. "_feature_class".
2. StringCaseChanger: Make the value of "_feature_class" to lowercase.
3. SubstringExtractor (or StringReplacer etc.): Remove the unnecessary prefix from the value of "_feature_class".

Then, in the GDB writer feature type properties, set the "_feature_class" to the destination feature class name and set "fme_feature_type" to the Schema Definition Name explicitly. In addition, if you want to prevent adding geometry type suffix ("_point" and "_polygon") to the destination feature class names, try setting "First Feature Defines Geometry Type" to the Geometry.

Hi @rawansaleh, I guess that you have a dynamic writer feature type, in which the destination feature class name is set to "fme_feature_type" and the Schema Definition Name is set to default (i.e. same as the feature class name).

If my guessing was correct, firstly create appropriate destination feature class name as a new feature attribute. For example, if your desired destination feature class names are the lowercase source table names excluding the schema prefix:

1. AttributeCopier: Copy the value of "fme_feature_type" (source feature type name) to a new attribute called e.g. "_feature_class".
2. StringCaseChanger: Make the value of "_feature_class" to lowercase.
3. SubstringExtractor (or StringReplacer etc.): Remove the unnecessary prefix from the value of "_feature_class".

Then, in the GDB writer feature type properties, set the "_feature_class" to the destination feature class name and set "fme_feature_type" to the Schema Definition Name explicitly. In addition, if you want to prevent adding geometry type suffix ("_point" and "_polygon") to the destination feature class names, try setting "First Feature Defines Geometry Type" to the Geometry.

Dear Takashi

Thanks a lot, it’s working fine with me.

I would like to ask about another thing if you have any idea about it.

I tried to transform the feature class from sql data base to gdb, what I need is to automatic transformation for all the feature class in the sql data base to file gdb.

Epically when I add a new feature to sql I need it to be selected automatically without any manual input from user.

Is that possible?

Best,

Rawan

Dear Takashi

Thanks for your answer I tried what you mentioned above but itproduced the following error.

And when I selected all parameter that will produce unnecessarytables while I need only the feature classes.

What do you think?

sql-gdb-02.fmw

Best,

Rawan