Simple ImportData replacement

[Ian Ray]

Is Google Cloud VPN a suitable replacement if all I want to do is have ImportData in Google Sheets?

As it is now, the only function I have left on google sdc is to push data to spreadsheets. What would be the proper replacement for this?

[Ray Colline]

On Fri, Feb 27, 2015 at 8:43 AM, Ian Ray <ian...@cypressgrovechevre.com> wrote:

Is Google Cloud VPN a suitable replacement if all I want to do is have ImportData in Google Sheets?

This is not a suitable solution.  This allows Google Compute Engine VM instances to be on your local network.  Sheets run as a separate Google service.

 

As it is now, the only function I have left on google sdc is to push data to spreadsheets. What would be the proper replacement for this?

This is not a great answer but, whatever endpoint Sheets is grabbing data on needs to be available on the public internet.  You can use authentication, https and IP restrict to help mitigate the exposure of the endpoint.

Thanks!
Ray

 

--
You received this message because you are subscribed to the Google Groups "google-secure-data-connector" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-sdc+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "enterprise-data-questions" group.
To unsubscribe from this group and stop receiving emails from it, send an email to enterprise-data-qu...@google.com.
To post to this group, send email to enterprise-d...@google.com.
Visit this group at http://groups.google.com/a/google.com/group/enterprise-data-questions/.
For more options, visit https://groups.google.com/a/google.com/d/optout.

[Vijay Subramani]

Ian, 

Can you see if one of the below options better fits your application needs?

• Move the on-premise data currently accessed through Secure Data Connector to Google Cloud Platform Cloud SQL, Cloud Storage, or Cloud Datastore.

• Expose the on-premise data, currently accessed through Secure Data Connector, using a secure on-premise service that is accessible from your cloud service applications hosted in Google Cloud Platform.

[Ian Ray]

Is there a guide to exposing and authenticating data for use in Google Sheets?

On Friday, February 27, 2015 at 9:12:22 AM UTC-8, Ray Colline wrote:

On Fri, Feb 27, 2015 at 8:43 AM, Ian Ray <ian...@cypressgrovechevre.com> wrote:

Is Google Cloud VPN a suitable replacement if all I want to do is have ImportData in Google Sheets?

This is not a suitable solution.  This allows Google Compute Engine VM instances to be on your local network.  Sheets run as a separate Google service.

 

As it is now, the only function I have left on google sdc is to push data to spreadsheets. What would be the proper replacement for this?

This is not a great answer but, whatever endpoint Sheets is grabbing data on needs to be available on the public internet.  You can use authentication, https and IP restrict to help mitigate the exposure of the endpoint.

Thanks!
Ray

 

--
You received this message because you are subscribed to the Google Groups "google-secure-data-connector" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-sdc+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "enterprise-data-questions" group.

To unsubscribe from this group and stop receiving emails from it, send an email to enterprise-data-questions+unsub...@google.com.

[Ray Colline]

On Tue, Mar 3, 2015 at 8:06 AM, Ian Ray <ian...@cypressgrovechevre.com> wrote:

Is there a guide to exposing and authenticating data for use in Google Sheets?

http://blog.redfin.com/devblog/2012/04/when_importdata_isnt_good_enough_retrieving_csv_files_behind_basic_auth_with_a_google_apps_script.html#.VPXxaHVGjUY

Support is not great and not out-of-the-box.  Sorry.   The basic process here is using apps script to fetch the data and do the authentication.   This requires javascript/appsscript programming knowledge.  This post describes basic-auth, however, you can change it to whatever auth you need again assuming you have the programming and authentication system knowledge.

As I said earlier, there is not a great solution for getting data from behind your firewall using sheets.  As Vijay points out, moving your functionality away from sheets and into GCP might help as private networking options are more fully supported.

HTH!
Ray

 

To unsubscribe from this group and stop receiving emails from it, send an email to enterprise-data-qu...@google.com.