DataAI ETL SSIS - Customer-Ready Evaluation

Start here: Download one customer-ready ZIP. It already contains the DataAI libraries, product assets, documentation, samples, licenses, internal checksums, and local verification files for this integration. Spark, Hadoop, vendor products, and proprietary drivers remain customer-provided.

SSIS: Customer Evaluation Installation and Usage

This is the customer-ready DataAI ETL evaluation package from Yanbor LLC, provider of the DataAI product. DataAI runs inside the customer's pipeline; it is not a hosted service and makes no required DataAI network call.

Prerequisites

• Java 17
• Apache Spark 3.5.0 with Scala 2.12
• SSIS execution host able to invoke the approved Spark job

Installation and first verification

1. Review LICENSE.md and extract the ZIP on the approved SSIS execution host.
2. Run smoke-test\run-smoke-test.ps1 to verify the delivered DataAI libraries with fictional in-memory rows.
3. Use an SSIS Execute Process Task or an approved scheduler to invoke spark-submit with lib\dataai-spark-cli-0.1.0-SNAPSHOT.jar and a customer-owned JSON configuration.
4. Keep credentials in the customer's SSIS/Spark secret mechanism; do not put them in DataAI configuration files.
5. Verify clean, rejected, findings, and profile tables in isolated evaluation schemas. No SSIS MSI is included.

Evaluation boundary

• Use only fictional or approved non-production data.
• Review LICENSE.md; the standard evaluation is less than 32 consecutive calendar days.
• DataAI software is provided AS IS, with no obligations except those expressly accepted in a signed commercial agreement or order form.
• Spark, Hadoop, cloud platforms, BI tools, orchestration products, and vendor drivers remain customer-provided and governed by their respective terms.
• A successful local smoke test validates the delivered DataAI artifacts. It does not claim certification on the customer's external platform.

Package layout

• install/: platform-specific installer or packages, when applicable.
• lib/: DataAI JARs required by Spark-based integrations.
• smoke-test/ or nuget-smoke-test/: executable local verification.
• docs/: complete function catalog and product-specific guidance.
• samples/: fictional evaluation inputs.
• platform/: platform-specific examples, notebooks, configuration, POMs, or container-review assets.
• PACKAGE_CONTENTS.sha256: SHA-256 for every other file in this ZIP.

.\smoke-test\run-smoke-test.ps1

powershell.exe -NoProfile -ExecutionPolicy Bypass -File `
  .\smoke-test\run-smoke-test.ps1

.\smoke-test\run-smoke-test.ps1 `
  -SparkSubmit 'C:\spark\bin\spark-submit.cmd'

Verify the downloaded ZIP

$expected = (Get-Content .\DataAI_ETL_SSIS_Evaluation.zip.sha256).Split()[0]
$actual = (Get-FileHash .\DataAI_ETL_SSIS_Evaluation.zip -Algorithm SHA256).Hash.ToLowerInvariant()
if ($actual -ne $expected) { throw 'DataAI ETL package checksum mismatch.' }