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.
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.
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.
It is not working, I am getting this error and I don't know how to solve it.
It is not working, I am getting this error and I don't know how to solve it.
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...;)
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...;)
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.
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.
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.
Error connecting to Oracle database: message was `ORA-12170: TNS:Connect timeout occurred'. (serverType=`ORACLE_NONSPATIAL', serverName=`147.91.176.146:1521/orcl', userName=`DRAGICFME', password=`***', dbname=`')
That is it. I have tried everything and I have added infos to the tns names but still nothing.
Error connecting to Oracle database: message was `ORA-12170: TNS:Connect timeout occurred'. (serverType=`ORACLE_NONSPATIAL', serverName=`147.91.176.146:1521/orcl', userName=`DRAGICFME', password=`***', dbname=`')
That is it. I have tried everything and I have added infos to the tns names but still nothing.
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.
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?
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?
Thank You in advance.
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.
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.