You may have to surround the table name or schema with double quotes ... View more

Hi SAS Business Data Network is a business glossary not a data catalog. You SAS libraries and tables are automatically populated as part of SAS lineage. If you still want to import your tables and libraries as terms, you can export your tables for each library through the metadata export and create an excel file to be imported into bdn. ... View more

The document attached is 8 years old but what is described still applies. ... View more

You can find some details here https://media.datadirect.com/download/docs/odbc/allodbc/index.html#page/odbc/the-sql-server-legacy-wire-protocol-driver.html ... View more

It is one best practice to name the ODBC connections the same way between clients and servers. If not possible you will have to use macros ie "%%ODBCSQL%%" and to specify the corresponding ODBC string in your local macro file.   ... View more

Hi Shikha   Within SAS DataFlux Data Management Studio, you can create a custom metric to be used within a profile job. Typically for your SSN   You can also use regular expressions for checking dates.         ... View more

As far as I know, you don't have to, as the sheet is already a range (Sheet1$).     ... View more

Hi I don't think using the document conversion node is the way to go. Would suggest to download and install Microsoft Access Runtime which does provide the MS Excel ODBC drivers. Next you use an sql query node with the following connection string in the DSN value: DBQ=C:\MyFolder\current BLIO promos.xls;Driver={Microsoft Excel Driver (*.xls)};DriverId=790;MaxBufferSize=2048;PageTimeout=5;HDR=Yes;IMEX=1;ReadOnly=0;DFXTYPE=ODBC or DBQ=C:\MyFolder\current BLIO promos.xlsx;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};MaxBufferSize=2048;PageTimeout=5;HDR=Yes;IMEX=1;ReadOnly=0;DFXTYPE=ODBC   and in the SQL_STMT --> Select * from [Sheet1$]   You may need to adapt some of these above   ... View more

And yes you can import export data profiling jobs (not reports), rules from on repository to another (file or db) ... View more

Strange that the file has been removed ... View more

Hi   Find in attachment the process job mentioned in the blog. It allows to extract data profiling metrics from a DataFlux repository (file or db). Hope that helps   Vincent ... View more

Hi I could try to write the code for you, but I doubt it will work directly as I won't be able to test it with your RULES table. As an example the following code lets you get a list of tables in a particular database. // Set Expression node to "Generate row when no parent is specified" to true //Pre Expression string DSN DSN="DataFlux Sample" string connectStr //Preparing the connection string connectStr = "DSN=" & DSN DBConnection dbConn dbConn = dbConnect( connectStr ) string tablename string datapath string tcatalog string tabletype DBCursor cursTables //Retrieve table information in a cursor cursTables = dbConn.tablelist(); //Iterate through the cursor while( cursTables.next() ) begin datapath = cursTables.valuestring(0); tcatalog = cursTables.valuestring(1); tablename = cursTables.valuestring(2); tabletype = cursTables.valuestring(3) pushrow() end cursTables.release(); //Expression seteof() return false ... View more

Hi   Each node has a start time and end time that can be reused in macro variables. You can either use a If/Then node or an expression node, or even an alert for triggering your process job 10min later. ... View more

Hi   Well the answer to your question is "Yes". However the expression cannot create fields in data monitoring, they have to exist before. Therefore the solution is to create a field "COMMENT" and to use it in your rule. When calling the task you will map it with an empty dummy field. Although, it is probably redundant to have this field as your rule will only trigger records that match your condition ... therefore all return rows will contain an ADDRESSE IN ADDRESS LINE1 ... You can use the different attributes of the rule for storing this comment and reuse it in the output of Data Monitoring.   Hope that helps ... View more