Restritcting Access to Database

manuwell
manuwell Member
in Archive

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,

Tagged:

Comments

  • alexpeay
    alexpeay Domo Employee

    @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. 

    Alex Peay
    Product Manager
    Domo
  • manuwell
    manuwell Member

    @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
    alexpeay Domo Employee

    In your case I would recommend going with the APIs. 

     

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

    Alex Peay
    Product Manager
    Domo
  • manuwell
    manuwell Member

    @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
    woganmay Member

    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
    manuwell Member

    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
    alexpeay Domo Employee

    @woganmay are you using the APIs available here:

     

    https://developer.domo.com/

     

    Alex Peay
    Product Manager
    Domo
  • woganmay
    woganmay Member

    @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
    woganmay Member

    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

This discussion has been closed.

Categories