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 connecting to Oracle 12c using a connection string of the following format, Alteryx Designer is adding 100 more records to the result set.
e.g. If the number of rows in the database is 499 for a specific query, Alteryx Designer is duplicating the first 100 rows, showing 599 in the result set.
Input Data (16): 599 records were read from odb:Provider=OraOLEDB.Oracle;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SUSANK)));User Id=susan;Password=__EncPwd1__ (Select ...
The issue only occurs when using OLEDB to connect to Oracle.
Connect using the OCI option and utilize the TNSnames.ora file:
or enter the following if not using a TNSnames.ora file: