span8
span4
span8
span4
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?
It seemed that there was a bug in data base since today the admin just reset my username and password to the same as they were and I normally accessed to the data base.
Thank You all for effort and for all the help that you provided me.
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?
Is there any way to get some feedback about this problem?
I have done all fromthis linkbut 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.
That is it.I have tried everything and I have added infos to the tns names but still nothing.
If you are writing to an existing database,you may need to verify constraints etc.
Often linked table via primary- foreign key force you to do more work.(not wise to temporarily disengage them...a common mistake)
You can read these constraints etc.using an sql statement using a sql-executor.Then pass the values to transformers to prepare data writing.As to make sure you respect the constraints etc.
Maybe your projection is wrong?
But,yes,reload your image so we can see the error,or copy the error and paste it.(not as big as the gdb corrupting question I hope...;)
Hi.
Add a SHAPE Reader.
Then add the Oracle Spatial Object Writer:
Choose the option: "Copy from Reader"
In the "Dataset" parameter create a New connection:
Last,join the Reader with the Writer.
That should do the trick.
© 2019 亚搏在线Safe Software Inc |Legal