Develop on different schemas

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?

install schemas

asked 18 Nov '15, 10:55

alvaro
11●2
accept rate: 0%

One Answer:

oldest newest most voted

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 Gerger ♦♦
1.8k●5
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

community wiki

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

learn more about Markdown

Tags:

install ×15
schemas ×2