If I install fomspider schema on a Oracle instance "A" and I want to make a new application based on a schema on other database instance "B". ¿How do I reference a Datasource schema? Must I use a database_link? ¿Can I only reference schemas of my installation instance?

asked 18 Nov '15, 10:55

alvaro's gravatar image

alvaro
111
accept rate: 0%


Hi Alvaro,

If you want to reference a schema in a different Oracle database than the schema you installed Formspider to, you have two options:

1) As you said, you can use database links
2) You can communicate via HTTP, web services etc...

Kind Regards,
Yalim

link

answered 18 Nov '15, 11:10

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

edited 18 Nov '15, 11:10

Hi Yalim,

After creating my public database link to other instance, formspider does not recognize the Datasource Schema, however, I'm able to conect to remote databases using my plsql editor. Is there any syntax error in the string connection?

New Application

Name : MY_APP Datasource Schema: other_db_user@my_database_link

Regards Alvaro

(19 Nov '15, 07:02) alvaro

Hi Alvaro,

Your datasource schema has to be a local one. But in your local datasource schema you can use the DB Link in your code, queries, views etc... The datasource schema name for Formspider though should be a local one.

Kind Regards, Yalim

(19 Nov '15, 08:54) Yalim ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×15
×2

Asked: 18 Nov '15, 10:55

Seen: 908 times

Last updated: 19 Nov '15, 08:54


© Copyright Gerger 2017