This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When attempting to Write to MySQL with the output option "Update: Insert if New" you get an error if the table has a composite primary key of multiple fields and none of the data have changed in the row
When trying to create a temporary table for use in the Data Input Tool (connecting to Google BigQuery) the workflow errors out with "Executing PreSQL: CREATE OR REPLACE TEMPORARY TABLE... Invalid query: Use of CREATE TEMPORARY TABLE requires a script or session"
When you try to insert a record to an Amazon Redshift table which has a column with attribute IDENTITY(seed, step), the record is inserted fine, but the value of the first column to be inserted is null instead of the value being passed into the Output Data tool.
API connections give access to many web-based applications, database systems, or programs by exposing objects or actions to a developer in an abstracted format that can easily be integrated into another program.
Connector tools that use "Sign in via Internet Browser" do not work correctly with Designer or Server 2021.3.2. To use those tools, you should upgrade to version 2021.3.3 or later and then download and install the tool version that says " Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 188.8.131.52061 or later.." Alternatively in the short term, you can use version 2021.3.1 of Designer or Server.