Datasources

Previous  Home topic  Next  Print this topic Send Feedback

<datasources>

 

The datasource tells the system:

 

Which database/LDAP should be exposed.
On which server the database is located.
Which of the users defined within <logins> can have access.

 

The example below shows a single datasource 'Oracle Production' exposed. It is located at the IP Address 127.0.5.192 on port 1521.

 

<datasources>

    <datasource name=”Oracle Production” id=”1” server=”127.0.5.192” port=”1521” 

             type=”oracle”>

        <database name=”Personel” id=”11”  db=”employees” user=”usr1” password=”pass1”  

             login=”*” tables="people"/>

        <database name=”Parts” id=”12” db=”parts_catalog” user=”usr2” password=”pass2” 

             login="msmith" tables="items, partnumbers"/>                

        <database name=”Customers” id=”1n” db=”customers” user=”usrn” password=”passn” 

             login="msmith, jdoe, rjones"/>

    <datasource/>

<datasources/>

 

 

The type parameter tells the connection agent how to connect to the datasource. The possible values are:

 

oracle
mysql
sqlserver
sybase
ldap

Updated: 06/12/2011  Page url: http://www.perfectforms.com/Documentation/manual/html/?admin_datasources.htm
PerfectForms™ -- forms software, workflow software, and business process management