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? |
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 Kind Regards, 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 ♦♦
|