Restritcting Access to Database

manuwell

Hi, 

 

How can we plug a database without exposing it into the wild internet? 

 

Thinking here, is there a way to restrict the access to domo IP range? Or, there is an agent that we can configure on our cloud to send data to domo? 

 

Any kind of suggestion are welcome. 

 

Thanks,

alexpeay

@manuwell are you thinking about a hosted DataBase that is in your DataCenter?

 

A great option would be Workbench, it can be installed in your Data Center and then access the DataBase. Then the connection from Workbench to Domo is all that needs to be worried about. In this way you are not worrying about having the internet access your DB, just an on-premise application. 

 

Workbench can connect to any database that uses ODBC connections. It also allows for some data cleansing and normalization before you send the data up. 

manuwell

@alexpeay thanks for your suggestion but we think it woldn't be so helpful. We work on a linux stack and workbench depends of .NET framework to run as far as I could see. Is there any other solution for linux, an unix agent perhaps? 

 

We discovered Domo Beta Api. Is it ready to use? If so, how can we push data to domo? We couldn't find any docs about pushing data. =(

 

 

Thanks

alexpeay

In your case I would recommend going with the APIs. 

 

https://developer.domo.com/docs/domo-apis/data

manuwell

@alexpeay thanks for your suggestion but we think it woldn't be so helpful. We work on a linux stack and workbench depends of .NET framework to run as far as I could see. Is there any other solution for linux, an unix agent perhaps? 

 

We discovered Domo Beta Api. Is it ready to use? If so, how can we push data to domo? We couldn't find any docs about pushing data. =(

 

 

Thanks

woganmay

Hey @manuwell

 

What sort of scripting environment do you have on your side? I'm working on an unofficial PHP client for the Domo Data API, which currently supports creation and uploading of datasets.

manuwell

Hey @woganmay our stack is ruby based running on linux servers. 

A PHP client! I think you can help us!

 

What API route are you using to push data to DOMO? In docs we haven't found anything of how to push data, only how to create schemas, update, etc.

alexpeay

@woganmay are you using the APIs available here:

 

https://developer.domo.com/

 

woganmay

@manuwell There's two steps to uploading

 

1. Is to create the schema, which you have already

2. Is to use the Import route:

 

https://github.com/woganmay/domo-php/blob/master/src/DataSet.php#L74

 

You'll want to PUT to /v1/datasets/{GUID}/data, specifically with the Authorization and Content-Type headers, and send your CSV data in the body.

 

Note that the CSV data you send should NOT include the header row.

woganmay

Hi @alexpeay yes I am, and I'm having some trouble with updating and deleting datasets incidentally: https://dojo.domo.com/t5/Domo-Developer/API-Inconsistencies/m-p/14096#U14096