has anyone connected Pentaho to Salesforce using Celigo?

I thought Pentaho is the middleware - as far as I know Pentaho has NS plugin for integration.

Based on what I can see Pentaho pulls data from the data warehouse and populates it to a destination? Is that accurate?

Pentaho, Talend, Boomi, Jitterbit and even Celigo are middleware, they sits in between applications for data exchange. Pentaho it self is an ETL tool, it used to be open source I think Hitachi bought them up while back. in 2007 when I engaged Celigo for a project, I remember they just started to build their NS connector using open source ETL tools like pentaho and talend (they used to be a NS implementation partner then)

Ok gotcha. Basically I was told we are switching to Pentaho for our data warehouse BI tool. I was asking for the data warehouse schema so I could start to map our integrations between the data warehouse, Salesforce and NetSuite