Skip to main content
Solved

SHP to Oracle Database

M
Forum|alt.badge.img

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?

Best answer by maliodpalube

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.
View original
Did this help you find an answer to your question?

21 replies

oscard
Influencer
Forum|alt.badge.img+21
  • oscardInfluencer
  • Influencer
  • January 25, 2018

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.

M
Forum|alt.badge.img
oscard wrote:

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.

 

 

 

 

oscard
Influencer
Forum|alt.badge.img+21
  • oscardInfluencer
  • Influencer
  • January 25, 2018
maliodpalube wrote:

 

It is not working, I am getting this error and I don't know how to solve it.

 

 

 

 

I can't see the image you have attached.

 

 

gio
Contributor
Forum|alt.badge.img+15
  • gioContributor
  • Contributor
  • January 25, 2018

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...;)

M
Forum|alt.badge.img
gio wrote:

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.

 

M
Forum|alt.badge.img

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.
ciarab
Contributor
Forum|alt.badge.img+9
  • ciarabContributor
  • Contributor
  • January 30, 2018
maliodpalube wrote:

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.
What is your error message?

 

 

M
Forum|alt.badge.img
ciarab wrote:
What is your error message?

 

 

 

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=`') Failed to read schema features from dataset '147.91.176.146:1521/orcl' using the 'ORACLE_NONSPATIAL' reader

 

The dataset '147.91.176.146:1521/orcl' was closed successfully

 

The 'ORACLE_NONSPATIAL' reader was destroyed successfully

 

That is it. I have tried everything and I have added infos to the tns names but still nothing.

ciarab
Contributor
Forum|alt.badge.img+9
  • ciarabContributor
  • Contributor
  • January 30, 2018
maliodpalube wrote:

 

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=`') Failed to read schema features from dataset '147.91.176.146:1521/orcl' using the 'ORACLE_NONSPATIAL' reader

 

The dataset '147.91.176.146:1521/orcl' was closed successfully

 

The 'ORACLE_NONSPATIAL' reader was destroyed successfully

 

That is it. I have tried everything and I have added infos to the tns names but still nothing.

Can you connect to the Database using SQL Developer or SQL*Plus?

 

 

M
Forum|alt.badge.img
ciarab wrote:
Can you connect to the Database using SQL Developer or SQL*Plus?

 

 

Yes, I am using this data base regularly with SQL Developer. That is the reason why I asked for help because it is obvious that I am making a mistake somewhere and I can't identify it.

 

 

david_r
Celebrity
  • david_rCelebrity
  • January 30, 2018
maliodpalube wrote:

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.
Not sure if this has been answered elsewhere in this thread, but try the following:

 

  • Download and install the latest Oracle instant client. Important: if you're running 32-bit FME you have to install the 32-bit instant client. If you're running 64-bit FME your need the 64-bit instant client.
  • Modify the system environment variable PATH and add the complete path to your instant client directory at the very beginning.
  • Restart the computer
If it still doesn't work, let us know.
M
Forum|alt.badge.img
david_r wrote:
Not sure if this has been answered elsewhere in this thread, but try the following:

 

  • Download and install the latest Oracle instant client. Important: if you're running 32-bit FME you have to install the 32-bit instant client. If you're running 64-bit FME your need the 64-bit instant client.
  • Modify the system environment variable PATH and add the complete path to your instant client directory at the very beginning.
  • Restart the computer
If it still doesn't work, let us know.
I did all those things that You said and I am still getting the same problem. I have tried everything that I read that could be the problem.

 

 

david_r
Celebrity
  • david_rCelebrity
  • January 30, 2018
maliodpalube wrote:
I did all those things that You said and I am still getting the same problem. I have tried everything that I read that could be the problem.

 

 

Sounds like you should consider contacting either your FME reseller or Safe support for a more one-on-one support session.
M
Forum|alt.badge.img
david_r wrote:
Sounds like you should consider contacting either your FME reseller or Safe support for a more one-on-one support session.
How can I contact Safe Support since I have students license? Thank You once more.

 

 

david_r
Celebrity
  • david_rCelebrity
  • January 30, 2018
maliodpalube wrote:
How can I contact Safe Support since I have students license? Thank You once more.

 

 

Try this link: https://www.safe.com/support/report-a-problem/
david_r
Celebrity
  • david_rCelebrity
  • January 30, 2018
maliodpalube wrote:
How can I contact Safe Support since I have students license? Thank You once more.

 

 

By the way, make sure you reference this thread when you contact Safe. That way they'll get a head start.
M
Forum|alt.badge.img
david_r wrote:
Not sure if this has been answered elsewhere in this thread, but try the following:

 

  • Download and install the latest Oracle instant client. Important: if you're running 32-bit FME you have to install the 32-bit instant client. If you're running 64-bit FME your need the 64-bit instant client.
  • Modify the system environment variable PATH and add the complete path to your instant client directory at the very beginning.
  • Restart the computer
If it still doesn't work, let us know.
Thank You a lot. I did reference this thread so it was easier to explain my problem. Greetings

 

 

fmelizard
Safer
Forum|alt.badge.img+18
  • fmelizardSafer
  • Safer
  • January 30, 2018

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?

M
Forum|alt.badge.img
fmelizard wrote:

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?

 

 

Thank You in advance.

 

 

M
Forum|alt.badge.img
  • maliodpalube
  • Author
  • Best Answer
  • February 1, 2018

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.
david_r
Celebrity
  • david_rCelebrity
  • February 1, 2018
maliodpalube wrote:

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.
Good to hear, and thanks for sharing the solution!

 

Reply


Helpful Members This Week

Community Stats

31,323
Posts
118,778
Replies
38,912
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.