Create a Data Source. The currently authenticated user of the GoodData platform will become the owner of the newly created Data Source.</br> Request body parameters </br>

• name (string) specifies the name of the Data Source.
• prefix (Snowflake, Redshift, BigQuery, PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics; string) specifies the prefix that defines what tables and views will be populated to the GoodData platform. Example: pre_
• alias (string) specifies the alias of the Data Source; can be considered a secondary identifier.
• connectionInfo (string) specifies the type of the data warehouse or object storage service. Specify one of the following:
  • redshift
  • snowflake
  • bigQuery
  • postgres
  • mssql
  • mysql
  • s3
  • blobStorage
  • generic
• url (Snowflake, Redshift, PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics; string) specifies the JDBC connection string that is used to connect to the data warehouse.
• authentication specifies authentication information that is used to connect to the data warehouse.
  • (Snowflake, Redshift, PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics) Basic user-password authentication
    • userName (string) specifies the user who is used for the connection.
    • password (string) specifies the user's password. When returned in the response, the password is not visible and is replaced with an empty string.
  • (Snowflake only) Key-pair authentication
    • userName (string) specifies the user who is used for the connection.
    • privateKey (string) specifies private key in ??? format
    • passPhrase (string, optional) specify passphrase to decrypt private key
  • (Redshift only) IAM key-based access control authentication
    • dbUser (string) specifies the Redshift database user.
    • accessKeyId (string) specifies the access key ID for the IAM user who is authorized to access the Redshift data warehouse.
    • secretAccessKey (string) specifies the secret access key for the IAM user. When returned in the response, the secret access key is not visible and is replaced with an empty string.
  • (BigQuery only) Service account authentication
    • clientEmail (string) specifies the BigQuery user email.
    • privateKey (string) is the private key for the BigQuery user. When returned in the response, the private key is not visible and is replaced with an empty string.
  • (Azure SQL Database or Azure Synapse Analytics) Azure Active Directory user-password authentication
    • userName (string) specifies the user who is used for the connection.
    • password (string) specifies the user's password. When returned in the response, the password is not visible and is replaced with an empty string.
• database (Snowflake, Redshift, PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics; string) specifies the name of the database where the schema you want to use is located.
• schema (Snowflake, Redshift, BigQuery, PostgreSQL, Microsoft SQL Server, Azure SQL Database, or Azure Synapse Analytics; string) specifies the name of the schema where data marts are located.
• warehouse (string; Snowflake only) specifies the name of the Snowflake data warehouse (computing unit) for integrating queries.
• project (string; BigQuery only) specifies the name of the BigQuery project.
• params (generic only) specifies parameters as a key/value pair.
• secureParams (generic only) specifies secure parameters as a key/value pair. When returned in the response, the values of the secure parameters are not visible and are replaced with empty strings.
• s3 (S3 only) specifies the S3 location where your configuration file is stored (you may or may not also use this S3 location to store the source data).
  • bucket (string) specifies the name of the S3 bucket.
  • accessKey (string) specifies the access key to the S3 bucket.
  • secretKey (string) specifies the secret key to the S3 bucket. When returned in the response, the secret key is not visible and is replaced with an empty string.
  • region (string; optional) specifies the code of the region of the S3 bucket. If not set, defaults to us-east-1. For the list of the region codes, see AWS service endpoints.
  • serverSideEncryption (boolean) specifies whether server-side encryption is enabled.
• blobStorage (Azure Blob Storage only) specifies the Azure Blob Storage location and authentication information that is used to connect to the object storage service.
  • container (string) specifies the name of the container.
  • rootPath (string) specifies the path to the source data.
  • connectionString (string) specifies the connection string to the Azure Blob Storage location.
• sslMode (PostgreSQL, Microsoft SQL Server, MongoDB BI Connector, MySQL, Azure SQL Database, or Azure Synapse Analytics) specifies the SSL mode to use when connecting to the database. Can be prefer, require, or verify-full.
  • prefer enables encryption if the server supports encryption.
  • require connects only if the server supports encryption.
  • verify-full connects to a server you specify only if it supports encryption and is trusted.
• databaseType Specifies which SQL product to use depending on what value is used for connectionInfo. (string)
  • To use Microsoft SQL Server, Azure SQL Database, or Azure Synapse Analytics Data Sources, connectionInfo must be to mssql. The value of databaseType can be one of either SQLServer, AzureSQL, or SynapseSQL.
  • To use a MongoDB BI Connector data source, connectionInfo must be set to mysql and the value of databaseType must be set to MongoDBConnector.

{
  "dataSource": {
    "name": "{data_source_name}",
    "prefix": "{data_source_prefix}",
    "alias": "{data_source_alias}",
    "connectionInfo": {
      "mssql": {
        "authentication": {
          "activeDirectoryPassword": {
            "userName": "{username}",
            "password": "{password}"
          }
        }
      }
    }
  }
}

{
  "dataSource": {
    "name": "{data_source_name}",
    "prefix": "{data_source_prefix}",
    "alias": "{data_source_alias}",
    "connectionInfo": {
      "mssql": {
        "authentication": {
          "activeDirectoryPassword": {
            "userName": "{username}",
            "password": "{password}"
          }
        }
      }
    },
    "id": "{data_source_id}",
    "owner": "{data_source_owner}",
    "domain": "{domain_name}",
    "lastModified": "{last_modified_timestamp}",
    "links": {
      "self": "/gdc/dataload/dataSources/{data_source_id}",
      "parent": "/gdc/dataload/dataSources",
      "dataMapping": "/gdc/dataload/dataSources/{data_source_id}/dataMapping",
      "buildModelMapping": "/gdc/dataload/dataSources/{data_source_id}/buildModelMapping",
      "generateModel": "/gdc/dataload/dataSources/{data_source_id}/generateModel",
      "generateOutputStage": "/gdc/dataload/dataSources/{data_source_id}/generateOutputStage",
      "validateConnection": "/gdc/dataload/dataSources/{data_source_id}/validateConnection"
    }
  }
}