Skip to main content

For example, I am connected to an Excel file and Teradata, my server can access Teradata so can refresh automatically, but the excel is stored in a local folder that the server cannot access. The Excel is static so doesn't need to be refreshed, the Teradata updates every week so needs to be refreshed every week.

 

I can't see a way to select which source refreshes, it's everything or nothing. So I have to do this manually and republish every time?

 

Thanks for any help.

5 Antworten
  1. 3. Nov. 2014, 16:45

    Andrew Pick wrote:

     

    ... If I published that data source to the server I presume that would then solve it? I can then replace this published data source if there is ever an update.

    There's two ways I think you can solve this.

    1. Publish the Excel workbook to the Server as a data source as you said.  This is a good idea because you only need to replace the Excel workbook in one location should it need updating.

    2. Include External Files when publishing.  If I understand this correctly it will capture your Excel data and keep it with the workbook AND you would still have your Teradata connection.  I'll admit I'm not 100% positive about this so I would recommend testing and letting us know if it works this way or not.

    Andrew Pick wrote: ... If I published that data source to the server I presume that would then solve it? I can then replace this published data source if there is ever an update.