SHP to Oracle Database

Hello,

I have result from FME, one shape file with many attributes that need to be written in one DB in Oracle that I have access to. I don't know how to connect that DB in FME and how to export attributes from this shp to that data base. Is there any way to do it?

Hi @maliodpalube, can you try adding a Reader (connecting to the same database), are you able to see any tables to select from? Have you been able to test adding a Spatial Writer instead of the Non-Spatial? If you're importing a schema from a spatial table, you might want to consider using the Spatial Writer.

Your Oracle library clients (32 vs 84-bit) should be okay if you're able to see the Oracle format as an option to add onto the canvas. Are you trying to connect using the service name, username, and password or with the easy string? Can you confirm that you're using SQL Developer or TOAD to access the database on the same machine you're running FME?

I have tried to add a reader and as an easy connect and also with Server name but I get the same error. I am loading the same db with SQL Developer and I can load and use the same data base. What could be the problem?

Is there any way to get some feedback about this problem? I have done all from this link but it is not working. I don't know why am I always getting an error when I did everything from the article and still I am not being able to connect my base and FME.

Projection is good. I am trying to connect the base, for beginning. There are some foreign keys but they need to be kept and some that were not needed they are closed in SQL Developer. I can't connect my base with FME, that is my problem and I have no idea how to solve it and I've tried everything that could be a problem.