Connecting To SQL 2008 Datebase To Pull Out the Data And To

Posted by ithrees on 20-Aug-2014 07:27

Hi All,

What is the best practice in connecting to an external SQL database and using the data from that db to create/generate reports in rollbase ?

Rollbase - Forum

All Replies

Posted by Orchid Corpin on 20-Aug-2014 09:31

Hi ithrees,

Are you using private cloud or hosted cloud?

Regards,

Orchid

Posted by mobiletest on 20-Aug-2014 09:49

You can make use of DataDirect Cloud

Posted by ithrees on 20-Aug-2014 11:29

Hi Orchid,

Its private cloud.

Posted by Orchid Corpin on 20-Aug-2014 15:08

Hi ithrees,

This can be done by some configuration in your database.xml file to use external database and external object. We have a detailed documentation that you can follow via this link http://documentation.progress.com/output/Rollbase/index.html#page/rb/Rollbase.290.html# Go to Integrating with Outside Sources > Using External Tables as Rollbase Objects > Using an External Database and External Objects for Private Cloud.

Make sure you specify "yes" to the isExternal attribute to your new DB in the database.xml e.g. 

<Database name="RB_CUST1" isExternal="yes">

Another way to check this is in your master zone > System Console app > Databases section > Click edit > Make sure to check the checkbox "This database includes External tables which can be mapped as system objects" and this will automatically set the isExternal="true" - in the documentation it is "yes" but in my Private cloud it set into "true".

Regards, Orchid

Posted by Orchid Corpin on 15-Sep-2014 12:27

Hi ithrees,

Is the suggestion above works for you or are there any questions related this case that you want to ask?

Regards,
Orchid

This thread is closed