Skip to main content
Inspiring
February 7, 2012
Answered

Displaying Data Sources in CF Builder 2

  • February 7, 2012
  • 2 replies
  • 919 views

How do I view my tables that I have set up in my local CF Admin?

    This topic has been closed for replies.
    Correct answer BKBK

    Sorry. I have only just seen on rereading that you're talking about CF Builder. You should have gone to the CF Builder section of this forum!

    In any case, I have a suggestion based on my experience with the CF Builder plugin in Eclipse 3.7.1. (I am assuming you have enabled the use of RDS.) Go to the Eclipse/CF Builder menu and navigate to:

         Window => Show View => RDS Dataview

    A Graphical User Interface should appear, showing you the datasources created in the Administrator and their tables.

    2 replies

    BKBK
    Community Expert
    BKBKCommunity ExpertCorrect answer
    Community Expert
    February 8, 2012

    Sorry. I have only just seen on rereading that you're talking about CF Builder. You should have gone to the CF Builder section of this forum!

    In any case, I have a suggestion based on my experience with the CF Builder plugin in Eclipse 3.7.1. (I am assuming you have enabled the use of RDS.) Go to the Eclipse/CF Builder menu and navigate to:

         Window => Show View => RDS Dataview

    A Graphical User Interface should appear, showing you the datasources created in the Administrator and their tables.

    jenn1Author
    Inspiring
    February 8, 2012

    Thanks! That's what I need.

    BKBK
    Community Expert
    Community Expert
    February 8, 2012

    Your tables are set up in the database, your datasources in the Administrator. To see your datasources, open the following file in an XML/Text editor:

    {CF_INSTALLATION_DIR}/lib/neo-datasource.xml

    Alternatively, you can also view the datasources by running the following command:

    <!--- Use your own password --->

    <cfset adminLogin=createobject("component","CFIDE.adminapi.administrator").login("my_cf_admin_pw")>

    <cfset ds=createobject("component","CFIDE.adminapi.datasource")>

    <cfset datasources=ds.getdatasources()>

    <cfdump var="#datasources#" >