The most recent content from our members.
Hello! Has anyone noticed slowness/failures in their DAP processes? We use the incremental CLI from DAP overnight starting around 1 AM Arizona Time. It was taking 15-20 minutes for a sync to occur. Then around 4/17 to now it's taking over an hour. Last night we even got 500 errors from the DAP Api and one of our other…
Hi everyone, I'm exploring some changes to how the DAP Query API handles schemas, and I want to hear from you before we go too far down any path. Here's the situation. The DAP schema today is fairly sophisticated. It defines specific enum values, type constraints, and so on. That gives you a strong data contract, but it…
We'd like to time our syncdb commands so we know what time index we're pulling down data FROM. Currently we're doing it once every 24 hours automatically, but we occasionally have need, in a given business day, to sync changes that have been made and it would be very helpful to know if we're going to be getting data from…
Hey folks I've finally managed to wrestle all of my DAP queries into Power Bi dataflows, and it was quite an ordeal. I'm currently using dataflows with DAP as a surrogate databasing solution as we do not currently have access to a SQL server that can store our info, otherwise I would probably be fetching this data using…
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…
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.