The most recent content from our members.
Hi, When I try to export a table through dap intidb command for a table from canvas space: context_module_progress. I use the following command: dap --loglevel debug initdb --connection-string "mssql://username:password@prodsqlserver.database.windows.net/canvas-prod?driver=ODBC+Driver+18+for+SQL+Server" --namespace canvas…
Hi, I am trying to load two tables from canvas namespace into SSMS through the use of DAP command line interface: This is the command that I am using: dap initdb --connection-string "mssql://username:password@princedev.database.windows.net:1433/princedb_qa?driver=ODBC+Driver+18+for+SQL+Server" --namespace canvas --table…
Hello, I'm posting here for our developer. I hope someone can help steer us in the right direction. We have been running the CD2 API for almost a year. We have run a full reload of the tables once with a column addition, and process delta runs daily. I happened to notice that our courses table is not receiving updates when…
Hi there, We're new to the DAP CLI (for MSSQL) and we managed to get the initdb and syncdb working with MSSQL using SQL Authentication. However does anyone managed to connect to the MSSQL with Windows Authentication and if so, how should the connection string be looked like? Many thanks in advance! WL
Will the DAP client support other databases (specifically MS SQL Server)? If so, is there an estimated timeline for this? It seems the DAP client is the best tool for building an automated pipeline to a data warehouse and does a lot of the work that would otherwise be tedious via the API.
When running the following from the command-line, I get an error that prevents me from synchronizing the collaborations table: >dap initdb --namespace canvas --table collaborations 2025-02-12 14:16:09,376 - INFO - Query started with job ID: 5bb1d1c0-595b-4bfb-8bdb-feb74c21f521 2025-02-12 14:16:09,516 - INFO - Data has been…
I created a shell script that uses the DAP client to run the CD2 sync commands. The script works fine when run manually, but when I try to schedule it with CRON it fails with the stacktrace below. DAP Client Version: 0.3.10 I simplified the script to run a single "dap list" command and I still receive the error CRONOUTPUT:…
Hello, I was poking around the DAP client documentation and noticed that there's pretty robust documentation for creating a dialect plugin. Has anyone in the community developed an Oracle or Microsoft SQL dialect plugin for the DAP client yet? The CD2 transition has snuck up on us, and being able to integrate directly with…
I'm working with CD2 in PostgreSQL and I'm noticing that CD2 seems to take an opinionated stance on data types with many columns being user defined (typically enums). For example, `context_type` in `lti_resource_links` is of type `lti_resource_links__context_type` I'm just curious about the rationale? Mostly because I'm…
Note: Relying on my DBA since some of this is a bit over my head. Our scheduled "dap syncdb" process keeps blowing up our CPU. Our DBA used an "explain plan" to see where our performance issue are. Below is the SQL running a loop while sorting through a huge number of rows (18,589,175,389,900). Any assistance with this…
Sign in to enhance your access to articles, forums, and events—and to participate by sharing insights, engaging in discussions, and connecting with your network of edtech peers.