BigID Developer Portal
BigID API/Add Data Source Tutorial: Difference between revisions

BigID API/Add Data Source Tutorial: Difference between revisions

From BigID Developer Portal
Line 23: Line 23:
You'll see our test system has around 70 different data source connectors installed. If you don't see a data source you want to use, [[Connectors|you can develop your own]] or it might already exist, just not on our system. [https://docs.bigid.com See the BigID docs for an exhaustive list.]
You'll see our test system has around 70 different data source connectors installed. If you don't see a data source you want to use, [[Connectors|you can develop your own]] or it might already exist, just not on our system. [https://docs.bigid.com See the BigID docs for an exhaustive list.]


== Calling an API ==
== Getting Data Source Parameters ==


Now that you have a session token we can directly call BigID APIs. Documentation for these APIs is available at https://www.docs.bigid.com/bigid/reference/api-getting-started . Since we're just trying to perform a simple task, we don't need the docs here, just to know that GET /ds-connections is the endpoint to retrieve a list of data source connections.  
Each type of data source has different parameters needed to connect to it. These parameters can be as simple as a username and password or as complex as rate limiting information. BigID uses templates to display these fields to the user in the UI. We can use those same templates to determine what we need to supply when adding a data source via the API. We're going to add a MySQL database. Use the below request to get the template for an rdb-mysql data source.
 
Add a new header named "Authorization" and paste the session token you got in the previous request to authenticate yourself.


<html>
<html>
<iframe style="border:0px; width:100%; height:400px; border-radius:10px;" src="https://apibrowser.mybigid.com/?url=ds-connections&method=GET&selectedSetting=headers"></iframe>
<iframe style="border:0px; width:100%; height:400px; border-radius:10px;" src="https://apibrowser.mybigid.com/?url=ds-connections-types/template/rdb-mysql&method=GET&selectedSetting=headers"></iframe>
</html>
</html>


In that API call, we can see a list of data sources and all the information for each data source.  
In that API call, we can see a list of data sources and all the information for each data source.  


<syntaxhighlight lang="JSON" lines>
{
    "status": "success",
    "statusCode": 200,
    "data": {
        "ds_connections": [
            "<data source info here>"
        ]
    }
}
</syntaxhighlight>




[[Category:Tutorial]][[Category:API]]
[[Category:Tutorial]][[Category:API]]

Revision as of 20:27, 27 October 2021

In this article, you'll learn:

  • How to list available data source connectors within a system
  • Where to find parameters required for a given data source
  • How to add a data source using the BigID API


scenarioYou have a custom system that maintains an inventory of your databases and have just purchased BigID to better understand what's inside those databases for an internal AI initiative. Your executive staff says this will "bring your organization into the modern age". Use the BigID API to add a data source to start your integration with the inventory system.

In this tutorial, we'll use SAMPLE as our session token. This is unique to the training sandbox and will not work in other environments. See BigID API/Tutorial for information on authenticating with BigID.

Discovering Data Sources

You can see what data source connectors are installed in your environment through the BigID UI, but since we're focused on the API (and because all actions in the UI can be performed in the API), we are going to use the API to retrieve them.

Press Send on the request below to get a listing of the data source connectors installed on our test BigID system.

You'll see our test system has around 70 different data source connectors installed. If you don't see a data source you want to use, you can develop your own or it might already exist, just not on our system. See the BigID docs for an exhaustive list.

Getting Data Source Parameters

Each type of data source has different parameters needed to connect to it. These parameters can be as simple as a username and password or as complex as rate limiting information. BigID uses templates to display these fields to the user in the UI. We can use those same templates to determine what we need to supply when adding a data source via the API. We're going to add a MySQL database. Use the below request to get the template for an rdb-mysql data source.

In that API call, we can see a list of data sources and all the information for each data source.

Retrieved from "https://developer.bigid.com/index.php?title=BigID_API/Add_Data_Source_Tutorial&oldid=487"