What do you want to automate

with Oracle Cloud Infrastructure and Microsoft SQL Server?

import * as common from "oci-common";
import * as identity from "oci-identity";

export default defineComponent({
  props: {
    oracle_cloud_infrastructure: {
      type: "app",
      app: "oracle_cloud_infrastructure",
    },
  },
  async run({ steps, $ }) {
    const tenancyId = this.oracle_cloud_infrastructure.$auth.tenancy_id;
    const userId = this.oracle_cloud_infrastructure.$auth.user_id;
    const fingerprint = this.oracle_cloud_infrastructure.$auth.fingerprint;
    const regionStr = this.oracle_cloud_infrastructure.$auth.region;
    const privateKey = this.oracle_cloud_infrastructure.$auth.private_key;

    // Convert the region string into a Region object
    const region = common.Region.fromRegionId(regionStr);

    // Create a simple authentication provider using your credentials.
    // If your private key has a passphrase, replace null with the passphrase.
    const provider = new common.SimpleAuthenticationDetailsProvider(
      tenancyId,
      userId,
      fingerprint,
      privateKey,
      null, // passphrase (if needed)
      region
    );

    // Create an IdentityClient using the provider.
    const identityClient = new identity.IdentityClient({
      authenticationDetailsProvider: provider,
    });

    // Prepare a request to list compartments for your tenancy.
    const listCompartmentsRequest = {
      compartmentId: tenancyId,
    };

    // Call the OCI API to list compartments.
    const response = await identityClient.listCompartments(listCompartmentsRequest);
    
    // The response object contains details such as items (the list of compartments).
    return response;
  },
});

import sql from "mssql"
export default defineComponent({
  props: {
    microsoft_sql_server: {
      type: "app",
      app: "microsoft_sql_server",
    }
  },
  async run({steps, $}) {
    const { host, username, password, port, database, encrypt,trustServerCertificate } = this.microsoft_sql_server.$auth
    const conn_str = `Server=${host},${port};Database=${database};User Id=${username};Password=${password};Encrypt=${encrypt};TrustServerCertificate=${trustServerCertificate}`;
    await sql.connect(conn_str);
    return await sql.query`SELECT GETDATE()`
  },
})