Gateway advises Sql.Database() function is unsupported

Hi Mixednuts ,

We get a solution to create a database without database name by using RESTful API.

1. we encode the credential with C# refer to this document:https://docs.microsoft.com/en-us/power-bi/developer/encrypt-credentials

using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp2
{
    class Program
    {




        static void Main(string[] args)
        {
            var credentials = "{\"credentialData\":[{\"name\":\"username\", \"value\":\"UserName\"},{\"name\":\"password\", \"value\":\"Password\"}]}";
            var result =    AsymmetricKeyEncryptionHelper.EncodeCredentials(credentials, "Place-Yuor-Exponent-Here", "Place-Yuor-Modulus-Here");

            Console.WriteLine(result);
            Console.ReadLine();
        }


    }

    public static class AsymmetricKeyEncryptionHelper
    {

        private const int SegmentLength = 85;
        private const int EncryptedLength = 128;

        public static string EncodeCredentials(string credentials, string publicKeyExponent, string publicKeyModulus)
        {
            using (RSACryptoServiceProvider rsa = new RSACryptoServiceProvider(EncryptedLength * 8))
            {
                var parameters = rsa.ExportParameters(false);
                parameters.Exponent = Convert.FromBase64String(publicKeyExponent);
                parameters.Modulus = Convert.FromBase64String(publicKeyModulus);
                rsa.ImportParameters(parameters);
                return Encrypt(credentials, rsa);
            }
        }

        private static string Encrypt(string plainText, RSACryptoServiceProvider rsa)
        {
            byte[] plainTextArray = Encoding.UTF8.GetBytes(plainText);

            // Split the message into different segments, each segment's length is 85. So the result may be 85,85,85,20.
            bool hasIncompleteSegment = plainTextArray.Length % SegmentLength != 0;

            int segmentNumber = (!hasIncompleteSegment) ? (plainTextArray.Length / SegmentLength) : ((plainTextArray.Length / SegmentLength) + 1);

            byte[] encryptedData = new byte[segmentNumber * EncryptedLength];
            int encryptedDataPosition = 0;

            for (var i = 0; i < segmentNumber; i++)
            {
                int lengthToCopy;

                if (i == segmentNumber - 1 && hasIncompleteSegment)
                    lengthToCopy = plainTextArray.Length % SegmentLength;
                else
                    lengthToCopy = SegmentLength;

                var segment = new byte[lengthToCopy];

                Array.Copy(plainTextArray, i * SegmentLength, segment, 0, lengthToCopy);

                var segmentEncryptedResult = rsa.Encrypt(segment, true);

                Array.Copy(segmentEncryptedResult, 0, encryptedData, encryptedDataPosition, segmentEncryptedResult.Length);

                encryptedDataPosition += segmentEncryptedResult.Length;
            }

            return Convert.ToBase64String(encryptedData);
        }
    }
}

The Exponent and Modulus can be find with the Get Database API

2. then we can use the Create Data Source API to create it, the body is like following:

{
  "dataSourceType": "SQL",
  "connectionDetails": "{\"server\":\"localhost\",\"database\":\"\"}",
  "datasourceName": "Test100",
  "credentialDetails": {
    "credentialType": "Basic",
    "credentials": "Generated-Credentials",
    "encryptedConnection": "Encrypted",
    "encryptionAlgorithm": "RSA-OAEP",
    "privacyLevel": "None"
  }
}

But the main point is expanding the result of Sql.Databases() instead of create another column using Sql.Database().

Best regards,